![]() |
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 |
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 |
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 |
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! |
All times are GMT +1. The time now is 12:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com