Viewing information after hiding columns / rows
 

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

--
Kind regards

Ann Shaw

Viewing information after hiding columns / rows
 

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

In article ,
Annie wrote:

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.

Viewing information after hiding columns / rows
 

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


--
Kind regards

Ann Shaw


"john" wrote:

No easy way as far as I know but you could hold the Ctrl key and select the
columns you want and then paste them into the new sheet. This will paste the
columns together with out the missing columns
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Annie" wrote:

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

--
Kind regards

Ann Shaw