Freeze Rows in Smartsheet
SSFeatures lets you freeze one or more rows at the top of your Smartsheet grid. Frozen rows stay visible while you scroll through the rest of your data.
The Problem
Smartsheet lets you freeze columns so they stay visible while you scroll horizontally. But there is no way to freeze rows. This means that when you scroll down through a large sheet, you lose sight of important rows like:
- Summary rows at the top of the sheet.
- Category headers or section labels.
- Key reference rows that you need to compare against other data.
- Instruction rows that explain how the sheet should be used.
This is one of the most requested features in the Smartsheet community. Users who work with large sheets often have to scroll back and forth to reference important rows, which slows them down and hurts their productivity.
The Solution with SSFeatures
SSFeatures adds "Freeze Row" and "Unfreeze Row" buttons to the right-click menu. Here's how to use it:
- Select the rows that you want to freeze.
- Right-click on a row.
- Click Freeze Row(s).
The selected rows will be pinned to the top of the grid. When you scroll down, those rows stay visible so you can always reference them. SSFeatures remembers which rows you froze for each sheet, so the next time you open the same sheet, your frozen rows are automatically restored.
To unfreeze rows, right-click on a frozen row and click Unfreeze Row(s). You can unfreeze all rows at once, or unfreeze only some of them. If you right-click on a frozen row that isn't the first row, SSFeatures will unfreeze that row and all frozen rows below it, while keeping the rows above it frozen.
Demo Video
Frequently Asked Questions
Does this work with Smartsheet's native column freeze?
- Yes. If you have columns frozen in Smartsheet, the frozen rows will correctly align with both the frozen columns on the left and the scrollable columns on the right.
Can I freeze any rows, or only rows at the top?
- SSFeatures freezes all rows from the top of the sheet down to the rows you selected. For example, if you select row 5, rows 1 through 5 will be frozen.
Will my frozen rows be visible to my teammates?
- No. Frozen rows are a local setting that only applies to your browser. Your teammates will not see your frozen rows unless they also install SSFeatures and freeze the same rows.
Can you tell me more about the security and privacy of this feature?
- Absolutely. SSFeatures saves your frozen row settings locally within your browser's local storage. SSFeatures never sends any of your sheet data to our servers. The frozen row overlay is rendered entirely in your browser using the data that is already on your screen.
Solutions
Click Here to learn more about how this feature relates to Smartsheet as a whole.
