You can freeze one or more of the columns (fields) on a datasheet (datasheet: Data from a table, form, query, view, or stored procedure that is displayed in a row-and-column format.) so that they become the leftmost columns and are visible at all times no matter where you scroll.
- Open a table, query, form, view, or stored procedure in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).
- Select the columns you want to freeze.
To select one column, click the field selector (field selector: A small box or bar that you click to select an entire column in a datasheet.) 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.
- 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.