How to create & use a structured reference to refer to a table
Syntax: =TableName[[ItemSpecifier];[ColumnSpecifier]]
TableName: Denotes the name of the table.
- #All - Denotes the entire table.
- #Data - Denotes only the rows containing data.
- #Headers - Denotes only the header row.
- #Totals - Denotes only the footer row.
- #@ - Denotes only the current row.
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:
Create. Review. Publish.
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
Design. Discuss. Deliver.
Related Articles
Create a table
What is a Table? Table is one of the best spreadsheet tools to group and analyze data swiftly. Format your data into tables for better visualization! To create a table: Go to Format > Table. Select a table style from the list of options. Mention the ...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.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 ...Use functions and formulas
To use a predefined or custom function in your spreadsheet: Double tap on the cell where you want the result to be displayed. Start with an equal sign (=), then type the desired function's name. While typing, you can also choose from the function ...Create, run and record VBA macros
What is a macro? Macros are special programs that will help you auto-execute specific tasks instead of performing manual tasks repeatedly. Visual Basic for Applications (VBA) is the programming language used to write macros. In Zoho Sheet, you can ...