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
|