How to Make Everything Have Dollar Signs With F4 in Excel

Dollar signs allow you to make cell references in Microsoft Excel absolute rather than relative. Absolute references will not change when you copy the formula to another location, but using the default relative references will adjust to accommodate the new location. Although you can manually enter the dollar signs in cell references, this is tedious for lengthy formulas. To make things easier, pressing "F4" while highlighting the entire formula will automatically add the dollar sign for each cell reference.

Instructions

1. • 1
     Open your spreadsheet in Microsoft Excel.
   • 2
     Click the cell containing the formula to which you wish to add dollar signs.
   • 3
     Click and drag your mouse across the entire formula in the "Fx" bar at the top of the spreadsheet.
   • 4
     Press "F4" to automatically add the dollar signs to all references in the selected formula.
   • 5
     Press "Enter" to edit the cell edit mode.