Excel 2013 shortcut

Keyboard shortcuts in Excel

1. Access the functional area through a keyboard

If you are not familiar with the functional area, the information in this section can help you understand the shortcut key model of the functional area. The function area comes with a new shortcut called "button prompt ". To display the "button prompt", press Alt.

650) This. width = 650; "Height =" 152 "Title =" clip_image001 "style =" border: 0px; padding-top: 0px; padding-Right: 0px; padding-left: 0px; background-image: none; "alt =" clip_image001 "src =" http://img1.51cto.com/attachment/201411/1/8362123_1414848293EcX2.jpg "border =" 0 "/>

The blog you read is from the lecture hall of Guo.

To display a tab on the functional area, press the button corresponding to the tab. For example, for the insert tab, press the letter N, or for the formula tab, press the letter M. This displays all the buttons corresponding to the tab button. Next, press the corresponding button.

The document you are reading is an Excel 2013 shortcut

Are my old shortcuts still available?

Keyboard Shortcuts starting with CTRL are still available in Microsoft Excel 2013. For example, CTRL + C still copies the content to the clipboard, while Ctrl + V still pastes the content from the clipboard.

Most of the old Alt + menu shortcuts are still available. However, you need to remember the complete shortcut because there is no on-screen prompt that requires letters. For example, if you try to press ALT and then press a button in the old menu key E (edit), V (view), I (insert), and so on. A dialog box is displayed, indicating that you are using the access key in earlier versions of Microsoft Office. If you know the entire key sequence, continue to execute the operation and start the command. If you do not know the sequence, Press ESC and use the button to prompt the badge.

2. CTRL + shortcut

Keywords	Description
CTRL + pgdn	Switch between the worksheet tabs from left to right.
CTRL + pgup	Switch between the worksheet tabs from right to left.
CTRL + Shift + &	Apply the contour border to the selected cell.
CTRL + shift _	Deletes the outline border from the selected cell.
CTRL + shift ++ ~	Apply the "regular" numeric format.
CTRL + Shift + $	Apply the "currency" format with two decimal places (the negative number is placed in brackets ).
CTRL + Shift + %	The application does not contain the "percentage" format of decimal places.
CTRL + Shift + ^	The scientific counting format with two decimal places is used.
CTRL + Shift + #	The application is in the date format of day, month, and year.
[Email protected]	The application is in the "time" format of hours, minutes, and am or PM.
CTRL + Shift +!	Apply the "value" format with two decimal places, thousands separator, and minus sign (-) (used for negative values.
CTRL + Shift + *	Select the current area (data area surrounded by blank rows and blank columns) of the active cells ). In the PivotTable, it selects the entire PivotTable.
CTRL + Shift +:	Enter the current time.
CTRL + Shift +"	Copy the value of the cell above the active cell to the cell or edit column.
CTRL + Shift + plus sign (+)	The insert dialog box is displayed.
CTRL + minus (-)	The delete dialog box is displayed.
CTRL +;	Enter the current date.
CTRL +'	Switch to display the cell values and formulas in the worksheet.
CTRL +'	Copy the formula from the cell above the active cell to the cell or edit column.
CTRL + 1	The "set cell format" dialog box is displayed.
CTRL + 2	Apply or cancel the bold format setting.
CTRL + 3	Apply or cancel the skew format settings.
CTRL + 4	Apply or remove the underline.
CTRL + 5	Apply or cancel strikethrough.
CTRL + 6	Switch between hidden objects and displayed objects.
CTRL + 8	Show or hide hierarchical display symbols.
CTRL + 9	Hide selected rows.
CTRL + 0	Hide selected columns.
CTRL +	Select the entire worksheet. If the worksheet contains data, press Ctrl + A to select the current region. Press Ctrl + A again to select the entire worksheet. When the insertion point is on the right of a function name in the formula, the "function parameters" dialog box is displayed. When the insertion point is on the right of a function name in the formula, press Ctrl + Shift + A to insert the parameter name and brackets.
CTRL + B	Apply or cancel the bold format setting.
CTRL + c	Copy the selected cell.
CTRL + d	Use the "fill down" command to copy the content and format of the top-level cells in the selected range to the following cells.
CTRL + E	Use the data around the column to add multiple values to the activity column.
CTRL + F	The "search and replace" dialog box is displayed, and the "Search" tab is selected. This tab is also displayed when you press SHIFT + F5, while the last "Search" operation is repeated when you press SHIFT + F4. Press Ctrl + Shift + F to open the "set cell format" dialog box, where the "font" tab is selected.
CTRL + G	The "locate" dialog box is displayed. Press F5 to display this dialog box.
CTRL + H	The find and replace dialog box is displayed. The replace tab is selected.
CTRL + I	Apply or cancel the skew format settings.
CTRL + k	The insert hyperlink dialog box is displayed for the new hyperlink, or the edit hyperlink dialog box is displayed for the selected existing hyperlink.
CTRL + L	The create table dialog box is displayed.
CTRL + n	Create a new blank workbook.
CTRL + O	The open dialog box is displayed to open or search for files. Press Ctrl + Shift + O to select all cells containing comments.
CTRL + P	The print tab is displayed in the Microsoft Office backstage view. Press Ctrl + Shift + P to open the "set cell format" dialog box, where the "font" tab is selected.
CTRL + q	When a cell contains the selected data, the "quick analysis" option is displayed for the data.
CTRL + R	Use the "fill to the right" command to copy the content and format of the leftmost cell in the selected range to the right cell.
CTRL + S	Use its current file name, location, and format to save the active file.
CTRL + T	The create table dialog box is displayed.
CTRL + u	Apply or remove the underline. Press Ctrl + Shift + u to switch between the expand and collapse edit columns.
CTRL + V	Insert the clipboard content at the insertion point and replace any selected content. This shortcut key can be used only after an object, text, or cell content is cut or copied. Press CTRL + ALT + V to display the "paste selected" dialog box. You can use this shortcut only after you cut or copy the content of an object, text, or cell in a worksheet or other program.
CTRL + W	Close the selected workbook window.
CTRL + x	Cut the selected cells.
CTRL + Y	Repeat the previous command or operation (if possible ).
CTRL + z	Use the undo command to undo the previous command or delete the last entered content.

