Not Using Ctrl + Click to Insert Cell References in Formulas
Video Tutorial
If you've been typing commas between cell references whenever you write a formula in Excel, please know that there's a faster way to do it!
By simply holding the Ctrl key down while clicking on the cells you want to include, the comma will automatically appear between the references in your formula.

This trick also works while inserting ranges. Just click and drag your mouse to select multiple cells while holding down Ctrl. The range references will automatically be separated by a comma.

Like this tip? Have questions? Want to share another Excel bad habit? Leave a comment below!
Add comment