Copy and Paste hidden rows

  • Thread starter Thread starter DuncVern
  • Start date Start date
D

DuncVern

I would like to copy from one worksheet that has hidden
rows, and paste to another worksheet not including the
hidden rows. So only paste the data that is showing (not
hidden) from the first worksheet. Is this possible?
 
Hi
after selecting your range hit F5m click 'Special' and choose 'only
visible cells'
now copy and paste your data
 
You must log in or register to reply here.

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

Hidden cells 1
Hide columns based on row values 2
Disabling copy/paste hidden cells 4
Problem with Pasting into Filtered Fields 2
Excel 2007 - copying filtered data to another workbook 1
Copying worksheets with formulas in hidden columns 2
Pasting data with hidden columns 4
Do not paste in hidden cells 9

Back
Top