Specify what portion of the worksheet you wish to access:
Named Range
Use this drop-down list to specify Entire Worksheet or Other. When you choose Other, the Other Range dialog box displays which allows you to specify a cell range.
Current Value
This is the current cell range value of your worksheet.
Use row above selected range for column titles
Choose this option when you want the row above the selected range used for column titles.
Type a cell range in the form A1:F9
Type the desired cell range in the form indicated.
Navigation Buttons
OK
Click OK to open the worksheet.
Cancel
Cancels the operation.