Ctrl+a select all

Ctrl+b bold

Ctrl+c copy

Ctrl+d font format

Ctrl+e center alignment

Ctrl+f lookup

Ctrl+g positioning

Ctrl+h substitution

Ctrl+i italic

Ctrl+j is aligned at both ends

Ctrl+k hyperlink

Ctrl+l left alignment

Ctrl+m left indent

Ctrl+n new

Ctrl+o open

Ctrl+p printing

Ctrl+r right alignment

Ctrl+s save

Ctrl+t first line indentation

Ctrl+u underline

Ctrl+v paste

Ctrl+w write disk closed

Ctrl+x cut

Ctrl+y repeat

Ctrl+z undo

Ctrl+0 segment before 6P switching

Ctrl+ 1 single line spacing

Ctrl+2 double spacing

Ctrl+3 lock

Ctrl+5 1.5 times line spacing

Ctrl+= subscript and normal switching

Ctrl+shift+ capitalization

Ctrl+shift+b bold.

Ctrl+shift+c format copy

Ctrl+shift+d dispersion alignment

Ctrl+shift+e revision

Ctrl+shift+f defines the font.

Ctrl+shift+H applies the hidden format.

Ctrl+shift+I italic

Ctrl+shift+K small capital letters

Ctrl+shift+L list style

Ctrl+shift+M reduces left indentation.

Ctrl+shift+N demotes to text.

Ctrl+shift+P defines the character size.

Ctrl+shift+Q symbol font

Ctrl+shift+S defines the style.

Ctrl+shift+T reduces the indentation of the first line.

Ctrl+shift+U underline

Paste in ctrl+shift+V format

Ctrl+shift+W only underlines words.

Ctrl+shift+Z default font style

Ctrl+shift+= superscript and normal switching

Alt+shift+a displays all titles.

Alt+shift+C closes the preview.

Alt+shift+D insert date

Alt+shift+E Edit Mail Merge Data

Alt+shift+F inserts the merge field.

Alt+shift+K preview mail merge

Alt+shift+L display

Alt+shift+M prints the merged document.

Alt+shift+N merge documents

Alt+shift+O marks directory entries.

Alt+shift+P insert page number.

Alt+shift+R header and footer links

Alt+shift+T time

Alt+shift+U update field

Alt+shift+X marks index entries.

Alt+shift+ 1 displays "Title 1".

Alt+shift+2 displays "Title 2"

Alt+shift+3 shows "Title 3"

Alt+shift+5 Apply "Title 3"

Ctrl+alt+c copyright symbol

Ctrl+alt+E inserts endnotes.

Ctrl+alt+F insert footnote

Ctrl+alt+I preview

Ctrl+alt+K AutoFormat

Ctrl+alt+L listnum field

Ctrl+alt+M annotation verb margin

Ctrl+alt+N normal view

Ctrl+alt+O outline view

Ctrl+alt+P page view

Registered trademark registration

Ctrl+alt+S split window

Trademark trademark

Ctrl+alt+U update table format

Ctrl+alt+V insert AutoText

Ctrl+alt+Y repeat search

Ctrl+alt+Z returns

Ctrl+alt+ 1 Apply "Title 1"

Ctrl+alt+2 applies "heading 2"

Ctrl+alt+3 applies "heading 3"

Ctrl+alt+5 applies "Title 5"

Excel shortcut key:

Ctrl+P or CTRL+SHIFT+F 12: Displays the Print dialog box.

CTRL+ Up Arrow or+Left Arrow (Print Preview): Scroll to the first page when zooming out.

CTRL+ Down Arrow or+Right Arrow (Print Preview): Scroll to the last page when zooming out.

SHIFT+F 1 1 or ALT+SHIFT+F 1: insert a new worksheet.

CTRL+Page down: moves to the next worksheet in the workbook.

Ctrl+page up: Move to the previous worksheet in the workbook or select another worksheet.

Shift+ctrl+page down: select the current worksheet and the next worksheet.

Ctrl+page down: uncheck multiple worksheets.

Ctrl+shift+page up: Select the current worksheet and the previous worksheet.

Home: Move to the top of the row or the cell in the upper left corner of the window.

