Many Excel users are often required to use array formulas, below note will help to understand how to :- a) Create an Array formula b) Convert an...
In this article, we will learn How to use the keyboard multiple select entire row in Excel. Scenario: In Excel, selecting cells is a commo...
Fast switching between large number of worksheets ========================================= If you have too many worksheets in your workbook and a...
Press CTR+C Press "Application Button" -found between the Ctrl and Alt keyboard keys -"it's a menu like with a mouse pointer" Press Letter V and ...
If you have amount in number format and you wish to convert that in dollar currency format, you can follow simple shortcut approach given below :- ...
If you wish to enter data on many cells at once in one go, follow the below steps:- 1) Select the range in which you need to enter the data (you...
There are ways to close an open workbook but if you want toclose all the open workbooks, you can follow below approach:- Hold the Shift key while ...
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.
