Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dman
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default 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.



  #5   Report Post  
Posted to microsoft.public.excel.misc
Dman
 
Posts: n/a
Default 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




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
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
problem with column charts and two Y axes in Excel 2003 napofrog Charts and Charting in Excel 1 October 21st 05 03:04 AM
Duplicate & Zero Values in Lists (Excel 2003) ksp Excel Worksheet Functions 6 August 10th 05 09:04 AM
sort column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM
Problem opening Excel 2003 in a Small Business edition installing:function of Excel Excel Discussion (Misc queries) 1 April 11th 05 09:09 AM


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

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

About Us

"It's about Microsoft Excel"