ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   unhide column A in Excel 2003 edition (https://www.excelbanter.com/excel-discussion-misc-queries/57436-unhide-column-excel-2003-edition.html)

Dman

unhide column A in Excel 2003 edition
 
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

Chip Pearson

unhide column A in Excel 2003 edition
 
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




David McRitchie

unhide column A in Excel 2003 edition
 
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




David McRitchie

unhide column A in Excel 2003 edition
 
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.




Dman

unhide column A in Excel 2003 edition
 
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






All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com