The following message is displayed: Ctrl + J and CTRL + m are unallocated shortcuts.

3. function keys

Keywords	Description
F1	The Excel help task pane is displayed. Press Ctrl + F1 to display or hide the functional area. Press Alt + F1 to create an embedded chart for data in the current region. Press Alt + Shift + F1 to insert a new worksheet.
F2	Edit the active cell and place the insert point at the end of the cell content. If you do not want to edit a cell, it also moves the insert point to the edit column. You can add or edit cell comments by pressing SHIFT + F2. Press Ctrl + F2 to display the print preview area on the "print" tab in the backstage view.
F3	The "paste name" dialog box is displayed. Only applicable to situations where names have been defined in the workbook ("formula" tab, "defined name" group, "definition name "). Press SHIFT + F3 to display the "insert function" dialog box.
F4	Repeat the previous command or operation (if possible ). When the cell reference or area is selected in the formula, you can switch cyclically by F4. Press Ctrl + F4 to close the selected workbook window. Press Alt + F4 to close the Excel file.
F5	The "locate" dialog box is displayed. Press Ctrl + F5 to restore the window size of the selected workbook window.
F6	Switch between the worksheet, function area, task pane, and zoom control. In the split worksheet, click View, manage this window, freeze the split pane, and split the window, when switching between a pane and a functional area, press F6 to include the split pane. By Shift + F6, you can switch between the worksheet, zoom control, task pane, and functional area. If multiple workbook windows are opened, press Ctrl + F6 to switch to the next workbook window.
F7	The spelling check dialog box is displayed to check the spelling in the activity worksheet or selected range. If the workbook window is not maximized, press Ctrl + F7 to run the "move" command on the window. Use the arrow keys to move the window and press Enter when the window is complete or Press ESC to cancel.
F8	Enable or disable the extended mode. In extended mode, the extended selection appears in the status line, and you can expand the selected range by pressing the arrow keys. By pressing SHIFT + F8, you can use the arrow keys to add non-adjacent cells or areas to the selected range of cells. When the workbook is not maximized, press Ctrl + F8 to execute the "size" command (on the "control" menu in the workbook window ). Press Alt + F8 to display the "macro" dialog box for creating, running, editing, or deleting macros.
F9	Calculate all worksheets in all open workbooks. You can press SHIFT + F9 to calculate the activity worksheet. Press CTRL + ALT + F9 to calculate all worksheets in all open workbooks, regardless of whether they have been changed since the last calculation. If you press CTRL + ALT + Shift + F9, the dependent formula is re-checked, and all cells in all open workbooks are calculated, including cells not marked as the ones to be calculated. Press Ctrl + F9 to minimize the workbook window as an icon.
F10	Enable or disable the button prompt. (ALT can also achieve the same purpose .) Press SHIFT + F10 to display the shortcut menu of the selected project. Press Alt + Shift + F10 to display the menu or message used for the "error check" button. Press Ctrl + F10 to maximize or restore the selected workbook window.
F11	Create charts with data in the current range in a separate chart worksheet. Press SHIFT + F11 to insert a new worksheet. Press Alt + F11 to open the Microsoft Visual Basic for Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA.
F12	The "Save as" dialog box is displayed.

4. other useful shortcut keys

