If you don’t want to accidentally move or adjust a column of data, you can freeze one or more of the columns. A ‘frozen’ column becomes the leftmost column and remains visible all the time as long as you remain in the same Datasheet view.

For example, if you want to freeze the Contact Name column in the datasheet, simply right-click on the Contact Name title and click Freeze Columns:

 

 

If you have a wide table and you scroll sideways, the frozen column stays always on the left side of the screen:

 

 

If you want to unfreeze a column, right-click on the frozen column title and click Unfreeze All Columns. The column is no longer frozen to the left side of the screen, but it does not move back to the location it came from before you froze it. You will need to move the column back manually.