copying and pasting with hidden rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I insert subtotals to my worksheet. I want to copy this, meaning just the
subtotals excluding the hidden rows, how do I do this?

thanks,
del
 
Use the outlining symbols (to the left) to hide the details (only show the
subtotals).

Then select what you want to copy
Edit|goto|special
check visible cells only
edit|copy
go to the new sheet
edit|paste
 
thanks. that works.

Dave Peterson said:
Use the outlining symbols (to the left) to hide the details (only show the
subtotals).

Then select what you want to copy
Edit|goto|special
check visible cells only
edit|copy
go to the new sheet
edit|paste
Click to expand...
 

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

Getting Text data using the Data - Subtotal feature 1
copy and paste if 1
Conditional SUBTOTAL in XL210 Table 7
Copying from Subtotal Data 2
DELETING SUBTOTALS FROM A COLOMN 1
Fill down visible cells only 4
Need to sum columns, excluding hidden columns. 7
How do I copy a range in Excel without including hidden rows? 1

Back
Top