Create a named range | Zoho Sheet for iOS

Create a named range

To create a named range:
  1. Select the desired cell range.
  2. Go to 
  3. Under the Insert menu, choose Define Name.
  4. You can choose to define a cell range, an expression, or a constant value.
  5. Enter the desired values and tap Done.



    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

                                                          • Create a new blank spreadsheet

                                                            To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.
                                                          • Save and use a named filter view

                                                            To save or name a filter view: Apply a filter on the desired range with the desired criteria. Go to  icon Under the Data menu, choose Filter. Tap on Name this Filter, enter a name, and tap Done. Note: To apply a saved filter, select Named Filters and ...
                                                          • Create pivot tables to analyse your data

                                                            Create a pivot table in sheet To create a pivot table: Click Data > Pivot Table. Choose the range of cells from which the table is to be constructed and where the table must be created Drag and drop the fields into the desired positions in the Pivot ...
                                                          • How to create data validation?

                                                            Create a data validation for cells To create data validation: Click Data > Data Validation. You can choose the required range to apply data validation from the dialog shown below. The options that are available include the following: Decimal number, ...
                                                          • Create a picklist in a spreadsheet

                                                            To create a dropdown list or picklist: Select the desired cell range to apply the picklist. Go to  Under the Insert menu, choose Picklist. Enter the values for the dropdown list and apply any desired formats. Note: These formats will be applied on ...

                                                          Resources

                                                          Videos

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



                                                          eBooks

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



                                                          Webinars

                                                          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