Page 242 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Method #3: Using Create From Selection Option
This is the recommended way when you have data in tabular form, and you want to create a named range for
each column/row.
For example, in the dataset below, if you want to quickly create three named ranges (Date, Sales_Rep, and
Sales), then you can use the method shown below.

Here are the steps to quickly create named ranges from a dataset:
• Select the entire data set (including the headers).
• Go to Formulas –> Create from Selection (Keyboard shortcut – Control + Shift + F3). It will open the ‘Create
Names from Selection’ dialogue box.

• In the Create Names from Selection dialogue box, check the options where you have the headers. In this case,
we select the top row only as the header is in the top row. If you have headers in both the top row and left
column, you can choose both. Similarly, if your data is arranged when the headers are in the left column only,
then you only check the Left Column option.

This will create three Named Ranges – Date, Sales_Rep, and Sales.
Note that it automatically picks up names from the headers. If there are any space between words, it inserts an
underscore (as you can’t have spaces in named ranges).

229

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77