How to Select Cells with Colour (3 ways + VBA)
December 2, 2020
You may have a workbook that have cells filled with different colour. It is easier to deal with if the colour is a part of the conditional formatting. If it is not, things got a lot more complicated. Do you
How To Insert Bracket In Excel Cells (3 ways)
December 1, 2020
Sometimes we have to insert bracket in Excel cells. The easiest way to wrap text in bracket is to manually input it. This process may take an hour if you have thousands of rows. Not only is the manual process
Excel Select Columns/ Rows To End Of Data
November 30, 2020
In this article, I am going to show you how to select column to end of data. I will provide you with 4 ways to deal with different situations.
6 Ways To Converting Text To Number Quickly In Excel
November 28, 2020
Often times Excel recognize number as text. That could lead to a lot of problems. Not able to perform mathematic operations Lead to error Cells are aligned to the left In this article, I am going to show you 6
How To List All Worksheets Name In A Workbook
November 26, 2020
Background Sometimes you would like to get a list of all worksheets’ names in a workbook. To create a content page (or use this content page creation tool) To Change Sheet Reference In Copied Formulas To show your boss how
How To Limit Scroll Area In Excel (2 ways)
November 11, 2020
Background Often times we would like to restrict users from getting access to certain range in Excel for different reasons. This can be easily done by Restricting Scroll Area. How to limit scroll area in Excel? How to restrict user’s
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)
