Best Microsoft Excel Bloggers

Tuesday, November 1, 2011

Freezing Columns In an Access Table

You can FREEZE one or more of the columns in an Access table so that they become the leftmost columns and are visible at all times no matter where you scroll.

  • Open a table in Datasheet view.
  • Select the columns you want to freeze by clicking the field selector (top of the column) 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.
  • Right-click and select Freeze Columns
Access handles this a bit differently from Excel - what it does is literally move that column so that it becomes the left most column in the table.
  • To unfreeze a column, Right-click on the  frozen column heading and select Unfreeze Columns
And of course, Access does NOT move the column back to its original position - you have to move it manually.

No comments:

Post a Comment

Ms. Excel- Resident Excel Geek