Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I unhide column A of an excel spreadsheet?

I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I unhide column A of an excel spreadsheet?


You click on Help. you write Unhide column and you choose Hide or
display Rows or Columns.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=567122

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default How do I unhide column A of an excel spreadsheet?

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

Cheri P. wrote:
I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 180
Default How do I unhide column A of an excel spreadsheet?

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.

"Cheri P." wrote:

I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 430
Default How do I unhide column A of an excel spreadsheet?

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 P." wrote:

I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 709
Default How do I unhide column A of an excel spreadsheet?

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

"Cheri P." <Cheri wrote in message
...
I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?



  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,069
Default How do I unhide column A of an excel spreadsheet?

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

"Cheri P." wrote:

I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default How do I unhide column A of an excel spreadsheet?

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]

--
Mike

"Cheri P." <Cheri wrote in message ...
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM
Sort Excel Column on Fifth Character Dolores Excel Worksheet Functions 2 December 27th 05 11:59 PM
how do I unhide Excel 2003 spreadsheet rows with usual method. Sandy Excel Discussion (Misc queries) 2 July 13th 05 09:30 PM


All times are GMT +1. The time now is 09:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"