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 SalesIQ Resources

                    Zoho TeamInbox Resources

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



                                                        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