

How to highlight current row and column in Excel?
July 8, 2021
In this article, I will show you how to highlight current row and column in Excel by changing the number format of cell.

How to prevent duplicate entries in Excel?
April 23, 2021
Duplicates sometimes can be a bad thing which lead to mistakes and wrong calculation. In this article, I will show you how to set a no duplicates rule to cells.

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)