Posts Tagged ‘excel’

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 + ’

post-1-0-72907900-1404648756

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 […]


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 […]