How do I unhide column A of an excel spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?
 
You click on Help. you write Unhide column and you choose Hide o
display Rows or Columns
 
Click on the intersection of the row and column identifiers to
highlight the complete sheet, then Format | Columns | Unhide. This
should reveal any hidden columns, not just column A.

If this doesn't work, it may be that your sheet is protected - Tools |
Protection | Unprotect Sheet, and you may have to provide a password.

Hope this helps.

Pete
 
Click in the name box (up and left from the first visible cell of the
worksheet), type A1 and hit enter. Then Format > Column > Unhide.
 
Left click on the upper left corner of the sheet (blank part kitty corner to
1 and A) to highlight the whole sheet and then 'unhide'...'column'
 
Cheri, select the square next to column A and above row 1, format column
unhide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
1. Make sure Freeze Panes is off. If Windows >> Unfreeze panes is available,
select it.

2. Click on the column heading for column B and drag over the box above the
row numbers. Select Format >> Column >> Unhide.

3. If column A is still not visible, it may have its column width set very
narrow (like 0.08). From B1, press the left arrow key to move to A1. Select
Format >> Column >> Width and enter 10.

Hope this helps,

Hutch
 
Try to do the following procedure.
1. Execute the commands; [Edit]-[Go to]
2. Write A1 in [Reference] box and then click [OK]
3. Execute the commands; [Format]-[Column]-[Width]
4. Write 10 in [Column width] box and then click [OK]
 
Back
Top