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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Copy and Paste with hidden columns remaining hidden 2
copying one column with hidden/filtered rows to another colum 2
Pasting current view 1
Not include hidden columns in copy paste 2
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
how do i copy/paste in excel without pasting hidden lines 1
copy and paste range of cells excluding hidden data in excel 3

Back
Top