How to Autonumber Rows And Skips Blank Rows
March 18, 2022
me time if the action can be automated. Some may suggest copy and paste. However, mistake may happen if we fail to pay enough attention.
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.
7 uses of SHIFT key in Excel blows your mind
June 28, 2021
In this article, I will show you 7 uses of SHIFT key. I assure that your productivity won’t be the same after you finish reading this.
How to Get Value From Every Nth Row?
June 25, 2021
In this article, I will show you how to get value from every nth row using a formula. With this formula, retrieving alternating values is no longer a draining task.
How to Delete Every Other Row or Every Nth Row
June 20, 2021
In this article, I will show you how to delete every other row or every nth row in Excel. I assure you this tutorial will save you lots of effort.
7 uses of Ctrl E – Best Excel shortcut Ever
June 19, 2021
In this article, I am going to show you 7 ways of using Ctrl E in Excel. I am sure you will be the most productive employee in the office after watching this.
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)
