Excel: copy and paste only shown not hidden cells into new sheet

G

Guest

I have a worksheet in which I hide information when I don't want to use it,
and make custom views. Now, I would like to take this a step further. How
can I copy this custom view and paste it into a new worksheet without all of
the hidden rows and columns coming with it?
 
D

Dave Peterson

Select the range to copy
edit|goto|special
click visible cells only

Edit|copy
and
edit|paste
 

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/Paste with Hidden Rows/Columns Excel 2007 3
Re-post: Code to make sheet very hidden based on date 1
Copy, paste 2
To paste copied data in filtered/visible cells only 1
Protect Worksheet from Copy Past 3
Copy and paste - filtered data 2
copy outlined data in excel 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Top