Excel Bad Habit Series: Commas in Cell References in Formulas

Not Using Ctrl + Click to Insert Cell References in Formulas

Video Tutorial

Watch on YouTube & Subscribe to our Channel

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.

Insert data range reference in formulas with Ctrl + Click

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

Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter

Test Your Excel Skills

Free Excel Training Webinar Modern Power Tools

>