Can't Unhide Column A & B


D

Dave

Hide Columns A & B and now I can't figure out how to Unhide them. The
obvious doesn't seem to work. Been here, done that, before but got them
back somehow. Guess it's time I found out the right way to do it.

Thx all
Dave
 
Ad

Advertisements

D

Dave Peterson

Some things to try:
Window|Unfreeze panes
then scroll to the left (maybe they were just behind that frozen pane)

Edit|goto
type: a1:b1
and hit enter
format|column|unhide
 
E

EdMac

Hi Dave,

Click on the top left square (intersect of Cols and Rows), FORMAT >
columns > Unhide

Ed
 
D

Dave

Thank you both - both ways work -

Now all I have to do is remember how to do it next time.

Thx again
Dave
 
M

mudraker

Another couple of ways

use the Goto command (f5) to go to a1 then select Format ?Columns > Un
hide.

Repeat for column b

2nd Method

Click on Column C header, whilst holding left mouse button down drag
mouse pointer to the left, let go left mouse button and follow your
normal method of unhiding columns
 
Ad

Advertisements

Joined
Mar 6, 2015
Messages
1
Reaction score
0
Hide Columns A & B and now I can't figure out how to Unhide them. The
obvious doesn't seem to work. Been here, done that, before but got them
back somehow. Guess it's time I found out the right way to do it.

Thx all
Dave
Dave, Thanks for the unfreeze tip! Mike
 

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