Freeze rows/columns
To freeze first row/column
Click View > Freeze First Row or Freeze First Column.
To freeze panes
- Place your selection on the cell, the rows and columns before which you wish to freeze.
- Click View > Freeze
- Select how much of your view port you want frozen.
Zoho Sheet lets you freeze any number of rows and columns.
How does unlimited freeze work?
Say you've scrolled down on your spreadsheet, and your screen now displays rows 25 through 50.
If you're looking to freeze until row 40, you can go to View > Free > Up to Row 40.
What happens after?
Since you had on your display rows starting from 25, the frozen panes, i.e rows 25 through 40 remain on screen until your unfreeze panes again. The rows below row 40 on your display are scrollable.
How does unlimited freeze work?
Say you've scrolled down on your spreadsheet, and your screen now displays rows 25 through 50.
If you're looking to freeze until row 40, you can go to View > Free > Up to Row 40.
What happens after?
Since you had on your display rows starting from 25, the frozen panes, i.e rows 25 through 40 remain on screen until your unfreeze panes again. The rows below row 40 on your display are scrollable.
To unfreeze panes
Select Unfreeze Panes from the View Tab.
Place charts and images on frozen panes for better visualization
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho SalesIQ Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
New to Zoho DataPrep?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Bigin?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
Related Articles
Separate text to different columns
To change text to columns: Select the required cell or column which consists of the text you want to move to separate columns. Click Data > Text to Columns. The Text to Columns dialog box appears. 3. Choose the delimiters such as comma, space, ...Insert a new row into a sheet
To insert a row: Click Insert > Row. You can insert multiple rows by selecting as many rows as you want. Alternatively, you can select "Insert" from the right click contextual menu, and click on "Row" from the drop down. Select multiple rows or ...Unhide a hidden row or a column
Please note that Zoho Sheet leaves a green mark in between rows/columns if one or more rows/columns are hidden in between. 1. To unhide a row or a column, hover over the green mark. 2. Click on the arrows that appear when you hover over the mark ...Insert or delete cells in a sheet
To insert or delete cells, rows, or columns: Select the desired row or column to delete, or before which you wish to insert a new row/column by tapping on the respective row/column header. In the context menu that appears, scroll or tap the icon to ...Hide or unhide a row/column/sheet
To hide a row/column/sheet: Select the desired row/column/sheet to hide. In the context menu that appears, choose Hide Row/Hide Column/Hide Sheet, respectively. To unhide a hidden row/column/sheet: Select the row/column that is adjacent to the ...