Word & Excel shortcut

▲Word shortcut

[F1] key: Help

[F2] key: move text or image, press enter to confirm

[F4] key: Repeat the previous operation

[F5] key: positioning during editing

[F6] key: switch between document, task pane, or other Word pane

[F8] key: Enable the Word selection mode

[F12] key: Open the "Save as" dialog box

[Shift + F2] key combination: Copy text

[Shift + F3] key combination: Change the case sensitivity of letters

[Shift + F4] key combination: duplicate search or location

[Shift + F12] key combination: Select the "save" menu item in the "file" menu.

[Shift + F5] key combination: The Last edited position in the jump document

[Shift + cursor] key combination: select a character on the left of the cursor

[Shift + →] key combination: select a character on the right of the cursor

[Shift + cursor] key combination: select the content between the cursor's current position and the previous line

[Shift + cursor] key combination: select the content between the current position of the cursor and the next line.

[Shift + Ena] key combination: select the cursor to the end of the row

[Shift + Home] key combination: select the cursor to the beginning of the line

[Shift + pageup] key combination: select a line between the current position of the cursor and the previous screen

[Shift + Pagedown] key combination: select a line between the current position of the cursor and the next Screen

[Ctri + F2] key combination: print preview

[Ctri + F4] combination key: Close the window

[Ctri + F6] key combination: switch between opened documents

[Ctri + F12] key combination: Open the "open" dialog box

[Ctri + 1] key combination: single-factor line spacing

[Ctri + 2] key combination: double line spacing

[Ctri + 5] key combination: 1.5 times the line spacing

[Ctri + O] key combination: add a line spacing before the segment

[Ctri + A] key combination: select all

[Ctri + B] key combination: The character becomes bold

[Ctri + C] key combination: Copy

[Ctri + shift + D] key combination: decentralized alignment

[Ctri + E] key combination: center paragraph

[Ctri + F] key combination: Search

[Ctri + G] key combination: positioning

[Ctri + H] key combination: replace

[Ctri + I] key combination: The character changes to italic

[Ctri + J] key combination: the two ends are aligned

[Ctri + K] key combination: Super connection

[Ctri + L] key combination: left aligned

[Ctri + N] key combination: New Document

[Ctri + M] key combination: indent of the left Section

[Ctri + O] key combination: Open the document

[Ctri + P] key combination: Print

[Ctri + Q] key combination: the row where the insertion point is located moves one character to the left

[Ctri + Q] combination key: Cancel Paragraph Format

[Ctri + R] key combination: Right-aligned

[Ctri + S] key combination: Save

[Ctri + T] combination key: Create suspension indent

[Ctri + U] key combination: underline the character

[Ctri + V] key combination: Paste

[Ctri + W] key combination:

[Ctri + X] key combination: clipboard

[Ctri + Shift + Z] key combination: clear format

[Ctri + shift] key combination: Input Method Conversion

[Ctri + F8] key combination: Open the macro dialog box

[Ctri + space] key combination: conversion between Chinese and western text

[Ctri + Enter] key combination: insert pagination character

[Ctri + shift + M] key combination: unindent the left Section

[Ctri + shift + F12] key combination: select the print menu item in the File menu.

[Ctri + shift + F] key combination: Changing the font

[Ctri + shift + P] key combination: Change the font size

[Ctri + shift +>] combination key: Increase the font size

[Ctri + shift <] key combination: reduce the font size

[Ctri + shift +] key combination: Increase the font size by pound

