Freeze and unfreeze columns in a datasheet

You can freeze one or more of the columns (fields) on a datasheet so that they become the leftmost columns and are visible at all times no matter where you scroll.

1. Open a table, query, form, view, or stored procedure in Datasheet view.
2. Select the columns you want to freeze.

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

   To select more than one column, click the column field selector and then, without releasing the mouse button, drag to extend the selection.

3. Do one of the following:

   To freeze the selected columns, click Freeze Columns on the Format menu.

   To unfreeze all columns, click Unfreeze All Columns on the Format menu.