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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy and paste range of cells excluding hidden data in excel 3
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I avoid copying data from hidden rows/columns? 2
copying one column with hidden/filtered rows to another colum 2
Need to sum columns, excluding hidden columns. 7
Excel Help to copy information from one row at a time to another sheet 1
Counting Hidden Rows 1

Back
Top