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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy/paste with hidden rows don't want hidden parts to paste (https://www.excelbanter.com/excel-discussion-misc-queries/159250-copy-paste-hidden-rows-dont-want-hidden-parts-paste.html)

robynne

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

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?

JW[_2_]

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

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.

robynne wrote:
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?

All times are GMT +1. The time now is 01:48 PM.