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 the edit. You can use the Tab button to move to the cell on the right.
While in the edit mode, you can tap the cells you want to edit and start entering data.
To stop editing, tap the X icon above the keypad.
You can switch between text and numeric keyboard using the respective icons displayed above the keypad.
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
Enter data into cells
To edit cells in a spreadsheet: Double tap on the cell you wish to edit or single tap on the desired cell, and use the Edit option in the context menu or the formula bar. This will open the keypad for you to start typing. You can switch between the ...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 ...Format data in cells
To apply or edit formats: Tap on the cell(s) containing the desired data to be formatted. 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 ...Unlock cells/sheet in a spreadsheet
To unlock cell range/sheet in a spreadsheet: Go to the icon Under the Data menu, choose Lock Cells. Tap on the Manage Lock Settings option. Choose the desired cell range/sheet to unlock from the displayed list. Choose the users for whom you wish to ...View spreadsheet properties
The spreadsheet properties panel in Zoho Sheet provides you with the complete details about the spreadsheet and its usage in the form of a summary. You can access the spreadsheet properties using the icon in the top-right corner of the editor or ...