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

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!

Find more posts tagged with

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.