Excluding hidden columns and rows when copying to another workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I print part of a worksheet that has hidden columns and rows - the hidden columns and rows do not print. That's what I want. Now--I'd like to take that same data and copy it to another workbook excluding the formulas and hidden columns and rows so that the new file contains only the data as was printed. How can I do that?
 
PJ

Select your range including hidden rows and columns then Edit>Go
To>Special>Visible cells only>OK

Now do your copy/paste.

Gord Dibben Excel MVP
 
PJ

Press Ctrl-5 (Go To) | Special... | Visible cells only.
Press Ctrl-C to copy the cells that have been selected.
Go to the target workbook and press Ctrl-V to paste the data

Regards

Trevor


PJ said:
When I print part of a worksheet that has hidden columns and rows - the
Click to expand...
hidden columns and rows do not print. That's what I want. Now--I'd like to
take that same data and copy it to another workbook excluding the formulas
and hidden columns and rows so that the new file contains only the data as
was printed. How can I do that?
 
Back
Top