Select Page

I hope you’re not mixed up after learning about mixed cell references in Excel Video 254. Now that you’re familiar with relative cell references and absolute cell references, we’ll mix things up a little. Instead of either letting both the row and column components of a cell reference change when a formula is copied or locking in both the row and cell components of a formula, mixed cell references are a middle ground. We’ll use the F4 shortcut key to lock in one component of a reference and allow the other component of a cell reference to change as the formula is copied.
Watch the video for examples when you might want the row reference to change while the column reference stays constant and vice versa. Part of the power of Excel is getting one formula right and then copying the formula throughout your spreadsheet as necessary. As you’re familiar with relative, absolute, and mixed cell references, your ability to create powerful spreadsheets will increase.