Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I hid only column "A" in a worksheet and I have not been able to unhide it
using the normal steps to unhide a column. Is there something special I must do when the hidden column is column "A" Any help would be appreciated |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Click the select all button (the gray rectangle above the row
numbers and to the left of the column letters) and then right click a column header and choose Unhide. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dman" wrote in message ... I hid only column "A" in a worksheet and I have not been able to unhide it using the normal steps to unhide a column. Is there something special I must do when the hidden column is column "A" Any help would be appreciated |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The easiest way would be to select column B and drag to the
select all cells button to the left, then Format, column, unhide. Another way type A or type A:A into the name box at the left of the formula bar, then Format, column, unhide --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dman" wrote in message ... I hid only column "A" in a worksheet and I have not been able to unhide it using the normal steps to unhide a column. Is there something special I must do when the hidden column is column "A" Any help would be appreciated |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
okay that was easier, since he said he only hid the A column.
"Chip Pearson" wrote in... Click the select all button (the gray rectangle above the row numbers and to the left of the column letters) and then right click a column header and choose Unhide. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the information-I was able to unhide column "A". I think the root
of my specific problem was that I needed to unfreeze the view windows I had set up before I tried to unhide the column. Thanks "David McRitchie" wrote: The easiest way would be to select column B and drag to the select all cells button to the left, then Format, column, unhide. Another way type A or type A:A into the name box at the left of the formula bar, then Format, column, unhide --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dman" wrote in message ... I hid only column "A" in a worksheet and I have not been able to unhide it using the normal steps to unhide a column. Is there something special I must do when the hidden column is column "A" Any help would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
problem with column charts and two Y axes in Excel 2003 | Charts and Charting in Excel | |||
Duplicate & Zero Values in Lists (Excel 2003) | Excel Worksheet Functions | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
Problem opening Excel 2003 in a Small Business edition | Excel Discussion (Misc queries) |