How do I copy rows with hidden rows between without unhiding data.

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

Guest

When I hide rows and then go to copy the remaining data to another worksheet
some of the hidden data appears and messes up columns that I have totals in.
 
Hi
try:
- first select your data range
- hit F5, click 'Special' and choose 'only visible cells'
- now copy + paste

--
Regards
Frank Kabel
Frankfurt, Germany

Biggie J said:
When I hide rows and then go to copy the remaining data to another worksheet
some of the hidden data appears and messes up columns that I have
Click to expand...
totals in.
 
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

Cannot unhide the hidden rows in my spreadsheet 3
Problem with hidden rows automatically unhiding 2
Unhide a row 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
hide, unhide column or row after protect worksheet 4
Hidden rows; can't unhide them 1
Unhide row formula 1
Unhide columns 2

Back
Top