Keywords	Description
ALT	The "button prompt" (new shortcut) is displayed on the functional area ). For example, ALT, W, and P can switch the worksheet to "Page View ". ALT, W, l can switch the worksheet to "normal view ". ALT, W, and I can switch the worksheet to the "Page Preview" view.
Arrow Keys	Move a cell up, down, left, or right in a worksheet. Press Ctrl + arrow to move to the current data area of the worksheet (data area: the area of cells that contain data, which is surrounded by blank cells or data table borders .) . Press the SHIFT + arrow keys to expand the selected range of a cell. Press Ctrl + Shift + arrow to extend the selected range of cells to the last non-empty cell in the column or row where the active cell is located, or if the next cell is empty, the selected range is extended to the next non-empty cell. When the function area is selected, you can click the Left or Right button to select the tab on the left or right. When the sub-menu is open or selected, you can press these arrow keys to switch between the main menu and sub-menu. When the functional area tab is selected, press these keys to navigate to the tab button. When a menu or sub-menu is open, press the down or up key to select the next or previous command. When the functional area tab is selected, you can click these keys to navigate up or down the tab group. In the dialog box, press the arrow keys to move between options in the open drop-down list or between options in a group of options. Press the down key or Alt + down key to open the selected drop-down list.
Backspace	Delete a character on the left in the edit column. You can also clear the content of the active cell. In cell editing mode, you can press this key to delete the characters on the left of the insertion point.
Delete	Deletes the content (data and formula) of a cell from the selected cell without affecting the cell format or annotation. In cell editing mode, pressing this key deletes the characters on the right of the insertion point.
End	Press end to enable or disable the end mode. In end mode, you can press an arrow to move to the next non-blank cell (in the same column or row as the active cell ). Press the arrow keys and the end mode is disabled automatically. Before pressing the next arrow, make sure to press End again. When it is enabled, the end mode is displayed in the status bar. If the cell is empty, press the end and press the arrow to move to the row or the last cell in the column. When the menu or sub-menu is visible, you can select the last command on the end menu. Press Ctrl + end to move to the last cell on the worksheet, that is, the intersection cell of the bottom row in use and the rightmost column in use. If the cursor is in the editing bar, press Ctrl + end to move the cursor to the end of the text. Press Ctrl + Shift + end to extend the selected area of the cell to the last cell used on the worksheet (in the lower right corner ). If the cursor is in the editing bar, press Ctrl + Shift + end to select all text from the cursor position to the end in the editing bar, which does not affect the height of the editing bar.
Enter	Complete the cell input from the cell or edit bar, and (default) Select the following cell. In the data form, you can press this key to move to the first field in the next record. Open the selected menu (Press F10 to activate the menu bar) or execute the operation of the selected command. In the dialog box, press this key to execute the default command button (a button with a highlighted profile, usually a "OK" button) in the dialog box. Press Alt + enter to create a new row in the same cell. Press Ctrl + enter to fill the selected cell area with the current entry. Press SHIFT + enter to complete the cell input and select the above cell.
ESC	Cancel the input in the cell or edit column. Close the menu or submenu, dialog box, or message window. When the full screen mode is applied, you can press this key to disable this mode and return to normal Screen mode to display the functional area and status bar again.
Home	Move to the beginning of a row in the worksheet. When scroll lock is enabled, move it to the cell in the upper left corner of the window. When the menu or sub-menu is visible, select the first command on the menu. Press Ctrl + home to move to the beginning of the worksheet. Press Ctrl + Shift + home to extend the selected range of cells to the beginning of the worksheet.
Page down	Move a screen down in the worksheet. Press Alt + Page down to move a screen to the right of the worksheet. Press Ctrl + Page down to move to the next worksheet in the workbook. Press Ctrl + Shift + Page down to select the current and next worksheets in the workbook.
Page up	Move a screen up In the worksheet. Press Alt + page up to move a screen to the left in the worksheet. Press Ctrl + page up to move to the previous worksheet in the workbook. Press Ctrl + Shift + page up to select the current and previous worksheet in the workbook.
Space key	In the dialog box, select a button or select or clear the check box. Press Ctrl + space to select the entire column in the worksheet. Press SHIFT + space to select the entire row in the worksheet. Press Ctrl + Shift + space to select the entire worksheet. If the worksheet contains data, press Ctrl + Shift + Space key to select the current region. Press Ctrl + Shift + Space key again to select the current region and its summary row. Press Ctrl + Shift + Space key for the third time to select the entire worksheet. When an object is selected, press Ctrl + Shift + Space key to select all objects on the worksheet. Press Alt + Space key to display the "control" menu in the Excel window.
Tab	Move a cell to the right of the worksheet. In a protected worksheet, you can move between unlocked cells. In the dialog box, move to the next option or option group. You can move SHIFT + TAB to the previous cell in the worksheet or to the previous option in the dialog box. In the dialog box, press Ctrl + TAB to switch to the next tab. In the dialog box, press Ctrl + Shift + TAB to switch to the previous tab.

5. Appendix

The blog you read is from the lecture hall of Guo.

For more information, see Excel help.

Excel 2013 shortcut