Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 69
Default If column A is invisible?!

Hi,

In a worksheet I have column A is invisible and no matter what I do I
can't see it! "Hide/Unhide" didn't work!

How can I make column A visible?

Thanks,
jo

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 638
Default If column A is invisible?!

You should be able to select from column B over to the row numbers and
then select Format|Column|Unhide
If that doesn;t work for some reason, you can use the code below to
unhide column A:
Sub unhideA()
Columns(1).Hidden = False
End Sub

Or use this code to unhide all columns:
Sub unhideAll()
Columns.Hidden = False
End Sub
Jo wrote:
Hi,

In a worksheet I have column A is invisible and no matter what I do I
can't see it! "Hide/Unhide" didn't work!

How can I make column A visible?

Thanks,
jo


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 989
Default If column A is invisible?!

try two things:

1) Make sure Window-Freeze Panes is OFF

2) make sure the column width is not 0.

hit F5
type A1 , hit OK
Format-Column Width



"Jo" wrote:

Hi,

In a worksheet I have column A is invisible and no matter what I do I
can't see it! "Hide/Unhide" didn't work!

How can I make column A visible?

Thanks,
jo


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 69
Default If column A is invisible?!

On Oct 11, 12:01 pm, mark wrote:
try two things:

1) Make sure Window-Freeze Panes is OFF

2) make sure the column width is not 0.

hit F5
type A1 , hit OK
Format-Column Width



"Jo" wrote:
Hi,


In a worksheet I have column A is invisible and no matter what I do I
can't see it! "Hide/Unhide" didn't work!


How can I make column A visible?


Thanks,
jo- Hide quoted text -


- Show quoted text -


Thanks Mark, it is the Window-Freese Panes!

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
Invisible Column names and Row numbers Suresh Lohar Excel Worksheet Functions 2 May 28th 10 09:53 PM
Invisible bar on bar chart KK New Users to Excel 3 November 24th 06 01:22 PM
invisible formulae Libby Excel Programming 1 September 8th 04 07:17 PM
Invisible macro? Cavemanz Excel Programming 4 July 28th 04 01:43 PM
Make one column Invisible. Neeraja Excel Programming 5 September 29th 03 02:58 AM


All times are GMT +1. The time now is 01:22 PM.

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"