This video explains how the dollar sign is used in Excel formulas to control whether cell references stay fixed or change ...

Open a blank spreadsheet in Excel. Label cell A1 "Daily Sales." Label cell B1 "Last 2 Days." Label cell C1 "Running Total," and then set column width to 15 for these three columns. Change the color of ...

Is there a way to hold down shift/ctrl, etc to make a cell reference an absolute reference when entering a formula instead of having to go back and enter $?

Microsoft Excel relies on two fundamental reference types when addressing other cells. Absolute references -- which are denoted with a "$" -- lock a reference, so it will not change when copying the ...