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 Fill Sequential Data Quickly in Excel
June 2, 2021
In this article, I will show you how to fill linear and growth sequence by fill command and fill handle. This will save you a lot of time.
How to Apply Serial Number After Filter in Excel?
May 24, 2021
In this article, I will show you two ways to apply serial number after filter. The first way is to add a new column of serial number and the second way is to make the serial number renumber automatically.
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 get distinct values in Excel? (6 ways)
April 19, 2021
I will show you 6 different ways to get distinct values in Excel. “Remove duplicates”, “Advanced filter”, “Function”, “Formula”, “Pivot table” and “VBA”.
How to copy data from multiple sheets at once
April 15, 2021
In this article, I will show you how to copy data from different sheets and paste them at once by using the clipboard.
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)
