Free Microsoft Excel 2013 Quick Reference

Unhide column A

I hid columns A - F. I am unable to unhide them. I selected column G, and clicked on Format > Columns > Unhide, but no joy. Next time, I will just reduce the width of A, and hide B-G, but now I should ... ???????


Post your answer or comment

comments powered by Disqus
I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?

I have several spreadsheets that have column A hidden and I have tried
everything I know to unhide column A. Any suggestion?

I feel so silly, My spreadsheets are usually really large so I hide and unhide columns all the time. Well I hide Column A on about 6 worksheets and now....I cannot UNHIDE it hehehe. I try, but Excel just highlights the entire worksheet and UNHIDE is no longer an option!
I hope that someone can stop laughing long enough to help! Thanks!!

Office 2000 WinXP ID_10_T User.

I have a spread sheet and the columns a-c are hidden. I did the highlight
schreed and did unhide and that did not work. I did the Edit key and that
did not work. Can you help me. thanks

The format function "unhide" does not affect the hidden columns A thru BB, even when all cell (upper left square) is selected.

Column A is hidden, and all panes are unfrozen. Even if I select ALL rows &
columns, choose unhide and unfreeze, column A is still hidden. How do I fix?

Hide Columns A & B and now I can't figure out how to Unhide them. The
obvious doesn't seem to work. Been here, done that, before but got them
back somehow. Guess it's time I found out the right way to do it.

Thx all
Dave

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

I've somehow hidden columns A and B. I followed the directions in the help
section but it did not work. How can I unhide them?

Here is what I have

Sub Macro1()
'hide
Columns("A:C").Select
Selection.ColumnWidth = 0
'unhide
Columns("A:C").Select
Selection.EntireColumn.Hidden = False
End Sub

I need some sort of "if Statement". I want just one mavro that will hise or unhide the columns.
If the Colums are hidden then unhide them, If they are visible then hide them.

I prefer to not even select the column if possible.

Thanks for the help

Ross

Ok, I've tried the "GoTo" function and the "change column width" to unhide
Column A, but that's not working. Weird thing is that Column A prints AND
shows in Print Preview but I can't see it/edit it onscreen. What am I missing?

I have a macro that will hide all rows with a "0" in column A on sheet 2.
The quantites in column A on sheet 2 come from sheet 1.
I need something that unhides a row if a value on sheet 1 changes it.

Thanks!

I have a workbook that contains 20 worksheets. I want these sheets hidden until such a time a Name is typed into column A of Sheet1.

My code currently changes names of sheets based on the Name typed in Column A.

Ie Sheet 1 cell A1 contains "Peter" I want the hidden sheet named Peter to Unhide.

Also if the name is deleted from column A then the corresponding sheet is hidden

Katt

Hello
I would like to be able to Unhide columns that have been hidden by a different macro one at a time.

I have a sheet that has dates at the top of each column starting at column H (Jan 08) this can theoretically go all the way to Column IV. I already have some code that hides any column with a date older than 3 months. Eg Today is August 08 so all columns from Jan 08 to May 08 hide. As it hides a column, it adds a column to the end so I have 4 years of dates on show at any one time. I don't think this code its self is important at this time so I have not posted it.

There has come the need to review old information in the hidden columns so I wrote this code that is executed on a command button to unhide the hidden columns.
Code:
Public Sub StopHideCol()
Sheet2.Cells(61, 6) = "x"
ActiveSheet.Columns("G:IV").Hidden = False
End Sub
It doesn't really get any simpler than that. The command button just calls this macro as I have several buttons all doing the same thing on different sheets. The x being written to the cell is so I can stop the hide column macro firing until the workbook is closed.

Instead of unhiding all the hidden columns I would just like to unhide 1 at a time starting with the closest month in time and moving back at each press of the Command Button. This is because as time goes by more and more columns will be hidden and this seems a logical way to mange how many columns are showing.

Thanks as usual for any advise and help recieved.
Partjob

I have a worksheet in 2003 in which I have hidden columns A,B, & C, D & E.
They will not unhide. I have tried selecting column F and then selecting
Unhide from the format, columns. I have also tried using the Go To funtion on
the edit menu for cell A1 which then shows the column heading in the formula
bar as Reponse ID which is correct, if I then go to format etc it still
won't unhide!

Help? Anyone?!

Shelly

I've seen this issue discussed in this forum before but cannot seem to make the solution work for me.

