In order to hide zero values in your Excel spreadsheet, click File on the Ribbon. Click Options, then Advanced. Scroll down about three-fourths of the way until you reach the section called Display ...

How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide.

Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

Click "OK" to filter the Excel data. Repeat the process for all columns that contain cell values of zero until all rows with zero cell values are hidden. Press "Ctrl-P" on your keyboard.