Hide rows or columns in a spreadsheet | Zoho Sheet for iOS

Hide or unhide a row/column/sheet

To hide a row/column/sheet:
  1. Select the desired row/column/sheet to hide.
  2. In the context menu that appears, choose Hide Row/Hide Column/Hide Sheet, respectively.
To unhide a hidden row/column/sheet:
  1. Select the row/column that is adjacent to the hidden rows/columns. For a worksheet, you can tap on any of the sheet tabs.
  2. From the context menu that appears, choose the unhide option. For a worksheet, you can choose the worksheets to unhide from the displayed list.

    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

                                                        • Hide a row/column/sheet

                                                          1. Left click on the row/column/sheet you'd like to hide. 2. Select the Hide row/column/sheet option. 3. Alternatively, you can select the row/column/sheet you want to hide, and click on the View menu. 4. From there, click on the Hide & ...
                                                        • 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 ...
                                                        • Delete a row or column from a sheet

                                                          To delete a row or column: Select the row or column that you wish to delete. Right click the selected row or column. Click Delete Row or Delete Column from the context menu. You can also right click on a cell that has been selected and choose to ...
                                                        • Hide/unhide the grid lines in a sheet

                                                          To hide grid lines: Click View > Hide Gridlines. ​ To make grid lines reappear: Click View > Show Gridlines.
                                                        • 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 ...



                                                        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