How To Unhide Columns In Excel Sheet [Speedy Guide]

Assuming how to unhide columns in excel, here’s how to unhide them:

1. Select the columns on either side of the hidden columns.
2. Right-click one of the selected column letters and choose Unhide from the menu that appears.

The hidden columns should now be visible. If they’re not, try repeating steps 1 and 2, selecting the correct columns on either side of the hidden area. However, you can also simultaneously unhide multiple columns by selecting them before right-clicking to unhide.

The process is similar if your Worksheet has hidden rows instead of columns. Select the rows on either side of the hidden area and right-click to unhide them. You can also select multiple rows by holding down the Shift key while clicking the row numbers. However, we’ll discuss it briefly, so ensure you go through the whole article.

How To Unhide All Columns In Excel?

If you want to unhide all columns in your Worksheet at once, here’s what to do:

1. Press Ctrl+A or click the Select All button on the Home tab to select the entire sheet.
2. Right-click one of the column letters and choose Unhide from the menu that appears.

All of the hidden columns should now be visible. If some of them are still hidden, try repeating these steps. However, you can also use this method to unhide all rows by selecting the entire sheet and then right-clicking to unhide them.

Unhide All Columns In Excel Automatically With VBA Macro.

You can automate this task with a simple macro if you frequently unhide columns. Here’s how:

1. Press Alt+F11 to open the Microsoft Visual Basic for Applications window.
2. In the left pane, double-click ThisWorkbook to open it in the code editor on the right.

Paste the following code into the ThisWorkbook code window:

              Sub UnhideAllColumns()

                   Columns.Hidden = False

                       End Sub

3. Press F5 or click Run to run the macro. All of your hidden columns should now be visible.

 

To make this macro run automatically every time you open your workbook, insert the following code into the ThisWorkbook code window:

            Private Sub Workbook_Open()

               UnhideAllColumns

                   End Sub

All hidden columns will be unhidden when you open the workbook. Moreover, you can add this macro to a toolbar button or keyboard shortcut for easier access.

How To Show Hidden Columns That You Select

If you want to unhide only the columns that you select, here’s a macro that will do the trick:

1. Press Alt+F11 to open the Microsoft Visual Basic for Applications window.
2. In the left pane, double-click ThisWorkbook to open it in the code editor on the right. Paste the following code into the ThisWorkbook code window:

       Sub UnhideSelectedColumns()

         Dim i As Long

            For i = Selection.Column To Selection.Column + Selection.Columns.Count – 1

         Columns(i).Hidden = False

       Next i

    End Sub

3. Press F5 or click Run to run the macro. The selected columns should now be visible.

To make this macro run automatically every time you select columns, insert the following code into the ThisWorkbook code window:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

UnhideSelectedColumns

End Sub

Now, every time you select columns, they’ll be unhidden automatically. Moreover, you can add this macro to a toolbar button or keyboard shortcut for easier access.

Unhide Column A Using The Go-To Option

If your Worksheet is too large and you can’t find column A, you can use the Go To option to unhide it quickly:

1. Press Ctrl+G, click the Find & Select button on the Home tab, and choose Go To from the drop-down menu.
2. In the Reference field, type A: A and click OK.
3. Right-click one of the column letters and choose Unhide from the menu that appears.

Column A should now be visible. You can also use this method to unhide any other column by typing its reference in the Reference field (e.g., C: C). Ensure you include the colon (:) so that only the column is selected.

Unhide The First Column By Expanding It

If you want to unhide the first column without selecting the entire sheet, here’s a quick way to do it:

1. Click the column header of the second column to select it.
2. Right-click and choose Expand from the menu that appears.

The first column should now be visible.In essence,you can also use this method to unhide any other column by selecting the column to the right of it and expanding it.

How Do YouUnhide Column A By Selecting It

If you can’t find column A, you can try selecting it:

1. Press Ctrl+A or click the Select All button on the Home tab to select the entire sheet.
2. Click the column header of column B to deselect it.

Column A should now be selected. You can also use this method to unhide any other column by selecting the entire sheet and then clicking the column header of the column to the right of it.

Display All Hidden Columns In Excel Through Go To Special

If you want to unhide all hidden columns in your sheet, you can use the Go To Special option:

1. Press Ctrl+G, click the Find & Select button on the Home tab, and choose Go To Special from the drop-down menu.
2. In the Go To Special dialog window, check the Visible cells only option and click OK.
3. Right-click one of the column letters and choose Unhide from the menu that appears.

All hidden columns should now be visible. You can also use this method to unhide any other type of hidden cells (e.g., rows, sheets, etc.). Select the type of cells you want to unhide in the Go To Special dialog window.

How Many Hidden Columns Are There In AWorkbook

If you’re not sure how many columns are hidden in your workbook, you can use the following macro to find out:

1. Press Alt+F11 to open the Microsoft Visual Basic for Applications window.
2. In the left pane, double-click ThisWorkbook to open it in the code editor on the right.
3. Paste the following code into the code editor:

 

       Sub CountHiddenColumns()

                     Dim ws As Worksheet

                        Dim i As Long, j As Long, k As Long

                           k = 0

                              For Each ws In ThisWorkbook.Worksheets

                                For i = 1 To ws.UsedRange.Columns.Count

                              For j = 1 To ws.UsedRange.Rows.Count

                           If ws.Cells(j, i).EntireColumn.Hidden = True Then

                         k = k + 1

                       Exit For

                     End If

                   Next j

                Next i

              Next ws

             MsgBox k & ” hidden columns found”

           End Sub

4. Press F5 to run the macro. A message box will appear with the number of hidden columns in your workbook.
5. Close the Microsoft Visual Basic for Applications window.

Note: If you want to unhide all hidden columns, you can add the following line of code to the macro above:

ws.Cells.EntireColumn.Hidden = False

This will unhide all columns in the Worksheet (including previously hidden ones).

Conclusion

There are several ways to unhide columns in Excel, including using the Find & Select feature, expanding columns, and selecting cells. You can also use a macro to find out how many hidden columns there are in a workbook.

I hope this Guide has helped you learn how to unhide columns in Excel. If you have any questions, please don’t hesitate to ask. Until next time!