How to Show Zeros as Blank Cells In Excel
January 12, 2021
Background Zeros are almost inevitable in a workbook. Sometimes you may change the appearance of the zero. Do you have the following ask? Display zero as blank cells Show zero as dash Hide zero without actually deleting zero In this
How to Create Drop Down List with Color (Excel)
January 12, 2021
I have a drop-down list and I want the cell to be formatted to a specific color depending on the selected value. Numerous Excel users From time to time, I get this questions from my followers on Instagram. They want
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
