Select multiple cell ranges
To select multiple cells/ranges:
1. Place the selection on one of the desired cell/range.
2. Press Cmd (Ctrl for Windows) and select the other desired cells/ranges.
Multi-selection can be used to apply formats to discontinuous ranges simultaneously, select source ranges for charts, etc.
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:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Select multiple cells/ranges
To select multiple cells/ranges: Go to the icon, then choose View from the menu dropdown below the sheet tabs. Turn on the Multiple Selection toggle. This will insert a widget in the editor, using which you can turn on/off multiple selection ...How to lock cell ranges/sheets in Zoho Sheet?
What is the use of 'lock' in Zoho Sheet? You can lock cells that you don't want the collaborators to accidentally edit. When you publish a spreadsheet, you can always choose to lock formula cells to make your spreadsheet a little more secure. Owners ...Select a cell range
To select a cell range, 1. Click, and drag to select the cells you want.Change a cell's background color
To change the cell color Select the desired cell(s). Choose Fill Color icon from the default tool bar. Click on the required color. The color is applied to the chosen cell.Formatting different parts of the content or text in a cell
Zoho Sheet now lets you format different parts of the contents in a cell separately. To do this, Double click on a cell and enter edit mode. Select the part of the content you want to format. From the contextual short cut menu that appears above the ...