Freeze Rows in Smartsheet: Step-by-Step Guide
Freezing rows in Smartsheet is a useful feature that locks data from being accidentally modified. This is especially handy when dealing with critical or static information. This guide walks you through the process step-by-step.
Before you proceed, ensure you have the necessary permissions. The 'Freeze Rows' function is available to users with 'Admin', 'Editor', or 'Owner' roles.
Understanding Frozen Rows
Frozen rows in Smartsheet remain visible even when you scroll horizontally. This is particularly beneficial when you have wide sheets and want to maintain visibility of certain rows, like column headers or important data.
Frozen rows can also improve sheet performance, as Smartsheet only needs to render the unfrozen part of the sheet.
Freezing Header Rows
To freeze header rows, click on the row header of the row below the ones you want to freeze. Then, click on 'Freeze Rows' in the menu that appears. Alternatively, you can right-click on the same row and select 'Freeze Rows'.
This will freeze all rows above the selected one. To unfreeze them, follow the same steps and select 'Unfreeze Rows'.
Freezing Multiple Rows
You can also freeze multiple rows at once. To do this, select the rows you want to freeze by clicking and dragging over them. Then, right-click on any of the selected rows and choose 'Freeze Rows'.
Remember, frozen rows are visible on all sheets across Smartsheet. If you want to freeze rows only on the current sheet, ensure you're on that sheet when performing the action.
Working with Frozen Rows
Once rows are frozen, they won't scroll horizontally. This might take some getting used to. To navigate frozen rows, click the row header or use the spacebar to move up and down.
You can still add, remove, or reorder frozen rows. To do this, right-click on the row header and select the appropriate option. The frozen status remains intact during these operations.
Frozen Rows and Views
Frozen rows behave differently in different views. In 'Grid View', they stay in place as you scroll through your sheet. In 'Card View', frozen rows are displayed at the top, even if the cards don't include those rows.
In 'Gantt View', frozen rows are not visible. This is because Gantt View is typically used to display only the rows that have start or end dates specified.
Now that you know how to freeze rows in Smartsheet, you can better manage and protect your important data. Happy organizing!