How to Display Blank when Referencing Blank Cell
March 30, 2022
In this article, I will show you how to display blank when referencing blank cell in Excel. I will provide you with 4 ways to achieve the result.
How to freeze top and bottom row at once in Excel
April 12, 2021
In this article, I will show you two workarounds to freeze header row and bottom row. One of the solutions is with table and another one is without using table.
How to remove all conditional formatting from a workbook
April 8, 2021
In this article, I will show you how to delete conditional formatting from a workbook with VBA code.
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
How To Insert Bracket In Excel Cells (3 ways)
December 1, 2020
Sometimes we have to insert bracket in Excel cells. The easiest way to wrap text in bracket is to manually input it. This process may take an hour if you have thousands of rows. Not only is the manual process
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)
