WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
10 Excel Quick Tips
Part six of a ten-part series of blogs

Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names (this blog)
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date
  10. Excel Quick Tip #10 - Copying Days and Months

Posted by Andrew Gould on 02 December 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

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.
Selecting cells

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.

  1. On the keyboard, press CTRL + SHIFT + F3.
  1. 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.
Create Names dialog box

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


The range names will be created automatically:

Range names created

One simple keyboard shortcut, four new range names!


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

This blog has 0 threads Add post