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

WesMcNally

Hello,

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!

Ray Lindstrom

@WesMcNally,

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.

BRgds,

-Ray

Ray Lindstrom

@WesMcNally,

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.

BRgds,

-Ray

WesMcNally

Thank you @Ray Lindstrom