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

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


--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: http://www.excelforum.com/member.php...o&userid=31028
View this thread: http://www.excelforum.com/showthread...hreadid=507181

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?


--
fbarbie
------------------------------------------------------------------------
fbarbie's Profile: http://www.excelforum.com/member.php...fo&userid=8110
View this thread: http://www.excelforum.com/showthread...hreadid=507181

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