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 to type “=AVERAGE(“ and then press Ctrl button and keep pressing each references, This will add the reference and also inserts the comma in between references like  ‘=AVERAGE(C2,C3,C4,C5,D2:D3,E2:E6) ‘. This work with any function where we use the arguments.

CtrlClick


Leave a Reply

Your email address will not be published. Required fields are marked *