![]() Select the cells you want to hide if their values are zero.Let's see how you can apply a custom format. Aside from Excel's built-in number format options like Currency, Date or Percentage, you can set your own custom number formatting. So, you can set cell-specific rules rather than in the entire worksheet. The next method involves using custom number formatting. ![]() If you want to hide the zero values from the entire workbook, you need to disable this option for all worksheets. That's all! Remember that this option applies only selected sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |