Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste hidden rows | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
How do I stop an Excel sheet from automatically hiding rows when . | Excel Worksheet Functions | |||
Adding Rows to Master Sheet | New Users to Excel |