A lock icon will appear in the column or row headers to indicate that a column or row has been locked. IMPORTANT: Locking a column doesn’t prevent a person with editor sharing permissions from deleting or moving rows. It prevents them from editing or deleting any data in that column.
There currently isn’t a way to lock a single cell in Smartsheet. What you might consider doing is creating a report for your other collaborators to work with. They can still edit data, but can’t edit formulas in a report.
So, what is the purpose of locking columns and rows?
If you want to protect key data from being changed or deleted by others who are shared to your sheet, you can lock columns and rows. Data contained in cells in locked rows or columns cannot be edited. Similarly, cells in newly inserted rows won’t be editable in locked columns.
How do I lock a column or row in a sheet?
The same rule applies to anyone working from an Update Request or Published sheet A lock can be applied to any column or row, with the exception of the Attachment and Comment columns which cannot be locked To lock a column, right-click the column header and click Lock Column. To lock a row, right-click a row number and click Lock Row.
While we were researching we ran into the inquiry “Can I edit data contained in locked rows or columns?”.
Data contained in cells in locked rows or columns cannot be edited. Similarly, cells in newly inserted rows won’t be editable in locked columns.
How do I unhide a column in smartsheets?
The sheet owner and Admins can unhide all columns by clicking the More icon in any header and selecting Unhide All Columns. Unhide a single column by click-and-dragging the double-bar (which represents a hidden column) in the column header.
How do I hide or unhide multiple columns in Excel?
To hide multiple columns, hold down the [Ctrl] (Windows) / [Cmd] (Mac) key as you single-click on the header of each column you want to hide. Then click the More icon and select Hide Column. The sheet owner and Admins can unhide all columns by clicking the More icon in any header and selecting Unhide All Columns.
One thought is that select Hide Column from the menu. To hide multiple columns, hold down the [Ctrl] (Windows ) / [Cmd] (Mac) key as you single-click on the header of each column you want to hide. Then click the More icon and select Hide Column.
Though this functionality isn’t available for rows, you can apply a filter to the sheet to hide rows based on criteria they contain. The filter will impact only your view of the sheet and other collaborators can apply their own filters as needed.
How do I protect key data in a Smartsheet plan?
To learn more about Smartsheet Regions, click here. For more information about plan types and included capabilities, see the Smartsheet Plans page. If you want to protect key data from being changed or deleted by others who are shared to your sheet, you can lock columns and rows. Data contained in cells in locked rows or columns cannot be edited.