copy/paste with hidden rows don't want hidden parts to paste

G

Guest

I want to copy information in a column that has hidden rows and do not want
the hidden information to paste. Is there any way to copy only what is
showing?
 
J

JW

Highlight what you want to copy
Press Ctrl+G
Click the Special button
Select Visible Cells Only
Click OK
Now only the visible cells in your original selection are selected.
 

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
copying one column with hidden/filtered rows to another colum 2
paste special 3
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Copy and Paste with hidden columns remaining hidden 2
paste excel sheet excluding hidden rows 3
copy a page with hidden rows and only paste what is showing 2
Copy and paste - filtered data 2

Top