• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

3 Easy steps to hide zero values in Excel

By admin on December 16, 2016April 19, 2019

In order to have neat looking reports in Microsoft® Excel®, you may choose to hide zero values. In this tip, we explain how to hide zero values for selected cells by using the custom number format. The hidden zero values appear in the formula bar when a cell is selected. Values that change to non-zero digits will be displayed in the cell range.
You are welcome to download the workbook to practice.
Applies To: Microsoft® Excel® 2013 and 2016.
Select the data range C3 to C24.
Then press Ctrl+1 and select the Number tab then Custom.
In the Type box, enter 0;;;@ then select OK.
To display hidden values:
Select the data range C3 to C24.
Then press Ctrl+1.
Select the Number tab then General.
Select OK.
The cells with zero values will display blank cells. This will give the report a neat look and make it more presentable.
The post 3 Easy steps to hide zero values in Excel appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

How to enhance your chart data series using a pictograph
Beef up your Financial Health Check report with your own financial ratio

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd