Cell Reference

9 lessons in order

Learn how to reference cells by row and column number in Excel using ROW, COLUMN, ADDRESS, INDIRECT, INDEX, and R1C1-style formulas.

Learn how to use mixed cell references in Excel with easy examples to lock rows or columns, boost accuracy, and simplify calculations.

Learn how to reference a cell in another Excel sheet dynamically using INDIRECT, drop-downs, named ranges, VBA, CHOOSE, or INDEX functions.

Learn the key differences between absolute and relative references in Excel and how they affect copying or moving formulas in your sheets.

Learn how to keep a cell fixed in Excel formulas using absolute references or the INDIRECT function for more control and accuracy.

Display text from another cell in Excel using direct references, TEXT formatting, lookup formulas, named ranges, or conditional logic.

Learn how to hard code in Excel by entering fixed values in formulas, using custom formatting, and converting formulas to values.

Learn how to use absolute cell references in Excel to lock cells in formulas, perform accurate calculations, and copy formulas correctly.

Learn how to use relative cell references in Excel for basic calculations and easily copy formulas across rows and columns accurately.