In this article, we will learn All about Check marks and Check boxes in Excel. What is Check Mark and Check Box? Check box is an objec...
In this article, we will learn the Shortcut to jump to the last cell and first cell in Excel. Scenario: Generally, when working with large d...
In this article, we will learn how to use shrink to fit option to adjust text in cells in Excel. Scenario: Whenever working with data, we al...
Sometimes we want to lookup entire columns using some key or lookup value in Excel. In that case you may use traditional HLOOKUP formula or INDEX MATC...
What is an Absolute Reference in Excel You must have read the word absolute reference. If not, you must have noticed the $ (dollar) sign before...
In this article, we will learn How to use Scientific formatting in Excel. Number formatting in Excel The Scientific format displays a number...
In this article, we will learn How to Show only formulas but not result in Excel. Scenario : Excel performs a function in a cell when using ...
In this article, we will learn How to custom format cell in Excel. What is the Format cell option ? Custom format option lets you change the...
To insert a whole row in Excel 2016 on Windows use CTRL+SHIFT ++ on keyboard. If you have selected a cell in a table or a whole row in excel sheet, th...
Use F4 key on window to toggle between Relative and Absolute References.Just select the range and press F4. If you press once: $A$1 If you press...
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.
