Copying only unhidden rows
 

Hi there

Is it possible to only copy unhidden rows? I have spent ages hiding rows so
that only sub total amount appears, but when I copy into a new sheet all the
hidden rows copy at the same time :-(

thanks

Cathy

Copying only unhidden rows
 

Select the range of rows you want,(including hidden rows)
edit-goto-special-Select visible cells only

"Cathy" wrote:

Hi there

Is it possible to only copy unhidden rows? I have spent ages hiding rows so
that only sub total amount appears, but when I copy into a new sheet all the
hidden rows copy at the same time :-(

thanks

Cathy

Copying only unhidden rows
 

Select the area with the visible and hidden rows and tap F5.

Click special and select visible cells only and then Ctrl+c

Go the your new range and Ctrl+V

Mike

"Cathy" wrote:

Hi there

Is it possible to only copy unhidden rows? I have spent ages hiding rows so
that only sub total amount appears, but when I copy into a new sheet all the
hidden rows copy at the same time :-(

thanks

Cathy