Show All

Copy formulas when an external data range expands

1. Enter a formula in a cell adjacent to the first row of data in the external data range.

   Note  The first row of data might be the first or second row in the external data range, depending on whether the first row contains headers.

2. Select the cell and double-click the fill handle to copy the formula to all rows in the external data range.
3. Click a cell in the external data range, and then click Data Range Properties on the External Data toolbar.
4. In the External Data Range Properties dialog box, select the Fill down formulas in columns adjacent to data check box.

   Note  If the external data range expands when you refresh, Microsoft Excel copies only those formulas that are immediately adjacent to or within the external data range.