When you create a named range in Microsoft Excel, you can specify the starting point for the range. By default, the starting point is the cell in the upper-left corner of the range. However, you may want to adjust the starting point for a number of reasons. For example, you may want to make it easier to select cells in a large range by starting the range in a cell near the middle of the worksheet. Or, you may want to avoid potential errors that can occur when a formula refers to a range that starts in column A.
To adjust the starting point of a named range:
To move the starting point of the named range one cell to the right, type =OFFSET(cell_reference, 0, 1)
, where cell_reference is a reference to the cell where you want the new starting point to be located.
To move the starting point of the named range one cell to the left, type =OFFSET(cell_reference, 0, -1)
, where cell_reference is a reference to the cell where you want the new starting point to be located.
To move the starting point of the named range one cell down, type =OFFSET(cell_reference, 1, 0)
, where cell_reference is a reference to