Tuesday, 19 February 2013

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:

No comments:

Post a Comment