Positioning Query Cell Areas 

Use

You can arrange queries and their cell areas in any number of ways on the worksheet by moving or, where necessary, deleting them again.

If you copy the whole query to a new worksheet the position of the cell areas for the query remain the same.

Functions

You can choose from the following functions:

Function

Procedure

Valid for

Moving within a worksheet

Move the relevant cells in Excel:

  1. Select the cell area.
  2. Place the cursor on the edge of the cell and drag it to where you want it.
  • Text elements
  • Filter cells
  • Results area
  • Displaying exceptions
  • Displaying conditions

Moving to other worksheets

In the BEx toolbar, choose Layout ® Move Filter or Move Results Area.
  • Filter cells
  • Results area

Copying to other workbooks

Choose Tools ® Copy Query from the BEx toolbar.
  • complete queries only

Filter cells

The filter cells for a query can be moved or copied freely.

If you want to undo the changed position of the filter cells, delete all filter cells and refresh the query. By doing this you have repositioned all cell areas for the query.

With the function Layout ® Select queries in worksheet you can see which filter cells belong to which query.

Text Elements

You can display the query text elements by group and selectively move or delete them.

See also:

Displaying Text Elements

Moving / Copying Queries

You can change the position of the query within the workbook. You can either copy the entire query or move the results area into the workbook. The properties of the query remain the same after the position has been changed. After moving or copying you must refresh the query in order to display the current data.

See also:

Tools

Refreshing Queries