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