Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invisible Column names and Row numbers | Excel Worksheet Functions | |||
Invisible bar on bar chart | New Users to Excel | |||
invisible formulae | Excel Programming | |||
Invisible macro? | Excel Programming | |||
Make one column Invisible. | Excel Programming |