Select multiple cell ranges

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.

    • Related Articles

    • 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. 
    • Copy the formats from one cell to another

      Format Painter can be used to copy the formatting present in a particular cell to other cells of the sheet. To use Format Painter 1. Select the cell you want to copy the format from. 2. Click on the Format Painter icon  from the toolbar. The format ...
    • Editing a cell in Zoho Sheet

      Click on the cell that you want to edit. From there, you can take the cell to it's edit state by hitting enter, or double clicking the cell.  After the edits are done, you can press enter, and your will be taken to the next line,
    • Multiple Choice Question

      Table of Contents Multiple Choice (One Answer) Multiple Choice (Many Answers) How do I add a multiple choice (one answer or many answers) question in my survey?   Multiple Choice (One Answer) This question type helps you choose one answer from a list ...