software

I want to copy a sheet containing hidden rows and then copy amp; 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: www.excelforum.com/member.php...oamp;userid=31028
View this thread: 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: www.excelforum.com/member.php...foamp;userid=8110
View this thread: www.excelforum.com/showthread...hreadid=507181When 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:
gt; What is the converse of this? What if you want to paste data so that it
gt; only goes into rows and cells that remain after autofiltering?

--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html