Show or hide columns in a datasheet
- Open a table, query, form, view, or stored procedure in Datasheet view.
- Do one of the following:
Hide a column or columns
- 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.
- On the Format menu, click Hide Columns.
Show a hidden column or columns
- On the Format menu, click Unhide Columns.
- In the Unhide Columns dialog box, select the names of the columns that you want to show.
- Select the columns you want to hide.