Use a named range for formatting options

Instead of referencing multiple cells that contain formatting options, you can give the group of cells a name and then reference just that name.

To use a named range:

1. Insert the formatting options into a location in your worksheet. For more information, see Configuring Global Formatting Options.

2. Select the cells that contain the options.

3. In the Name Box list, type a name for the cell range.

4. Press Enter on your keyboard.

   You can then specify the named range in your queries.

   The formula references the named range instead of the worksheet cells.