Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy outlined data in excel
in excel 2007 (or any version) - if i create an auto outline on a block of
data. then take it down to a level 2 both rows and columns. can i then copy just the outlined data to another worksheet? when i do, it seems to copy and paste even the data was was hidden when i narrowed down the outline. i've tried paste special, but none of the options seem appropriate. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy outlined data in excel
Hi,
highlight the information to be copied then hit CTRL + G, special, visible cells only,then copy, paste "cathyh" wrote: in excel 2007 (or any version) - if i create an auto outline on a block of data. then take it down to a level 2 both rows and columns. can i then copy just the outlined data to another worksheet? when i do, it seems to copy and paste even the data was was hidden when i narrowed down the outline. i've tried paste special, but none of the options seem appropriate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show or hide outlined data option in a protected worksheet? | Excel Discussion (Misc queries) | |||
Unprotection of outlined data in protected worksheet | Excel Discussion (Misc queries) | |||
Outlined Data in Excel | Setting up and Configuration of Excel | |||
Grouped/outlined data only graphs when visible | Charts and Charting in Excel | |||
Compressed Outlined Data Copy | Excel Discussion (Misc queries) |