Anurag RANA

Anurag 1) Addition: Alt + = Adding or Sum is being used quite often. To ease out your work you can get to the end of a column or Row of your data and type ALT + symbol, a SUM function will appear with selected Row/Column. You just need to press ENTER to get the desired result. 2) Quick Access Functions: Shift + F3 This to INSERT FUNCTION without using a Mouse button clicking on ( fx ). 3) Reveal Formula: Ctrl + ~ If you’d like to get a quick view of the formulas that are being used in your Excel sheet, ‘Ctrl and ~’ will quickly reveal all. And to get Excel Back in a normal press the combination key again. 4) Turn Filters On/ Off: Ctrl + Shift + L The more data an Excel sheet has, the more sensible it is to use filters to classify and analyze them easily. To turn on and off filters simply press: Ctrl + Shift + L (make sure the data you want to filter is highlighted/ selected). 5) Add Comments in a Cell: Shift + F2 To Insert a Comment to particular cell ...