Tips and News

Zeros who needs them - hide zeros in Excel

Written by Woodthorpe IT | Apr 29, 2025 9:17:45 AM

Sometimes you don't want to see the zeros in your spreadsheet (This may help your Spreadsheet look better). Please see below how to hide them in your Spreadsheet.

  • Click "File "(Top left)
  • Click "Options" (Bottom of the pop out menu for file)
  • Click "Advanced"
  • Scroll down the list and remove the check next to "Show a zero in cells that have zero value".  See picture below to help you find it.