New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Edit a named range

Google Sheets · Verified tutorial

Edit a named range in Google Sheets

Edit the existing named range ActiveRevenue so it covers B2:B5. Then enter exactly =SUM(ActiveRevenue) in D2.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Edit the existing named range ActiveRevenue so it covers B2:B5. Then enter exactly =SUM(ActiveRevenue) in D2.

Step-by-step

1

Select the targetEdit the existing named range ActiveRevenue so it covers B2:B5.

2

Apply the changeThen enter exactly =SUM(ActiveRevenue) in D2.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

D2 uses the expanded named range and displays 700.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select B2:B5 and repeat the final action. D2 uses the expanded named range and displays 700.

Example spreadsheet data

This is the clean fixture used for the verified run.

Quarter	Revenue		Total
Q1	100
Q2	150
Q3	200
Q4	250

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Edit the existing named range ActiveRevenue so it covers B2:B5.
Apply the change. Then enter exactly =SUM(ActiveRevenue) in D2.
D2 uses the expanded named range and displays 700.