paste excel sheet excluding hidden rows

B

Bernie

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
 
M

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
 
F

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?
 
D

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.
 
Top