Unhiding Column A

J

John13

I am using Excel 2003 SP2 and I have a spreadsheet with column A
missing. I have followed all the Help Menu advice. I can navigate to
column A and hit Format Column Unhide or Format Column Width, but to no
avail.

It is either hidden or set to zero width, but in any case, it will NOT
show up. I have searched all the group postings, been to Microsoft.com
help (yea, right) and done everything I can think of. Even installed a
macro I found to unhide columns by macro.

Any help would be most appreciated.

John13
 
D

Don Guillett

try selecting the cells button to the left of the column headers and on top
of the row numbers>format>column>unhide
 
B

Bill Ridgeway

It doesn't matter if either the column width is set to zero or if it is
hidden. The result if the same. Normally to unhide a column you would
highlight one either side and click on <Format><Column><Unhide>. The problem
is that there is no column to the left of A. To get around this click on
the square to the north of the row headers and to the west of the column
headers click on <Format><Column><Unhide>.

Regards.

Bill Ridgeway
Computer Solutions
 
D

Dave Peterson

Make sure that the window isn't frozen with column A off the visible screen.

window|Unfreeze panes
scroll to the left
Unhide the column A if it's not visible
 

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