How to use Excel's Switch Reference -tool

Following video demonstrates nice and easy way to quickly change cell reference type between absolute and relative reference:

1. Select Formulas tab in Ribbon bar
2. Select reference in formula
3. Click Switch Reference to change reference type A1 --> $A$1 --> A$1 --> $A1

See my earlier posting about Absolute and Relative References.

Tip: If you have difficulties to see the video, try to maximise it from lower right corner: