Freeze and unfreeze columns in a datasheet

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.

  1. 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.).
  2. 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.

  1. 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.

 
 
Applies to:
Access 2003