How to Name Multiple Single Cells in Excel?
December 12, 2020
Background Named range is a very useful feature in Excel. With Named range, the formula is more dynamic and looks a lot more descriptive. However, naming range itself can be a painful process. Naming 50 ranges manually can take you
How to Sum and Count Cells by Color in Excel?
December 5, 2020
Background Sometimes we may want to sum and count cells based on background colour of a cells. I personally don’t suggest using background colour frequently. I do think background colour has its advantage. You can check out 5 Golden Rules
How To Select All Cells From All Worksheets
December 3, 2020
In this article, I will show you how to select all cells from all worksheets. It sounds complicated but all it takes is just 2 simple steps. Expected Outcome Option 1: Select whole worksheet + Select All Sheets Step 1:
How to Activate an Excel Sheet using VBA?
December 3, 2020
Background Navigating between Excel worksheets are one of the VBA101 questions. Very often we will have more than one worksheet in a Excel workbook. All you need is “Activate”. Do you have the following questions? How to go to a
How to Go to a Specific Excel Sheet
December 3, 2020
Navigation between sheets is inevitable for every Excel users. However, navigation can be really time-consuming if you have hundreds of tabs. In this article, I will show you 4 ways to go to navigate to certain Excel sheets. Example In
Edit The Same Cell In Multiple Excel Sheets
November 24, 2020
Background Sometimes you will need to edit the same cell in more than one Excel worksheets. It is so time-consuming to change it one by one especially when your workbook contains more than 100 sheets. Do you have the following
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)
