Freeze and unfreeze columns in Datasheet view

Freeze and unfreeze columns in Datasheet view

You can freeze one or more of the columns 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 the column, click the field selector for that column.

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

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

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

Note   You can't save datasheet formatting changes to a datasheet in a Microsoft Access project unless it is a form. If you need to save formatting changes to an Access project table, view, or stored procedure datasheet, use the AutoForm Wizard to create the datasheet as a form (which quickly sets the RecordSource property to the datasheet and adds all the fields to the form), and then set the form's DefaultView and ViewsAllowed properties to Datasheet (which makes the form behave like a datasheet).