| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying only unhidden rows
Hi there
Is it possible to only copy unhidden rows? I have spent ages hiding rows so that only sub total amount appears, but when I copy into a new sheet all the hidden rows copy at the same time :-( thanks Cathy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying only unhidden rows
Select the range of rows you want,(including hidden rows)
edit-goto-special-Select visible cells only "Cathy" wrote: Hi there Is it possible to only copy unhidden rows? I have spent ages hiding rows so that only sub total amount appears, but when I copy into a new sheet all the hidden rows copy at the same time :-( thanks Cathy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying only unhidden rows
Select the area with the visible and hidden rows and tap F5.
Click special and select visible cells only and then Ctrl+c Go the your new range and Ctrl+V Mike "Cathy" wrote: Hi there Is it possible to only copy unhidden rows? I have spent ages hiding rows so that only sub total amount appears, but when I copy into a new sheet all the hidden rows copy at the same time :-( thanks Cathy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print only unhidden rows | Excel Worksheet Functions | |||
| How do I copy only the unhidden rows/colums? | Excel Discussion (Misc queries) | |||
| How do I protect hidden rows from being unhidden? | Excel Worksheet Functions | |||
| sumif only for unhidden rows | Excel Worksheet Functions | |||
| Excel- Saving only unhidden rows | Excel Discussion (Misc queries) | |||
Linear Mode
