How to hide and unhide columns and rows in Excel

Hiding rows or columns is a good way to visually simplify a worksheet without removing important information.

Let’s take a look.

One way to hide a column is to choose Hide Columns from the Format menu on the home ribbon.

To unhide a column, you oughta select columns on both sides of the hidden column.

Then, choose Unhide Columns from the Format menu.

you could also hide and unhide columns using the right-click menu.

Select one or more columns, right-click in the selection, and choose Hide from the menu.

To unhide the columns, see to it to select columns on both sides of the hidden columns.

Then, right-click and choose Unhide from the menu.

Rows work in much the same way as columns.

you’re able to hide and unhide rows using Hide Rows and Unhide Rows in the Format menu.

Or, you could use the right-click menu, which is faster.

Notice the gap in row numbers when rows are hidden.

As with columns, you should probably select rows on both sides of the rows you want to unhide.

Then, right-click in the row selection and choose Unhide from the menu.

you could then right-press row and column headings and select Unhide for each.

With the entire sheet selected, it doesn’t matter where in the headings you right-click.