In this article, we will learn how to replace Zero with dashes in Number. We use the Custom Formatting in Microsoft Excel. Custom Format: -We can use...
We need to display negative numbers in parentheses to differentiate the positive numbers from the negative numbers. To display a Negative Number wi...
If we need to join two or more strings together and format them, we need to use the “&” symbol along with the Text function in Microsoft Excel...
In this article, you’ll learn how to edit a formula using keyboard in Microsoft Excel. Sometimes, you will find yourself clicking back and forth bet...
Many a times when we want to edit a formula and press the arrow key to move through the formula, we tend to select another cell and mess up the formul...
Clearing cells can be a drag sometimes. You can also use the Fill Handle to clear the contents of a range of cells by dragging it backwards over the c...
I came across this tip years ago and remember being amazed by it at the time (although now it's just part of my repertoire). Often you come across ...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
