paste excel sheet excluding hidden rows

[Guest]

I want to copy a sheet containing hidden rows and then copy & paste to a new
sheet excluding the hidden rows - how can I do this? Normal copy / paste
pastes the hidden rows too. Thanks, Bernie

 

[mickbarry]

Bernie,
If the cells were hidden as a result of filtering (Data Filte
Autofilter)
then ALT; (shortcut for GOTO Special Visible Cells only)
Ctrl C (Copy)
Ctrl V (Paste)

Hope it helps
Regards Mick Barr

 

[fbarbie]

What is the converse of this? What if you want to paste data so that it
only goes into rows and cells that remain after autofiltering?

 

[Debra Dalgleish]

When you paste, it will paste into a contiguous range, not the visible
cells in the filtered range.

Perhaps you could mark the visible rows, by putting an X in an adjacent
column. Then, sort by the marked column, and paste into the grouped cells.