Home / MS-Excel / General Formatting

Excel Relative or Absolute Macro


When recording your actions, Excel normally records absolute references to cells. (This is the default recording mode.) Very often, this is the wrong recording mode. If you use relative recording, Excel records relative references to cells. The distinction is explained in this tutorial.

In this tutorial:

  1. Recording Absolute Macro
  2. Recording Relative Macro
More from MS-Excel