Unhide Columns

[mahmed1]

Hi All,

I have hidden some columns by right clicking - Hide but for some reason it does not sllow me to Unhide. Please help

Thanks

 

[Wee Kuang]

What exactly was the error? For example if Column B is hidden, you should highlight Column A and C and then try to unhide it.

 

[grizz]

click on corner between A and 1
then Format / Column / Unhide

 

[mahmed1]

Hi, I have done that (No Luck)

 

[Michael M]

Is one of the columns "A" ?
If so, click on corner between A and 1 as suggested and then very carefully move the mouse next to the first column until you get a double sided arrow...then click and drag to the right to expose the hidden column

 

[RichardMGreen]

Have you tried highlighting A-C and setting the column width to something like 15?

 

[grizz]

is the worksheet password protected or shared

 

[mahmed1]

Hi,

The columns hidden are from Z onwards. Columns A - Y are not hidden

The workbook is not protected and is not shared

Thank You

 

[Michael M]

OK
try a macro

Sub UnCol()
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
    WS.AutoFilterMode = False
    WS.Cells.EntireColumn.Hidden = False
Next WS
End Sub