The workbook contains 5 worksheets, 4 of which will unhidden just fine; the remaining worksheet ("AnnualBudget" refuses to unhide columns AD to IV. Of course, this is the sheet that contains data in those hidden cells and I cannot get to the data. The sheet is unprotected and all freeze panes removed.

I have copied this sheet to a new sheet in the same workbook:

If I copy only formulas and number formats, the new sheet has all columns unhidden. If I copy formats, I have the same issue with the new worksheet. It’s like these columns are forever locked from view.

FYI I am using Excel 2007 with a 2003 compatability worksheet

A copy of the workbook is attached. Any idea what’s happening?

Thanks....John

I have a worksheet in 2003 in which I have hidden columns A,B, & C, D & E.
They will not unhide. I have tried selecting column F and then selecting
Unhide from the format, columns. I have also tried using the Go To funtion on
the edit menu for cell A1 which then shows the column heading in the formula
bar as Reponse ID which is correct, if I then go to format etc it still
won't unhide!

Help? Anyone?!

Shelly

Hello friends,

This is my first post and I think this forum has really brilliant people cooperating.

My inquirie is that I would like to create a macro in excel that can hide and unhide columns automatically when a cell value changes.

ie. When A1=pizza hide column d and show column c
When A1=burger hid column c and show column d

I want to apply this macro to a file that contains a lot of columns for each type of information.

I will appreciate any help I can get about this.

On my worksheet i have markets going horizontally with each market taking up 2 columns. For instance, market 1 would take up columns E&F with each subsequent market after that taking up 2 more columns all the way to columns FG&FH (lot of markets).

So what i want to do is create a dropdown list in column A that has a list of markets, obviously simple. However what i'd like to do is have a macro that hides all columns that don't pertain to market in the dropdown.

So as an example, lets say in the dropdown the user picks "Market 4" and "Market 4" are columns M&N. What i'd like the macro to do is go through and hide the other columns that are not M&N so the user can enter the information.

Then when they are done entering information the macro will unhide all columns again.

--------------------

The reason for this type of fuction is to enter cost data and to not mistakenly enter it into a wrong market. Does this sound doable? I have been searching through the posts and trying to find a macro that would work and not having luck.

thanks for any help.

I have a document in which column A is missing. I've tried to unhide it but
it isn't working. I followed the steps from excel help exactly and it isn't
working. I can still tab over to column A and it will show me the cell number
in the name box but I can't actually view what's in those cells.

Hi All,

I am looking or a code, (Or formula if one exists) to hide or un-hide columns depending on what is entered into a cell.

I have attached an example to help clarify what i mean.

Basically i want:

If A2 is empty, hide columns C, D, E & F
If A2 = Apple, Unhide columns C & D, but keep E & F hidden
If A2 then becomes Banana, rehide C & D and unhide D&F

Any help on this will be greatly appreciated
Thanks in advance,
Dave

Hi everyone
This is only the second pice of code i have written so appologise for any schoolboy errors. I am trying to hide or unhide columns E:BL depending if the the cell value in row 54 contains a value (Note cells in row 54 contain formulas). I have written the following code but get a runtime error on the else statement. Can anyone help?


	VB:
	
 UpdateCashflow() 
     '
     ' Update Cashflow
     '
     
    Application.ScreenUpdating = False 
    ActiveSheet.Unprotect Password:="LD" 
    ActiveSheet.Select 
     
    Dim c As Integer 
     
    For c = 5 To 64 
         
        If Cells(54, c) = "" Then 
            ActiveSheet.Range(Cells(54, c)).EntireColumn.Hidden = True 
        Else 
            ActiveSheet.Range(Cells(54, c)).EntireColumn.Hidden = False 
        End If 
         
    Next c 
     
    ActiveSheet.Protect Password:="LD", DrawingObjects:=True, Contents:=True, Scenarios:=True 
    Application.EnableEvents = True 
     '
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Hi - I am hiding column ranges on a worksheet and of 14 used 13 are accurate, but when I try to hide column range BD:BG it always hides column BH as well. Selectively unhiding column BH then unhides column BG as well.
Just hiding column just BG hides BH as well.

On a blank worksheet there is no problem, so it is something to do with the copied sheet. As far as I can see there are no merged cells to cause the problem, and there is nothing special about column BH, but it seems irreversibly associated with column BG.

Am at a loss to know the cause - hope you have some ideas

Many Thanks


	VB:
	
 TotalsSheet1() 
     '
     ' TotalsSheet1 Macro
     ' Macro recorded 24/01/2005 by Denise Bowes
     '
     
     ' Turn off Screen Updates
    Application.ScreenUpdating = False 
     
    Sheets("Sheet1").Select 
    Sheets("Sheet1").Copy After:=Sheets(3) 
     
    ActiveSheet.Unprotect Password:="fredbloggs" 
     
    Rows("112:113").Select 
    Selection.Copy 
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ 
    :=False, Transpose:=False 
     
    Rows("1:4").Select 
    Selection.UnMerge 
     
    Rows("98:108").Select 
    Selection.UnMerge 
     
     '  Hide Columns not wanted (all OK except BD:BG)
     
     '
    Columns("C:F").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("H:K").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("M:P").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("R:U").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("W:Z").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("AB:AE").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("AG:AJ").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("AO:AR").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("AT:AW").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("AY:BB").Select 
    Selection.EntireColumn.Hidden = True 
     
    ‘Range causing problem – selects comns BD:BH instead 
    Columns("BD:BG").Select 
    Selection.EntireColumn.Hidden = True 
    ‘OK 
    Columns("BI:BL").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("BN:BQ").Select 
    Selection.EntireColumn.Hidden = True 
    Columns("BS:BV").Select 
    Selection.EntireColumn.Hidden = True 
    Range("$A$1").Select 
     
     ' ......

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Dear all, iwould like some help!
I want to have a list of all the months in a sheet and when i will choose a month to hide and unhide columns in another sheet in the same workbook! Meaning that f.e. i choose march in the list and automatically i want to be transferred to another sheet where all the the completed cells are hidden and show me the columnes C,D H, and K (for example). I believe that is needed the use of VBA probably!
Thank you in advance for any help!


No luck finding an answer? You could always try Google.