Get startedGet started for free

Naming ranges

Naming specific cell ranges within your data can be extremely useful. If there is a particular column or row of information that you will use regularly for formulas or calculations throughout your workbook, it can definitely be easier and save time if you have given that particular range an easy reference to use.

We've reverted our dataset to before we applied our table styles, we'll now add some names to some important ranges within our data.

This exercise is part of the course

Introduction to Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise