15314599
Description
Flashcards by Amethyst Maxson, updated more than 1 year ago
|
Created by Amethyst Maxson
over 5 years ago
|
|
| Question | Answer |
| 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 formal 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 columns) In a PivotTable it selects the entire PivotTable report |
| Ctrl + Shift + : | enters the current time |
| Ctrl + Shift + " | copies the values from the cell above the active cell into the formula bar |
| Ctrl + Shift + Plus(+) | displays the Insert dialog box to insert blank cells |
| Ctrl + Shift + 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 Formal 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 |
| Ctrl + D | uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below |
| Ctrl + E | invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column |
| Ctrl + Shift + F | opens the Format Cells dialog box with the Font tab selected |
| Ctrl + G | displays the Go To dialog box |
| Ctrl + H | displays the Find and Replace dialog box with the Replace tab selected |
| Ctrl + K | displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks |
| Ctrl + L | displays the Create Table dialog box |
| Ctrl + O | displays the Open dialog box to open or find a file |
| Ctrl + Shift + P | opens the format cells dialog box with the Font tab selected |
| Ctrl + P | displays the Print tab in Microsoft Office Backstage view |
| Ctrl + Q | displays the quick analysis options for your data when you have cells that contain that data selected |
| Ctrl + R | uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right |
| Ctrl + T | displays the Create Table dialog box |
| Ctrl + Shift+ U | switches between the expanding and collapsing of the formula bar |
| Ctrl + Alt + V | displays the Paste Special dialog box |
| Ctrl + W | closes the selected workbook window |
| Ctrl + X | cuts the selected cells |
| Ctrl + Y | repeats the last command or action, if possible |
| F1 | displays the Excel Help task pane |
| Ctrl + F1 | displays or hides the Ribbon |
| Alt + F1 | creates an embedded chart of the data in the current range |
| Alt + Shift + F1 | inserts a new worksheet |
| F2 | edits the active cell and positions the insertion point at the end of the cell contents, also move the insertion point into the Formula Bar when editing in a cell is turned off |
| Shift + F2 | adds or edits a cell comment |
| Ctrl + F2 | displays the print preview area on the Print tab in the Backstage view |
| F3 | displays the Paste Name dialog box. |
| Shift + F3 | displays the Insert Function dialog box |
| F4 | repeats the last command or action is possible |
| Ctrl + F4 | closes the selected workbook window |
| Alt + F4 | closes Excel |
| F5 | displays the Go To dialog box |
| Ctrl + F5 | restores the window size of the selected workbook |
| F6 | switches between the worksheet, Ribbon, task pane, and Zoom controls |
| Shift + F6 | switches between the worksheet, Zoom controls, task pane, and Ribbon |
| Ctrl + F6 | switches to the next workbook window when more than one workbook window is open |
| F7 | displays the Spelling dialog box to check spelling in the active sheet or selected range |
| Ctrl + F7 | performs the Move command on the workbook window when it is not maximized, use the arrow keys to move the window and when finished press Enter, or Esc to cancel |
| F8 | turns extend mode on or off. In the extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection |
| Shift + F8 | enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys |
| Ctrl + F8 | performs the Size command when a workbook is not maximized |
| Alt + F8 | displays the Macro dialog box to create, run, edit, or delete a macro |
| F9 | calculates all worksheets in all open windows |
| Shift + F9 | calculates the active worksheet |
| Ctrl + Alt + F9 | calculates all worksheets in all open workbooks, regardless of whether they have changes since the last calculation |
| Ctrl + F9 | minimizes a workbook window to an icon |
| F10 | turns key tips on or off |
| Shift + F10 | displays the shortcut menu for a selected item |
| Alt + Shift + F10 | displays the menu or message for an Error Checking button |
| Ctrl + F10 | maximizes or restores the selected workbook window |
| F11 | creates a chart of the data in the current range in a separate Chart area |
| Shift + F11 | inserts a new worksheet |
| Alt + F11 | opens the Microsoft Visual Basic for Applications Editor, in which you can create macro by using Visual Basic for Applications |
| F12 | displays the Save As dialog box |
Want to create your own Flashcards for free with GoConqr? Learn more.