Viewing information after hiding columns / rows

A

Annie

Hi

If I hide a column or row and then copy and paste the remaining data how can
I just show that data on a new sheet without the hidden information.

Many thanks
 
J

JE McGimpsey

Before copying, select the cells you want to copy and choose
Edit/Goto/Special/Visible cells only.
 
A

Annie

Go Whitelink Raiders!!

Don't have much Ice Hockey in Ireland but what a great sport!!

Check out JE McGimpsey's answer to my question also!

Many thanks
 
Top