Hi,

Select the entire range and press Alt+; (this is the shortcut key to select
visible cells only). Now when you copy and paste, only te visible cells
would be copied

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sarah" wrote in message
...
I am trying to hide information in Excel. I hid the row I wanted to hide.
I
can see hidden row when copy and paste information in new excel file. Is
there a way to hide information?