| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I NOT copy hidden rows to a new worksheet?
I have a large spreadsheet and have hidden rows. I do not want to copy the
hidden rows into a new spreadsheet. How do I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I NOT copy hidden rows to a new worksheet?
EditGo ToSpecial, check Visible cells only before you Copy
-- Kind regards, Niek Otten "Steve" wrote in message ... I have a large spreadsheet and have hidden rows. I do not want to copy the hidden rows into a new spreadsheet. How do I do that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I NOT copy hidden rows to a new worksheet?
After selecting, and before copying, use Edit-Goto-Special and click
Visible Cells Only, followed by OK. Now you can copy and paste as you wish "Steve" wrote: I have a large spreadsheet and have hidden rows. I do not want to copy the hidden rows into a new spreadsheet. How do I do that? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I NOT copy hidden rows to a new worksheet?
ONe way, is go ahead and copy the hidden cells and then use the feature in
ASAP Utilities to delete them. Available free at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Steve" wrote: I have a large spreadsheet and have hidden rows. I do not want to copy the hidden rows into a new spreadsheet. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste excel sheet excluding hidden rows | Excel Discussion (Misc queries) | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
| Can not copy a worksheet to another workbook | Excel Discussion (Misc queries) | |||
| Hidden rows | Excel Discussion (Misc queries) | |||
| Display selected rows from one worksheet to another | Excel Worksheet Functions | |||
Linear Mode
