Mixed relative and absolute references are where you really start to become an Excel Rockstar.
In my last video, I explained what relative and absolute references were. In part two, I show how you can mix them together to create large, powerful spreadsheets in seconds.
As I explained in the previous video, a relative reference is when a formula points to a cell a certain distance away. While an absolute reference points to a specific cell.
A mixed relative and absolute reference (often just called a mixed reference) is one where the row is relative, while the column is absolute. Or vice-versa.
In formulas, a mixed reference has a dollar sign before either the column letter or the row number, but not both. =$A3 has an absolute column and relative row. =A$3 has a relative column and absolute row.
You can hit F4 (or Command-T on a Mac) as a shortcut to cycle through a relative reference, absolute reference, and the two types of mixed references.
Watch the video to see the power of this functionality, and how you can use mixed relative and absolute references to rapidly and easily build powerful spreadsheets.
Want to learn more about Excel?
Check out the Excel Made Easy class.
And please subscribe to our newsletter to be notified of any future courses, and get monthly tips on how Excel can make your life easier.
You can also submit questions to be answered in a future blog post or video, or book a free consultation to find out how we can save your business time and money with our done-for-you solutions.