CtrL+home: move to the beginning of the worksheet.

Ctrl+end: Move to the last cell of the worksheet, which is located at the bottom row of the rightmost column occupied by data.

Alt+page down: move one screen to the right.

Alt+page up: move one screen to the left.

F6: Switch to the next pane in the split worksheet.

Shift+F6: Switches to the previous pane in the split worksheet.

F5: Displays the Locate dialog box.

Shift+F5: Displays the Find dialog box.

Shift+F4: Repeat the last search operation.

Ctrl+alt+ right arrow key: switch to the next selected area on the right in the non-adjacent selected area.

Ctrl+alt+ left key: switch to the next nonadjacent selected area on the left.

End+ arrow keys: move by block within a row or column.

End: Move to the cell in the lower right corner of the window.

Ctrl+ space: select the whole column.

Shift+ space: select the whole line.

Ctrl+A: Select the entire worksheet.

Ctrl+6: Switches between hiding objects, displaying objects and displaying object placeholders.

Ctrl+shift+*: Select the area around the current cell (data area in empty rows and columns). In the PivotTable, select the entire PivotTable.

Ctrl+shift+ Select all cells contained in the note.

Ctrl+[: Select all cells directly referenced by the formula in the selected range.

Ctrl+shift+{: Select all cells directly or indirectly referenced by the formula in the selected range.

Ctrl+]: Select the cell that contains the formula that directly refers to the active cell.

Ctrl+shift+}: Select the cell that contains the formula that directly or indirectly refers to the cell.

Alt+enter: wrap a line in a cell

Ctrl+enter: fills the selected cell range with the current entry.

F4 or ctrl+y: Repeat the previous operation.

Ctrl+d: padding down.

Ctrl+r: padding to the right.

Ctrl+F3: define the name

Ctrl+k: insert hyperlink

Ctrl+shift+:: insert time.

ctrl+； : Enter the date

Alt+ Down Arrow: Displays a drop-down list of values in the current column of the list.

Alt+0 165: enter the Japanese yen symbol.

F2: Move the insertion point to the edit bar after the editing status of the cell is turned off.

Shift+F3: In the formula, the Insert Function dialog box is displayed.

F3: Paste the defined name into the formula.

Alt+=: Insert "Auto Sum" formula with sum function.

F9: Calculate all worksheets in all open workbooks.

Shift+F9: Calculate active sheet.

Ctrl+delete: delete the text from the insertion point to the end of the line.

F7: Displays the spelling check dialog box.

Shift+F2: Edit cell comments

Ctrl+shift+z: Undo or restore the last AutoCorrect when the AutoCorrect smart tag is displayed.

Ctrl+c, then ctrl+c: Displays the Microft Office clipboard (copy and paste many times).

Ctrl+X: cut the selected cell.

Ctrl+V: paste the copied cell.

Ctrl+shift++: Inserts a blank cell.

Alt+ `: displays the style dialog box.

Ctrl+ 1: Displays the Cell Format dialog box.

Ctrl+shift+~: Applies the "normal" number format.

Ctrl+shift+$: Apply currency format with two decimal places (negative numbers are in brackets).

Ctrl+shift+%: Apply the "percentage" format without decimal places.

Ctrl+Shift+: Apply the number format of "scientific notation" with two decimal places.

Ctrl+shift+#: Apply Date format with year, month and day.

Ctrl+shift+@: Applies the "Time" format with hours and minutes, and indicates morning or afternoon.

ctrl+shift+！ : Apply the number format with two decimal places, use the thousands separator, and negative numbers are represented by minus sign (-).

Ctrl+B: apply or cancel bold formatting.

Ctrl+I: Apply or cancel font italic formatting.

Ctrl+U: apply or cancel the underline.

Ctrl+5: Apply or cancel strikethrough.

Ctrl+9: Hide the selected line.

Ctrl+shift+): Unhides all hidden columns in the first middle area.

ctrl+shift+& amp； : Applies an external border to the selected cells.

Ctrl+shift+_: Uncheck the outer border of the cell.

Page Down: Move to the same field of the previous 10 records.

Ctrl+Page Down: start a new blank record.