[Ctri + shift + [] key combination: reduce font size by pound

[Ctri + shift + C] key combination: copy format

[Ctri + shift + V] key combination: paste format

[Ctri + shift + T] key combination: reduces the amount of suspension indent

[Ctri + Enter] key combination: insert pagination character

[Ctri + Home] key combination: the insertion point is moved to the first part of the document.

[Ctri + End] key combination: Move the insertion point to the End of the document

[Ctri + shift + cursor] key combination: move the cursor to the start of the word

[Ctri + shift + →] key combination: move the cursor to the end of the word

[Ctri + shift + cursor] key combination: move the cursor to the beginning of the segment

[Ctri + shift + cursor] key combination: move the cursor to the end of the segment

[Ctri + shift + Home] key combination: move the cursor to the beginning of the document

[Ctri + shift + Ena] key combination: move the cursor to the end of the document

[Ctri + PGVP] key combination: Move the insertion point to the top of the previous page window

[Ctri + PGDW] key combination: Move the insertion point to the top of the next page

[Shift + Home] key combination: insert point to the beginning of the line

[Shift + Ena] key combination: insert point to end of line

[Shift + space] key combination: halfwidth/fullwidth Switch

[Ctri + left button] key combination: select a Text Segment

[Ait + left-click] combination key: select a piece of text

[Ait + Ctri + Shift + Pagedown] key combination: move the cursor to the end of the window

[Ait + Ctri + C] key combination: insert the copyright symbol

[Ait + Ctri + R] key combination: Insert a registered trademark

[Ait + Ctri + T] key combination: insert trademark symbol

[Ait + Ctri +.] key combination: insert ellipsis

[Ait + Tab] key combination: switching tasks and windows

[Ait + F4] key combination: Close the program

[Ait + space] key combination: drop-down Word control menu

[Ait + Prntscreen] key combination: Window copy.

Press and hold the [Ait] key to temporarily ignore the grid to make the image move smoothly.

Press the [Shift] key and select the image to be aligned in sequence to complete several image alignment tasks.

Press the [Shift] key and click "print preview" to print the worksheet quickly.

Press the [shift + Enter] key combination to insert a new slide behind the current slide.

Press the [Tab] key and select the next cell;

Press the [Shift + Tab] key combination to select the previous cell.

Press the [Shift] key and then press the Enter key to generate a line break.

If the window or form is opened and the database window is completely blocked, you only need to press [F11] (you can also press [Ait + F11]) and the database window will be prefixed.

Press the [Ctri +:] key combination to enter the current date;

Press the [Ctri + shift +:] key combination to enter the current time.

Select a large area, press the [Shift] key, and drag the mouse.

Select the rectangle area, press the [Ait] key, and drag the mouse (invalid in outline view ).

▲Excel shortcut keys and function keys help

Show all
Hide all
The following lists the Ctrl + shortcut keys, function keys, and some other common shortcut keys, as well as their function descriptions. For more information about all available shortcuts and their specific uses, see keyboard shortcuts.

To print this topic, press Tab, select "show all", Press Enter, and press Ctrl + P.

Note if you do not frequently use shortcuts, you can use the recording macro to create shortcuts.

Ctrl combination shortcut

Button description
Ctrl + (unhide all hidden rows in the selected range.
Ctrl +) unhide all hidden columns in the selected range.
Ctrl + & apply the outer box to the selected cell.
Ctrl + _ Delete the outer box from the selected cell.
Ctrl + ~ Apply the "regular" numeric format.
Ctrl + $ apply the "currency" format with two decimal places (the negative number is placed in brackets ).
Ctrl + % the application does not contain the "percentage" format of decimal places.
Ctrl + ^ apply the "exponential" format with two decimal places.
Ctrl + # apply the "date" format with day, month, and year.
Ctrl + @ The application uses the "time" format of the hour, minute, and AM or PM.
Ctrl +! Apply the "value" format with two decimal places, thousands separator, and minus sign (-) (used for negative values.
Ctrl +-the "delete" dialog box for deleting selected cells is displayed.
Ctrl + * select the current area of the active cell (data area surrounded by blank rows and blank columns ).
In the PivotTable, it selects the entire PivotTable.

Ctrl +: Enter the current time.
Ctrl +; enter the current date.
Ctrl + 'Switch to display the cell value and formula in the worksheet.
Ctrl + 'copy the formula from the cell above the active cell to the cell or edit bar.
Ctrl + "copy the value from the cell above the active cell to the cell or edit column.
Ctrl ++ displays the "insert" dialog box for inserting blank cells.
Ctrl + 1: The "cell format" dialog box is displayed.
Ctrl + 2 apply or cancel the bold format setting.
Ctrl + 3 apply or cancel the skew format setting.
Ctrl + 4 apply or remove the underline.
Ctrl + 5 apply or cancel strikethrough.
Ctrl + 6 switch between hidden objects, display objects, and display object placeholders.
Ctrl + 7 display or hide the commonly used toolbar.
Ctrl + 8 show or hide the outline symbol.
Ctrl + 9 hide the selected row.
Ctrl + 0 hide selected columns.
Ctrl + A 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.
If you press Ctrl + C twice in a row, the Microsoft Office clipboard is displayed.

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 + F: The "Search" dialog box is displayed.
Press Shift + F5 will also display this dialog box, while press Shift + F4 will repeat the last "Search" operation.

Press Ctrl + G to display the "locate" dialog box.
Press F5 to display this dialog box.

Ctrl + H: The "search and replace" dialog box is displayed.
Ctrl + I apply or cancel the skew format setting.
Ctrl + K displays the "insert HYPERLINK" dialog box for the new hyperlink, or the "Edit HYPERLINK" dialog box for the selected existing hyperlink.
Press Ctrl + L to display the "Create list" dialog box.
Ctrl + N create a new blank file.
Ctrl + O: the "open" dialog box is displayed to open or search for files.
Press Ctrl + Shift + O to select all cells containing comments.

Press Ctrl + P to display the "print" dialog box.
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 file format to save the active file.
Ctrl + U apply or cancel the underline.
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.
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 entry.
When the Smart tag for automatic correction is displayed, press Ctrl + Shift + Z to undo or repeat the command or resume the previous automatic correction operation.

Function key

Button description
F1 displays the help task pane.
Press Ctrl + F1 to close and re-open the current task pane.

You can press Alt + F1 to create charts with data in the current range.

Press Alt + Shift + F1 to insert a new worksheet.

F2 edits the active cell and places the insertion 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.
Press Shift + F2 to edit the cell annotation.

F3 paste the defined name into the formula.
Press Shift + F3 to display the "insert function" dialog box.

F4 repeat the previous command or operation (if possible ).
Press Ctrl + F4 to close the selected workbook window.

F5 displays the "locate" dialog box.
Press Ctrl + F5 to restore the window size of the selected workbook window.

F6 switch to the next pane of the worksheet that has been split ("window" menu, "split" command.
Press Shift + F6 to switch to the previous pane of the split worksheet.

If multiple workbook windows are opened, press Ctrl + F6 to switch to the next workbook window.

F7 displays the spelling check dialog box 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 Esc when the window is complete.

F8 enables or disables the extended mode. In extended mode, EXT 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 ranges to the selected range of cells.

When the workbook is not maximized, press Ctrl + F8 to execute the "size" command (in the "control" menu of the workbook window.

Press Alt + F8 to display the macro dialog box for running, editing, or deleting macros.

F9 calculates all worksheets in all open workbooks.
If you press F9 and then Enter (Ctrl + Shift + Enter for the array formula), the selected formula section is calculated and replaced with the calculated value.

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 related 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 select the menu bar or close the opened menu and sub-menu at the same time.
Press Shift + F10 to display the shortcut menu of the selected project.

Press Alt + Shift + F10 to display intelligently labeled menus or messages. If multiple Smart Tags exist, you can press the combination key to switch to the next Smart tag and display its menu or message.

Press Ctrl + F10 to maximize or restore the selected workbook window.

F11 creates charts for data in the current range.
Press Shift + F11 to insert a new worksheet.

Press Alt + F11 to open the Visual Basic Editor, where you can create a macro by using Visual Basic for Applications (VBA.

Press Alt + Shift + F11 to open the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code.

F12 displays the "Save as" dialog box.

Other useful shortcut keys

Button description
The arrow keys move a cell up, down, left, or right in the 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 same column or row as the active cell.

When the menu is visible, click the Left or Right button to select the menu on the left or right. When the sub-menu is open, you can press these arrow keys to switch between the main menu and sub-menu.

When a menu or sub-menu is open, press the down or up key to select the next or previous command.

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 Alt + down to open the selected drop-down list.

In the edit box, delete a character on the left.
You can also clear the content of the active cell.

Delete deletes the cell content (data and formula) 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 when Scroll Lock is enabled, move it to the cell in the lower-right corner of the window.
When the menu or sub-menu is visible, you can also select the last command on the 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.

Press Ctrl + Shift + End to extend the selected range of cells to the last cell used on the worksheet (bottom right corner ).

Enter completes cell input from the cell or edit bar, and (default) selects 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 cancels the input in the cell or edit bar.
You can press this key to close a menu, submenu, dialog box, or message window.

Home is moved 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 moves 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 moves 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.

In the dialog box, run the selected 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 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 moves 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.

Shift + Tab can be moved to the previous cell (in the worksheet) or 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.