Show or hide columns in a datasheet

Microsoft Office Access 2003

Show All Show All

Show or hide columns in a datasheet

  1. Open a table, query, form, view, or stored procedure in Datasheet view.
  2. Do one of the following:

    Hide a column or columns

    1. Select the columns you want to hide.

      To select one column, click the field selector for that column.

      To select adjacent columns, click a column field selector and then, without releasing the mouse button, drag to extend the selection.

    2. On the Format menu, click Hide Columns.

    Show a hidden column or columns

    1. On the Format menu, click Unhide Columns.
    2. In the Unhide Columns dialog box, select the names of the columns that you want to show.