HOME
> Office programs
> Excel: Move Range - How To Do It

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

### When do you need the formula?

- 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.
- 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.