Excel: Create a named group of cells - AdvantEdge Training & Consulting

Excel: Create a named group of cells

Create a named group of cells to be used in formulas or to quickly navigate back to the group. To do so, first, select the group of cells to be named. In this case, we will use a list of supplies.
group cells excel
Next, click inside the Name Box, located in the upper left hand corner of the spreadsheet.
group cells excel
Type in the name for the selected cells, with no spaces, even if you have multiple words. Once done, you must hit the Enter to save the name.
group cells excel
Now, this group name is available to use. To use as a way to navigate back to the group, click the dropdown arrow in the Name Box and click the name.
group cells excel

For more ways to make Excel work for you, take training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top