Excel Quick Tip #6 - Creating Range Names

Creating lots of range names can be a tedious process, unless you know the technique described below:

1. Select all of the cells that you want to create your range names from.

Here we want to create the four range names Budget, Gross, Profit and Tax, so we select all of the cells that will be part of those ranges including the headings.

2. On the keyboard, press CTRL + SHIFT + F3.

3. On the dialog box that appears check the box that specifies the position of the labels used to create the names, and then click OK.

Here we're using the top row of the selected cells to create the range names.

The range names will be created automatically:

One simple keyboard shortcut, four new range names!

You can watch a short video of this technique in action.

Comments on this blog

This blog currently has no comments.