paste excel sheet excluding hidden rows

[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

[mickbarry]

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

Hope it helps
Regards Mick Barry

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

fbarbie wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html