Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
28 Cards in this Set
- Front
- Back
|
Ctrl+PgDn |
Switches between worksheet tabs, from left-to-right. |
|
|
Ctrl+PgUp |
Switches between worksheet tabs, from right-to-left. |
|
|
Ctrl+Shift+& |
Applies the outline border to the selected cells. |
|
|
Ctrl+Shift_ |
Removes the outline border from the selected cells. |
|
|
Ctrl+Shift+~ |
Applies the General number format. |
|
|
Ctrl+Shift+$ |
Applies the Currency format with two decimal places (negative numbers in parentheses). |
|
|
Ctrl+Shift+% |
Applies the Percentage format with no decimal places. |
|
|
Ctrl+Shift+^ |
Applies the Scientific number format with two decimal places. |
|
|
Ctrl+Shift+# |
Applies the Date format with the day, month, and year. |
|
|
Ctrl+Shift+@ |
Applies the Time format with the hour and minute, and AM or PM. |
|
|
Ctrl+Shift+! |
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
|
|
Ctrl+Shift+* |
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).In a PivotTable, it selects the entire PivotTable report. |
|
|
Ctrl+Shift+: |
Enters the current time. |
|
|
Ctrl+Shift+" |
Copies the value from the cell above the active cell into the cell or the Formula Bar. |
|
|
Ctrl+Shift+Plus |
Displays the Insert dialog box to insert blank cells. |
|
|
Ctrl+Minus (-) |
Displays the Delete dialog box to delete the selected cells. |
|
|
Ctrl+; |
Enters the current date. |
|
|
Ctrl+` |
Alternates between displaying cell values and displaying formulas in the worksheet. |
|
|
Ctrl+' |
Copies a formula from the cell above the active cell into the cell or the Formula Bar. |
|
|
Ctrl+1 |
Displays the Format Cells dialog box. |
|
|
Ctrl+2 |
Applies or removes bold formatting. |
|
|
Ctrl+3 |
Applies or removes italic formatting. |
|
|
Ctrl+4 |
Applies or removes underlining. |
|
|
Ctrl+5 |
Applies or removes strikethrough. |
|
|
Ctrl+6 |
Alternates between hiding and displaying objects. |
|
|
Ctrl+8 |
Displays or hides the outline symbols. |
|
|
Ctrl+9 |
Hides the selected rows. |
|
|
Ctrl+0 |
Hides the selected columns. |
