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 add a comment: Select the cell/range on which you wish to comment. Click Insert > Comment > Add Comment. Alternatively, right click on the selected range and click Add Comment. Enter your comment in the comment field. Click Add.