copy outlined data in excel

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.
 
E

Eduardo

Hi,
highlight the information to be copied then hit CTRL + G, special, visible
cells only,then copy, paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special Values 2
Getting Text data using the Data - Subtotal feature 1
Copy-Paste Chart into Word from Excel 2007 3
Copy/Paste with Hidden Rows/Columns Excel 2007 3
COPY EXCEL 2007 9
I can't copy and paste equations 0
How copy none excel data & paste in 2007 without overwriting data 2
VBA - retrieve data on last create named range from previous inserted named range 0

Top