copy outlined data in excel

  • Thread starter Thread starter cathyh
  • Start date Start date
C

cathyh

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.
 
Hi,
highlight the information to be copied then hit CTRL + G, special, visible
cells only,then copy, paste
 
Back
Top