VBA: Code to Hide and Unhide Rows and Columns in Excel

Hiding a row or column makes it invisible. The column still exists; it just can't be seen.

Hiding a row or column is roughly equivalent to setting its respective height or width to zero.

As you begin to develop complicated Excel spreadsheets you will find many reason for hiding columns and rows from the end user.

To hide a column:

• Select a column or series of columns
• Right click
• Select Hide

To Unhide Columns:

• Select the range of columns that contains hidden columns
• Right Click
• Click Unhide

Hiding and Unhiding Rows works that same as columns.

'Hide Column "A"

Columns("A").Hidden=True

'Unhide Column "A"

Columns("A").Hidden=False

'Hide Columns A through D

Columns("A:D").Hidden=True

'Unhide Columns A through

Columns("A:D").Hidden=False

'referencing entire column of a cell (Both Ex. Hide Column "C")

Range("C1").EntireColumn.Hidden=True

or

Cells(1,3).EntireColumn.Hidden=True

'referencing entire column of a cell (Both Ex. Unhide Column "C")

Range("C1").EntireColumn.Hidden=False

or

Cells(1,3).EntireColumn.Hidden=False

'Hide Row 1

Rows(1).Hidden=True

'Unhide Row 1

Rows(1).Hidden=False

'Hide Rows 1 through 5

Rows("1:5").Hidden=True

'Unhide Rows 1 through 5

Rows("1:5").Hidden=False

' referencing entire row of cell (Both Ex. Hide Row 5)

Range("C5").EntireRow.Hidden=True

or

Cells(5,3).EntireRow.Hidden=True

'referencing entire row of a cell (Both Ex. Unhide Row 5)

Range("C5").EntireRow.Hidden=False

or

Cells(5,3).EntireRow.Hidden=False

In the next module you will learn to apply borders to ranges of cells from within the Excel user interface and Visual Basic. Click here to proceed.