Control + Click to Enter Arguments In Function

Are you tired of typing commas when you have many arguments in a formula in excel. While entering the formula, just hold down the control key as you click each reference (may be a single cell or range of cells) For example to get the average of multiple cells as shown below, you just need […]

Moving the (Irritating) formula hint bar

While we start entering the formula, excel tries to help us by displaying the formula hint window as shown below. Sometime this may block viewing some of the cells which may be required to refer for completing the formula. But this hint bar can be moved to a different place which most of the users not […]

Most Unknown short cut Ctrl + ’


There are many ways you can copy the formula to a cell from the cell above. One way is to press Ctrl + D and other method is Ctrl + C and Ctrl + V. Consider the below example. In the cell C926 we have a formula =SUM(C2:C925) which sums the data from cell C2 […]

Power of Find All with Ctrl + A

Most of the Microsoft Excel users are aware of the short cut key Ctrl + A. What it does is selecting the entire contents of the table if the cursor is in any of the table in the work sheet, or the entire sheet if the cursor is outside the table data of Excel. But […]

Go To Special function in Excel

Go To Special is a powerful function in excel which is not known to most of the excel users. This can be accessed through any of the below methods Home tab of the Ribbon / Find & Select button OR  Ctrl + G OR the F5 key Click on the special button, there you will find […]