Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying and pasting with hidden rows
I insert subtotals to my worksheet. I want to copy this, meaning just the
subtotals excluding the hidden rows, how do I do this? thanks, del |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying and pasting with hidden rows
Use the outlining symbols (to the left) to hide the details (only show the
subtotals). Then select what you want to copy Edit|goto|special check visible cells only edit|copy go to the new sheet edit|paste arcticale wrote: I insert subtotals to my worksheet. I want to copy this, meaning just the subtotals excluding the hidden rows, how do I do this? thanks, del -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying and pasting with hidden rows
thanks. that works.
"Dave Peterson" wrote: Use the outlining symbols (to the left) to hide the details (only show the subtotals). Then select what you want to copy Edit|goto|special check visible cells only edit|copy go to the new sheet edit|paste arcticale wrote: I insert subtotals to my worksheet. I want to copy this, meaning just the subtotals excluding the hidden rows, how do I do this? thanks, del -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying from columns to Rows | Excel Discussion (Misc queries) | |||
Copying and Pasting a Worksheet | Setting up and Configuration of Excel | |||
Row height changes when copying and pasting | Excel Discussion (Misc queries) | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions |