Term
Excel:
Ctrl + 0
Ctrl + 1
Ctrl + 9 |
|
Definition
Hide selected columns
Displays Format Cells Dialog Box
Hide selected rows |
|
|
Term
|
Definition
| Displays the Format Cells dialog box |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Move to next corner of selected range |
|
|
Term
|
Definition
| Alternate between displaying cell values and cell formulas. |
|
|
Term
| Excel: Ctrl + 1 -> Ctrl + Page Down+Alt + B |
|
Definition
| Apply or remove the bottom border |
|
|
Term
Excel:
Ctrl + 1::Page Down
Alt + H |
|
Definition
navigate format cells dialog
apply/remove horizontal divider |
|
|
Term
Excel:
Ctrl + 1::Page Down + Alt + L |
|
Definition
| Apply or remove the left border |
|
|
Term
| Excel: Ctrl + 1 -> Ctrl + Page Down + Alt + R |
|
Definition
| Apply or remove the right border |
|
|
Term
Excel:
Ctrl + 1::Page Down + Alt + T |
|
Definition
| Apply or remove top border |
|
|
Term
| Excel: Ctrl + 1 -> Ctrl + Page Down+Alt + V |
|
Definition
| If cells in multiple columns are selected, apply or remove the vertical divider |
|
|
Term
Excel:
Ctrl + B
Ctrl + I
Ctrl + U |
|
Definition
|
|
Term
Excel:
Ctrl + Backspace
Ctrl + Delete |
|
Definition
Scroll to display active cell
Deletes text to end of line |
|
|
Term
Excel:
Ctrl + Delete
Ctrl + Backspace |
|
Definition
Delete text to the end of the line
Moves focus to active cell |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
Excel:
Ctrl + Enter
Ctrl + Shift + " |
|
Definition
Fill the selected cell range with the current entry
Copy the value from the cell above the active cell into the cell or formula bar. |
|
|
Term
|
Definition
| Remove the outline border from the selected cells. |
|
|
Term
Excel:
Ctrl + Shift + :
Ctrl + Shift + & |
|
Definition
Enter the time
Apply Outline Border |
|
|
Term
Excel:
Ctrl + Shift + "
Ctrl + Shift + : |
|
Definition
Copy the value from the cell above the active cell into the cell or formula bar.
Enter the time. |
|
|
Term
Excel:
Ctrl + Shift + (
Ctrl + Shift + ) |
|
Definition
Unhide any hidden rows
Unhide any hidden columns |
|
|
Term
|
Definition
| Unhide any hidden columns within the selection |
|
|
Term
|
Definition
| Apply the outline border to the selected cells |
|
|
Term
Excel:
Ctrl + Shift + #
Ctrl + Shift + ;
Ctrl + Shift + : |
|
Definition
Apply the DDMMYY
Enter Date
Enter Time |
|
|
Term
|
Definition
| Apply the percentage format with no decimal places |
|
|
Term
Excel:
Ctrl + Shift + End
Ctrl + Shift + Enter |
|
Definition
Extend...lower right-hand corner
Enter as array formula |
|
|
Term
Excel:
Ctrl + Shift + Enter |
|
Definition
| Enter a formula as an array formula |
|
|
Term
Excel:
Ctrl + Shift + F3
Ctrl + Shift + ~ |
|
Definition
Create names from row and column labels
Apply general number format |
|
|
Term
Excel:
Ctrl + Shift + Home |
|
Definition
| Extend the selection to the beginning of the worksheet |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Excel: Shift + End + Arrow Key |
|
Definition
| Extend selection to the last non-blank cell in the same column or row as the active cell |
|
|
Term
Excel:
Shift + End + Enter
Ctrl + Shift + End |
|
Definition
Extend...last cell, current row.
Extend...last used cell...lower right-hand corner |
|
|
Term
|
Definition
Display the Go To Dialog Box
Display the Find Dialog Box |
|
|
Term
Excel:
Home only
Home while in F2 |
|
Definition
| Move to beginning of a row, Move to the beginning of a line |
|
|
Term
| Excel: Function & Ctrl + A |
|
Definition
| When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box. |
|
|
Term
| Excel: Function & Ctrl+Shift + A |
|
Definition
| When the insertion point is to the right of a function name in a formula, insert the argument names and parenthses. |
|
|
Term
|
Definition
| Paste a defined name into a formula |
|
|
Term
Excel:
Shift + Enter
Shift + Tab |
|
Definition
Complete a cell entry and select the next cell above
Complete and move to previous cell on left |
|
|
Term
Excel:
Shift + F11
Legacy equivalent Alt + I + W |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
Excel:
Ctrl + F
Shift + F5
Ctrl + F5 |
|
Definition
Opens search
Display the Find Dialog Box
Restore window size of current workbook |
|
|
Term
|
Definition
| Extend selection to the beginning of the row |
|
|
Term
Excel:
Shift + Tab
Shift + Spacebar |
|
Definition
Complete and select the previous cell to the left
select entire row |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Delete the selected cell. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
Excel:
Alt + I + W
Shift + F11 |
|
Definition
|
|
Term
Excel:
Ctrl + K
Alt + E + E + K |
|
Definition
|
|
Term
Excel:
Ctrl + N
Shift + F11 |
|
Definition
New Workbook
New Worksheet |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Move to previous worksheet |
|
|
Term
|
Definition
|
|
Term
Excel:
Ctrl + F3
Ctrl + Shift + F3 |
|
Definition
Define a name
Create names from row and column labels |
|
|
Term
Excel:
Ctrl + F4 or Alt + F + ?
Alt + F4 |
|
Definition
Close Workbook
Closes the current window |
|
|
Term
Excel:
Ctrl + F5
Alt + E + G = F5 |
|
Definition
Restore window size of current workbook
Edit, Go To |
|
|
Term
|
Definition
| Displays child window option to restore, move, resize, minimize, maximize, or close window |
|
|
Term
Windows:
Shift + F10
Ctrl + F10 |
|
Definition
Opens a shortcut menu for the selected item (this is the same as right-clicking an object
Maximize Window |
|
|
Term
|
Definition
| Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window) |
|
|
Term
|
Definition
| Closes the current window |
|
|
Term
|
Definition
| Switch between multiple windows in the same program |
|
|
Term
|
Definition
| Closes the current Multiple Document Interface (MDI) window |
|
|
Term
|
Definition
| Activates menu bar options |
|
|
Term
| Windows: Alt + Down Arrow |
|
Definition
| Opens a drop-down list box |
|
|
Term
Windows:
Ctrl + Esc
Ctrl + Shift + Esc |
|
Definition
Opens the Start menu
Opens Task Manager |
|
|
Term
Windows:
Ctrl + Shift + Esc |
|
Definition
| Opens Windows Task Manager |
|
|
Term
Windows:
Alt + Tab
Ctrl + Tab |
|
Definition
Switch programs
Switch child MDI within program |
|
|
Term
|
Definition
| Switch to the next child window |
|
|
Term
|
Definition
|
|
Term
| Displays the Format Cells dialog box |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Move to next corner of selected range |
|
Definition
|
|
Term
| Alternate between displaying cell values and cell formulas. |
|
Definition
|
|
Term
| Apply or remove the bottom border |
|
Definition
| Excel: Ctrl + 1 -> Ctrl + Page Down+Alt + B |
|
|
Term
| If cells in multiple rows are selected, apply or remove the horizontal divider |
|
Definition
Excel:
Ctrl + 1::Page Down + Alt + H |
|
|
Term
| Apply or remove the left border |
|
Definition
| Excel: Ctrl + 1 -> Ctrl + Page Down+Alt + L |
|
|
Term
| Apply or remove the right border |
|
Definition
| Excel: Ctrl + 1 -> Ctrl + Page Down+Alt + R |
|
|
Term
| Apply or remove top border |
|
Definition
| Excel: Ctrl + 1 -> Ctrl + Page Down+Alt + T |
|
|
Term
| If cells in multiple columns are selected, apply or remove the vertical divider |
|
Definition
| Excel: Ctrl + 1 -> Ctrl + Page Down+Alt + V |
|
|
Term
|
Definition
|
|
Term
| Scroll to display active cell |
|
Definition
|
|
Term
| Delete text to the end of the line |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
Excel:
Legacy equivalent for F5, Go To |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Fill the selected cell range with the current entry |
|
Definition
|
|
Term
| Remove the outline border from the selected cells. |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Copy the value from the cell above the active cell into the cell or formula bar. |
|
Definition
|
|
Term
| Unhide any hidden rows within the selection |
|
Definition
|
|
Term
| Unhide any hidden columns within the selection |
|
Definition
|
|
Term
| Apply the outline border to the selected cells |
|
Definition
|
|
Term
| Apply the date format with the day, month, and year |
|
Definition
|
|
Term
| Apply the percentage format with no decimal places |
|
Definition
|
|
Term
| Extend to the last used cell on the worksheet in the lower right-hand corner |
|
Definition
|
|
Term
| Enter a formula as an array formula |
|
Definition
|
|
Term
| Create names from row and column labels |
|
Definition
|
|
Term
Extend to the A1
Move to A1 |
|
Definition
Excel:
Ctrl + Shift + Home
Ctrl + Home |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Extend selection to the last non-blank cell in the same column or row as the active cell |
|
Definition
| Excel: Shift+End + Arrow Key |
|
|
Term
| Extend the selection to the last cell in the current row. |
|
Definition
|
|
Term
| Display the Go To Dialog Box |
|
Definition
|
|
Term
| Move to beginning of a row, Move to the beginning of a line |
|
Definition
|
|
Term
| When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box. |
|
Definition
|
|
Term
| When the insertion point is to the right of a function name in a formula, insert the argument names and parenthses. |
|
Definition
|
|
Term
| Paste a defined name into a formula |
|
Definition
|
|
Term
| Complete a cell entry and select the next cell above |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
Excel Find Next
Windows Close Window |
|
Definition
Excel: Shift+F4
Windows: Alt + F4 |
|
|
Term
| Display the Find Dialog Box |
|
Definition
|
|
Term
| Extend selection to the beginning of the row |
|
Definition
|
|
Term
| Complete a cell entry and select the previous cell to the left |
|
Definition
|
|
Term
|
Definition
Excel:
Alt + F + X
Ctrl + W
Ctrl + F4 |
|
|
Term
| Delete the selected cell. |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
Excel: Ctrl + N
Alt + F + N |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Move to previous worksheet |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
Excel: Ctrl+F4
also Alt + F + X |
|
|
Term
| Restore window size of current workbook |
|
Definition
|
|
Term
| Displays the Multiple Document Interface (MDI) child window's System menu (from the MDI child window's System menu, you can restore, move, resize, minimize, maximize, or close the child window) |
|
Definition
|
|
Term
| Opens a shortcut menu for the selected item (this is the same as right-clicking an object |
|
Definition
|
|
Term
| Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window) |
|
Definition
|
|
Term
| Closes the current window |
|
Definition
|
|
Term
| Switch between multiple windows in the same program |
|
Definition
|
|
Term
| Closes the current MDI window |
|
Definition
|
|
Term
| Activates menu bar options |
|
Definition
|
|
Term
| Opens a drop-down list box |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Opens Windows Task Manager |
|
Definition
Windows:
Ctrl + Shift + Esc |
|
|
Term
Switch to another running program
Switch to window in the same program |
|
Definition
Windows:
Alt + Tab
Ctrl + Tab |
|
|
Term
| Switch to the next child window of a Multiple Document Interface (MDI) program |
|
Definition
|
|
