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
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
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.
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
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
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
