From the course: Google Sheets: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Edit and delete a named range

Edit and delete a named range - Google Sheets Tutorial

From the course: Google Sheets: Advanced Formulas and Functions

Start my 1-month free trial

Edit and delete a named range

“

- [Instructor] Just like every other worksheet element, you can edit and delete named ranges after your create them. In Sheets, you can work with your named ranges using the tools available through the data menu. I'll demonstrate how to perform these tasks in this movie. This workbook contains a single worksheet, and on it, I have a set of revenue data and then the number of sales that resulted in that revenue. And that gives me an average sale amount. I've created that formula in cell E2. With cell E2 selected, I can go up to the formula bar and take a look at the actual formula. And I see that, like all averages, I am dividing the sum of all revenue by the sum of all sales. So I have sum of revenue column divided by sum of sales count. If you're new to a worksheet, or you haven't looked at a worksheet for awhile, it always pays to verify that everything is accurate. In this case, I'll check my revenue and sales count named ranges to ensure that they refer to the correct cell ranges.…

Contents