Create a named range
Select the desired range.
Go to the
icon.
Under the Insert menu, choose Define Name.
You can choose to define a cell range, an expression, or a constant value from the drop-down menu.
Enter the desired value and tap Done.
Access your files securely from anywhere
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 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:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Create a named range
To create a named range: Select the desired cell range. Go to Under the Insert menu, choose Define Name. You can choose to define a cell range, an expression, or a constant value. Enter the desired values and tap Done.Create a named filter
To create a named filter: Select the desired cells and tap Filter under the Data menu. Enable the Filter Toggle button. The filter gets applied to the column header of the selected range of cells. Tap the filter icon on the desired column, and apply ...Save and use a named filter
To save or name a filter view: Apply a filter on the desired range with the desired criteria. Go to the icon Under the Data menu, choose Filter. Tap on Name this Filter Enter a name, and tap Done. To apply a saved filter, select Named Filters and ...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 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.