Can I SAVE AS while preserving hidden-nes of columns?

L

Laurel

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top