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. |
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. |
All times are GMT +1. The time now is 06:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com