By default, the Distance Calculator processes every row in your table that has a starting and ending address. If you only want to calculate specific rows, you can use Excel’s built-in table filters to control which rows get processed.
How it works #
- Click anywhere inside your table.
- Go to the Data tab and click Filter to enable filter dropdowns on each column header.
- Click the filter dropdown on the column you want to filter and select the values you want to keep.
- Click Calculate Distances. Only the visible rows will be processed.
- Remove the filter to see all your data again.
Rows that are hidden by a filter are completely skipped. No API calls are made for them.
Demo #
Common examples #
| Goal | Filter to apply |
|---|---|
| Only calculate new rows | Filter the Distance column to (Blanks) |
| Recalculate a specific city | Filter the Starting Address column to that city |
| Calculate a single row | Filter any column to match just that row |
If all rows are filtered out (none visible), you will see a “Nothing to Process“ message.
