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

B

Biggie J

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

Frank Kabel

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