1. Business
  2. Presentations

How to Show Zeros as Blank Cells in Excel in 60 Seconds

Scroll to top
Read Time: 2 min
This post is part of a series called How to Use Excel - Quick Video Tutorials (in 60 Seconds).
How to Use Cell Styles in Excel in 60 Seconds
How to Grab a Screenshot in Excel in 60 Seconds

When you're working in Excel and have big data sheets, it's totally possible that many of your values could be zero. 

This is common, but it can make your spreadsheet difficult to read and navigate. We don't have to change all of these zeros and delete them from the data to clean up our spreadsheet.

Instead we can just change how they appear. Instead of showing all these zeros, we could blank them with one simple option in Excel. Let's learn how.

How to Quickly Show Excel Cells as Blank if Zero

Note: Watch this short tutorial screencast or follow the quick steps below, that compliment this video.

1. Open Your Excel File That Has Zero Cells

We start with an Excel file with numerous 0 cells, which we want to turn blank.

Excel file with zero cellsExcel file with zero cellsExcel file with zero cells
Excel file with zero (0) cells.

2. How to Turn Off Show Zeros in Excel

Now go to the File tab here in Excel. Now find the Options button here on the left side, and go ahead and click on it.

Now, change to the Advanced option on the left side. Let's scroll down. And in the midst of these options, go ahead and find the box that says, Show a zero in cells that have zero value. This option controls the setting for the entire workbook. We need to go ahead and uncheck that box and now let's press OK.

Show a blank in Ecxel cells that have zero valueShow a blank in Ecxel cells that have zero valueShow a blank in Ecxel cells that have zero value
Show a blank in Ecxel cells that have zero value.

3. Now Excel Will Show Zero Cells as Blank

When we return to the workbook, you can see that all of the zeros are now hidden. The zero value is still inside the cell, but Excel changes how it shows it and it blanks those cells out. This might also be useful in a pivot table view, for example.

Blank cells show if zero in ExcelBlank cells show if zero in ExcelBlank cells show if zero in Excel
Cells are now blank if zero in Excel.

Finishing Up!

Now you know how to change an Excel if cell to 0 then make it blank when needed. This option of is helpful to keep spreadsheets more readable and focused on your meaningful data.

More Helpful Excel Tutorials on Envato Tuts+ 

Find comprehensive Excel tutorials on Envato Tuts+ to help you learn how to work with your data better in your spreadhsheets. We also have a quick-start in 60 seconds Excel video series to learn more Excel tools fast. 

Here are a few Excel tutorials to jump into to now: 

Remember: Every Microsoft Excel tool you learn, and workflow you master, the more powerful spreadsheets you can make.

Did you find this post useful?
Want a weekly email summary?
Subscribe below and we’ll send you a weekly email summary of all new Business tutorials. Never miss out on learning about the next big thing.
One subscription. Unlimited Downloads.
Get unlimited downloads