Excel Guides

Adjusting a Range's Starting Point in Excel

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:

  1. Select the cells that you want to include in the named range.
  2. On the Formulas tab, in the Defined Names group, click Name Manager.
  3. Click the named range that you want to modify.
  4. In the Refers to box, do one of the following:
  • 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

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.