| 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. |
| 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/( |
Excel 