Unhide column

Question

On a spread sheet i hid columns b-f (5 colums).

Im trying to unhide the columns and it they wont unhude

Answer 1

Hi Vincent Cipriano,

Good day. I'm Jhun an independent advisor. Have you tried selecting the columns A to G, Right click and select "Unhide".

Regards,
Jhun

Answer 2

To unhide columns B through F in Excel, you can follow these steps:

1. Select the Columns: Click on the column header for column A, then drag to select column G (this will select columns A through G).
2. Right-Click: Right-click on the selected area.
3. Unhide: From the context menu, select Unhide.

If the columns still do not unhide, ensure that there are no filters applied that might be hiding the columns. You can also check if the columns are hidden due to grouping or if there are any protection settings on the sheet that prevent unhiding.

If you are using VBA, you can also unhide columns programmatically by using the following code:

Columns("B:F").EntireColumn.Hidden = False

This code will unhide the specified columns in the active worksheet.