copy and paste hidden rows

T

tracykrulich

I have subtotaled a document and now I want to copy and paste only the
rows that are showing. Is there a way to NOT copy and paste the hidden
rows? Any help is MUCH appreciated!
 
B

Bernie Deitrick

Tracy,

Have you tried this prior to copying? Select your range, then use Edit / Go To... Special...
Visible Cells Only, Ok.

HTH,
Bernie
MS Excel MVP
 

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

Copy subtotals without hidden rows 2
Hidden cells 1
Macro to open CSV files 6
Copy and Paste hidden rows 1
Do not paste in hidden cells 9
Additonal info into newly created Subtotal row 1
Sub-Totals Question 1
Excel 2007 - copying filtered data to another workbook 1

Top