A cell reference is simply a way of identifying a specific cell in your spreadsheet.

Using the IF function with absolute references forces the cell reference inside a formula to remain constant. Open an Excel worksheet and add data to two columns, where the first column has one ...

Add a sheet name, followed by an exclamation point, to reference cells located on another sheet. For example, "=Sheet2!A1:B5" references a range of 10 cells on "Sheet2." Sheet names are located on ...

Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work. What am I doing wrong? A: Your partner is right, but ...

If you’re new to using Microsoft Excel, or an experienced user looking for a good visual reference, this handy cheat sheet covers eight helpful tricks for becoming a spreadsheet pro. While ...

If you omit the dollar sign, Excel applies the highlight to the cell instead of the entire row. The reference to row 3 isn’t absolute, so the rule can evaluate all of the rows in the selected range.

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.