![How to remove bullets/numberings in Excel](https://dollarexcel.com/wp-content/uploads/How-to-copy-data-from-multiple-sheets-at-once-的複本-10-300x169.png)
![How to highlight current row and column in Excel?](https://dollarexcel.com/wp-content/uploads/highlight-300x168.png)
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?](https://dollarexcel.com/wp-content/uploads/Screenshot-2021-04-23-165143-300x167.png)
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)](https://dollarexcel.com/wp-content/uploads/How-to-Create-Drop-Down-List-with-Color-Excel-300x169.png)
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)