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, ...
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.
To highlight locked cells: Click Data > Lock > Highlight Locks or go to the View Settings in the side panel > Highlight Locks. The cells that have been locked for all collaborators will be highlighted and visible now. To remove the cell/range ...
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 ...
To limit the date range in a calendar question: Click Calendar type question. Click Advanced options. Select an operand and the From and To dates for the respondents to select a date within a specified range.