Skip to content

How to Show or Hide Columns and Rows in Excel

2 minute read

mdblue storagetwo

Need a new tip for that seemingly never-ending “to learn in Excel” list? Here’s a new one for easier viewing, sorting, or customizing your spreadsheet view.

Hiding and showing columns and rows can be very helpful when, for example, you want to hide parts of your spreadsheet that are distracting, and if you want to hide them temporarily. To learn how to hide or show columns and rows, follow the steps below that outline two methods for hiding and showing columns:

How to hide and show columns and rows using the right-click menu:

  1. In your Excel spreadsheet, highlight the columns you want to hide.
  2. Right-click over the selected items and select Hide.
  3. As you can see, the columns collapse and at the top panel. You’ll notice that the columns are missing. This makes it easier for you to see that columns are hiding.
  4. To show the hidden columns, highlight the area where the columns are missing and select Unhide from the right-click menu.
  5. To hide rows, select rows to hide, and follow the same steps above.

How to hide and show columns and rows using the Format menu:

  1. Select the columns you want to hide.
  2. Click the Home tab.
  3. Select Format.
  4. On the drop-down menu, click Column Width.
  5. Adjust the column width to read “0.”
  6. To unhide the columns, return to the Format drop-down menu and readjust the column width.
  7. To unhide columns, highlight the area where the columns are missing, return to the Format drop-down, and readjust the column width.
  8. Follow these same steps to hide or show rows by selecting Row Height in the Format drop-down menu.

Good news! If you are using Excel Online, you can follow these same steps. For more hiding options, such as unhiding the first row or column of the worksheet, or hiding ranges of rows and columns, visit this page.

Sign up for our newsletter