Shortcut for inserting the dollar symbol into your Formulas $$

Instead of physically typing the dollar symbol into your cell reference when creating a formula, simply click on the part of the formula that you need the dollar symbols to be in and press F4 on your keyboard. If you continue to press F4 you will find that Excel will cycle through the different options for the dollar sign. E.g. $A$1 -> $A1 -> A$1 and back to A1.

This tip also works with refernces to other Excel Sheets or Workbooks.


We are offering some FREE webinars too (see below)

Leave a Reply