Convert cell reference to relative/absolute reference in Excel 2007/2010
If you want to convert cell references in the formulas from absolute to relative references or vice versa in excel, you may need to add or remove “$” or press “F4” for converting each cell reference in the formula one by one. It seems tedious and time-consuming, but Kutools for Excel’s Convert References can quickly convert cell references in the formula to one of the following reference types:
- Absolute reference (for example, $B$1);
- Relative reference (for example, B1);
- Column absolute reference (for example, $B1);
- Row absolute reference (for example, B$1).
Click "Kutools">>"">>"Convert References". See screenshots (Fig. 1 and Fig. 2).
 |
 |
 |
| Fig. 1 Convert References |
Fig. 2 Convert Formula Reference dialog box |
Usage:
- Use the
to select the range that you want to convert cell reference; - Select one convert option from the convert operations;
- Click OK.
Notes:
- You can press Undo (Ctrl+Z) to restore this operation immediately.
- The range can include formula cells or non-formula cells, but the non-formula cells will be automatically ignored in the converting.
This is only one feature of Kutools for Excel
It includes more than 100 functions and tools for Excel 2007 and 2010.
