View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I copy a worksheet so that hidden columns remain secret?

Vanessa,

Select your columns then

F5|special|visible cells only

Then do you copy and paste.

Mike

Select

"Vanessa Long" wrote:

I want to copy the visible information only on a worksheet with hidden
columns. I would like the reader to think there are no hidden columns and
that the information on the screen is all there is. Help!