View different fields in a query

Microsoft Query

Show All

View different fields in a query

  1. On the Format menu, click Show Columns.
  2. To temporarily prevent a column from appearing in the Data pane, click the column, and then click Hide.

    To redisplay a column, click the column name, and then click Show.

Note   Hidden fields are included when you return the result set to Microsoft Excel. If you don't want hidden fields to be returned to Microsoft Excel, delete the fields from the Data pane before you return the result set to Microsoft Excel.