Lock a Column (Prevent it from being moved to a different area)



Is it possible to have a column header be locked in place.

For example, a spreadsheet with 5 columns titled 1, 2, 3, 4, & 5.

Someone keeps moving column 2 next to column 5. We want to prevent other users from dragging column headers to different locations.

Thank you!

Best Answer

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    Answer ✓


    There's no way to prevent an Admin from changing the column order. You can change a user's permissions to Editor, so they can only enter/update data in the grid.

    Admins and Sheet Owners will always be able to change the column order.