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 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:
New to Zoho Forms?
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Bigin?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
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 ...