Excel: Move range - how to do it

The function to move ranges is especially handy for complexly structured tables with many partial calculations. The function allows you to specify a different range for another reference. This way you don't have to actually move the cells.

Excel: Move range - how to use the function

The RANGE.MOVE formula has a very extensive structure. However, if you know what the individual ranges are used for, the formal can be applied quite easily.

1. The formula for moving a range is structured as follows: =RANGE.MOVE(reference;rows;columns;[height];[width]).
2. In the reference, you specify which cells are to be considered. This can be a single cell or several cells at once.
3. In the range of rows you specify how many rows the range should be moved down or up.
4. In the range of columns you specify how many columns to the left or right the reference should be moved.
5. Both height and width you need only if the reference is whole blocks of cells.

When do you need the formula?

1. If individual calculations should not be performed so far or simply do not yet provide final results, the reference can be moved so that a calculation is not performed until the contents have arrived at the referred cell.
2. Also in the case of error messages that present an incorrect reference, the formula can quickly correct the problem without having to restructure the table.