Freeze rows/columns

Freeze rows/columns

To freeze first row/column

Click View > Freeze First Row or Freeze First Column.

To freeze panes

  1. Place your selection on the cell, the rows and columns before which you wish to freeze.
  2. Click View > Freeze
  3. 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. 

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 CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now

              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 CRM Training

                      Zoho DataPrep Resources

                        Zoho DataPrep Demo

                        Get a personalized demo or POC

                        REGISTER NOW

                          Design. Discuss. Deliver.

                          Create visually engaging stories with Zoho Show.

                          Get Started Now

                                              • 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 ...



                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                              CRM Tips

                                              Make the most of Zoho CRM with these useful tips.

                                                Zoho Show Resources