unhide only some columns

J

Jamie Martin

I often work with big documents and need to unhide the column to the left or
the right of a visible one. Is there a way to unhide only some of a
contiguous group of hidden columns?
 
J

Jordon

I often work with big documents and need to unhide the column to the left or
the right of a visible one. Is there a way to unhide only some of a
contiguous group of hidden columns?

F5 (Go To)
Enter a cell in the hidden column.
Format / Column / Unhide

Jordon
 
S

Steve McBride

Jamie,

I use Goto (F5 key) and enter the columns -- for example, say that columns C
through G were hidden and I want to unhide D and F --

Press F5 and in the Reference field enter d : d,f: : f (here I used extra
spaces for posting clarity) and click OK, then do Format> Cells> Unhide

HTH,
Steve
 

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

Similar Threads


Top