|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 7th, 2009, 06:30 PM
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
October 7th, 2009, 08:14 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
