--- title: Zeros who needs them - hide zeros in Excel description: Learn how to hide zeros in your Excel spreadsheet easily with step-by-step instructions from Woodthorpe IT. Enhance your data presentation today. image: https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/Covering%20up%20the%20number%200%20with%20a%20blanket%20cartoon%20happy.jpeg --- [![logo](https://woodthorpeitsolutions.co.uk/hubfs/logo.png)](https://woodthorpeitsolutions.co.uk) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) [0800 044 3779](tel://08000443779) [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) # Zeros who needs them - hide zeros in Excel [Woodthorpe IT](https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it) 29 April, 2025 ![](https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/Covering%20up%20the%20number%200%20with%20a%20blanket%20cartoon%20happy.jpeg) 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. ![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/image-png.png?width=830&height=681&name=image-png.png) Previous Post ###### [Lock it down - How to lock your computer quickly](https://woodthorpeitsolutions.co.uk/tips-and-news/lock-it-down-how-to-lock-your-computer-quickly) Next Post ###### [Editing and Opening PDFs with Word](https://woodthorpeitsolutions.co.uk/tips-and-news/editing-and-opening-pdfs-with-word) ### Similar Blog Posts [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Email%20with%20excel%20and%20word%20and%20PowerPoint%20attachment%20cartoon%20style.jpeg?width=352&name=Email%20with%20excel%20and%20word%20and%20PowerPoint%20attachment%20cartoon%20style.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/email-your-file-without-leaving-word-or-excel-or-other-application) #### [Email your file without leaving Word or Excel or Other application](https://woodthorpeitsolutions.co.uk/tips-and-news/email-your-file-without-leaving-word-or-excel-or-other-application) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/missing%20information%20cartoon%20spreadsheet-1.jpeg?width=352&name=missing%20information%20cartoon%20spreadsheet-1.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) #### [Highlight all blank cells in an Excel list quickly](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Multiple%20windows%20on%20a%20computer%20screen%20cartoon.jpeg?width=352&name=Multiple%20windows%20on%20a%20computer%20screen%20cartoon.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/look-at-the-same-file-more-than-once) #### [Look at the same file more than once](https://woodthorpeitsolutions.co.uk/tips-and-news/look-at-the-same-file-more-than-once) [![Logo 290x70 - white](https://woodthorpeitsolutions.co.uk/hubfs/Logo%20290x70%20-%20white.png)](https://woodthorpeitsolutions.co.uk) Woodthorpe IT Solutions are providers of Microsoft 365 training and consultancy.  Established in 2005 we have trained over 10k people and continue to help learners get the most from their computer. [Want to resell our courses?  Click here to learn more.](https://woodthorpeitsolutions.co.uk/reseller) [Follow us on LinkedIn](https://www.linkedin.com/company/woodthorpe-it-solutions/) [Follow us on YouTube](https://www.youtube.com/@WoodthorpeITSolutionsLtdBlacon) ###### Get In Touch 0800 044 3779 contactus@woodthorpeit.com ##### Company details Co number: 05572129 Vat number: 936 2824 09 ##### Trust [Privacy Notice](https://woodthorpeitsolutions.co.uk/privacy-notice) [Terms](https://woodthorpeitsolutions.co.uk/terms) [Slavery and Human Trafficking Statement](https://woodthorpeitsolutions.co.uk/slavery-and-human-trafficking-statement) Copyright © 2026 Woodthorpe IT Solutions Limited ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Woodthorpe IT", "url" : "https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it" }, "dateModified" : "2025-04-29T09:17:45.238Z", "datePublished" : "2025-04-29T09:17:45.000Z", "headline" : "Zeros who needs them - hide zeros in Excel", "image" : [ "https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/Covering%20up%20the%20number%200%20with%20a%20blanket%20cartoon%20happy.jpeg" ], "mainEntityOfPage" : { "@id" : "https://woodthorpeitsolutions.co.uk/tips-and-news/zeros-who-needs-them-hide-zeros-in-excel", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject" } } } ```