How-To Geek on MSN

Don't underestimate the power of the $ sign in Excel formulas

Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses when referencing cells.
Hosted on MSN

Excel formula basics: The role of the dollar sign

This video explains how the dollar sign is used in Excel formulas to control whether cell references stay fixed or change when copied. It covers absolute, relative, and mixed references, helping users ...