| Action | Key Combination |
|---|---|
| Deleting cells | Press Ctrl/- (minus sign). The selected cells will disappear and the adjacent cells will shift to fill the empty space. |
| Enter the same information that appeared in the last cell | Ctrl/' |
| Formatting- applies the Currency format using Dollars | Ctrl/Shift/$ |
| Formatting- applies the Percentage format | Ctrl/Shift/% |
| Hides selected columns | Ctrl/0 [zero] |
| Hides selected rows | Ctrl/9 |
| Inserts a blank cell | Ctrl/Shift/plus sign |
| Selecting a range of cells | Click in the first cell of the range, then press Shift, and click in the last cell of the range |
| Selecting a range of cells | Click in the first cell and then hold down the Shift key while you use the arrow keys to select the range |
| Shows selected columns | Ctrl/Shift/) |
| Shows selected rows | Ctrl/Shift/( |