Editing a spreadsheet
Delete a worksheet
To delete a worksheet: Tap on the sheet that you want to delete. From the contextual menu that appears, choose to Delete the sheet.Set a worksheet tab color
To set a worksheet tab color: Tap on the sheet that you want to assign a color for. Tap the .... from the contextual menu. Choose the Tab Color option. From the color picker that pops up, choose the desired color.Rename a worksheet
To rename a worksheet: Tap on the sheet that you want to rename. Tap ... from the contextual menu. Choose to Rename. Type the desired name and tap Rename.Insert a new worksheet
To insert a new sheet: Tap the + icon in the Sheet Tab Bar. Alternatively, you can tap on the sheet you want the new sheet to be inserted after, then choose Insert from the contextual menu that appears.Clear values or formats in a cell range
To clear values or formats in a cell range: Select the desired range and go to the icon. Under Home, choose Clear. From the given list, you can choose to clear the content, formats, conditional formats, data validation, notes, and hyperlinks. To ...Insert an image into the spreadsheet
To insert an image: Go to the icon Under the Insert menu, choose Image. Choose Image In Cell to insert the image within a cell, and Image Over Cells to insert it over the grid. You can choose an image from your device gallery or WorkDrive library, or ...Insert a checkbox
To insert a checkbox: Select the desired cell range on which you wish to insert the checkbox. Go to the icon. Under the Insert menu, switch on the Checkbox toggle.Insert a note
To insert a note: Tap the desired cell on which you wish to insert the note. Go to the icon. Under the Insert menu, choose Note. Type in the desired content for the note and tap on ✓.Hyperlink data in a cell
To insert hyperlinks: Choose the desired cell or data. Go to the icon Under the Insert menu, choose Link. Choose the type of link to insert, and enter the URL, cell range, or email address respectively. To display a different text on the cell, enter ...Select multiple cells/ranges
To select multiple cells/ranges: Go to the icon, then choose View from the menu drop-down below the sheet tabs. Turn on the MultiSelection toggle. This will insert a widget in the editor, using which you can turn on/off multiple selection quickly. ...Manage a picklist
To manage a picklist: Go to the icon. Under the Insert menu, choose Picklist > Manage List. Choose any existing picklist that you want to edit.Create a picklist in a spreadsheet
To create a drop-down list or picklist: Select the desired cell range to apply the picklist. Go to the icon. Under the Insert menu, choose Picklist>Create List. Enter the values for the drop-down list and apply any desired formats. These formats will ...Create a named range
To 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.Hide or Unhide a row/column/sheet
To hide a row/column/sheet: Select the row, column or sheet that you want to hide. Tap the icon. Go to the View Menu. Go to the Hide/Unhide option. Choose to Hide Rows/Hide Columns or Hide Sheet. Alternatively, you can also hide a row/column/sheet ...Insert or delete cells, rows or columns in a sheet
To insert a column or a row: Select the column or row before which you want to insert a new column or a row. Tap the icon. Go to the Home menu. Tap the Insert & Delete option. From there, choose to Insert Column or Insert Row. Alternatively, you can ...Fill data into adjacent cells
Select the source data that you want to fill in the adjacent cells. Tap on the selection. From the contextual menu, choose the Fill option. Drag the markers until the cell range that you want to fill the data.Cut, copy, and paste values
To copy data: Select the cell/cell range that you want to copy. Choose to Copy the selection from the contextual menu. To paste data: Tap on the cell you want to paste the data after copying it. Choose to Paste from the contextual menu. To cut data: ...Formatting data in cells
Tap on the cell that you want to format. You can use the Smart Tool Bar at the bottom for quick formats such as Bold, Fill/Text Color, Alignment, and Number Formats. This Smart Tool Bar will show options contextual to the selected data or object. For ...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. Tap the = sign, then type the desired function's name. While typing, you can also choose from the function suggestions shown ...Edit cells in a spreadsheet
To edit cells in spreadsheet: To edit a cell, double-tap on the cell. This will open the keypad for you to start editing. Alternatively, you can enter the data in the formula bar. Once you've entered data into the cells, Tap the ✔ symbol to submit ...
Access your files securely from anywhere
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.
New to Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?