View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Can I SAVE AS while preserving hidden-nes of columns?

Copy the visible range to a temporary location (a temporary worksheet).
(ctrl-g, special|visible cells only)

Then copy from there and paste to MSWord.

Laurel wrote:

I have a spread sheet that I would like to turn into a text or Word
document, but I want to preserve the hiddennes of the columns? But when I
use SAVE AS to a Uniary Text type, .txt, all the columns are visible.

I'm very surprised that I can't convert it to a Word document. Maybe I'm
missing something somewhere?

TIA
LAS


--

Dave Peterson