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.
New to Zoho TransMail?
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 ...Working with Zoho Sheet
Here are a few things that we'd like for you to know about Zoho Sheet as you get started: Maximum file size allowed for import in Zoho Sheet :10MB Maximum number of rows one can create : 65536 Maximum number of columns one can create : 1024 Maximum ...Working with pivot charts
Pivot charts, like the name suggests, lets you visualize the data while simultaneously letting you slice and dice the data just like a pivot table. Like any other chart, you can even customize how a pivot charts looks. Creating a pivot chart Click ...