You can modify query properties in Excel by right-clicking any cell in an existing query range and selecting Data Range Properties. This option opens the External Data Range Properties dialog box, as shown in the following image.
Some of the External Data Range Properties options that you can control include:
WebFOCUS Quick Data automatically adds a named range to the entire data table and also to each individual column. Named ranges are useful when referring to data as a source for analysis or within an advanced Excel application.