Spreadsheet Tips

How to Hide Rows and Columns in Excel

July 20, 2018
how to hide rows and columns in Excel

You can simplify your Excel spreadsheets by hiding rows and columns that other people don't need to see.

  • To hide rows and columns: right-click on the header for the row or column you want to hide, and choose "Hide". Note: you can hide multiple rows or columns by selecting several of them before right-clicking to hide them.
  • To unhide rows and columns: select a range of rows or columns containing the hidden data, right-click on the selected header, and chose "Unhide".