Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Sort Excel Column on Fifth Character | Excel Worksheet Functions | |||
how do I unhide Excel 2003 spreadsheet rows with usual method. | Excel Discussion (Misc queries) |