paste excel sheet excluding hidden rows
 

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

paste excel sheet excluding hidden rows
 

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

paste excel sheet excluding hidden rows
 

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

paste excel sheet excluding hidden rows
 

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