What are the office shortcut keys?

##Complete list of commonly used Office shortcut keys

Word common shortcut keys

Find text, format and special itemsCtrl G

Make characters bold Ctrl B

Add underline to charactersCtrl U

Delete paragraph format Ctrl Q

Copy selected text or object Ctrl C

Cut selected text or object Ctrl X

Paste text or object Ctrl V

Undo the previous operation Ctrl Z

Repeat the previous operation Ctrl Y

Single spacing Ctrl 1

Double spacing Ctrl 2

1.5 times Line spacing Ctrl 5

Add a line spacing before the paragraph Ctrl 0

Center the paragraph Ctrl E

Disperse alignment Ctrl Shift D

Cancel the left paragraph indent Ctrl Shift M

Create hanging indent Ctrl T

Decrease hanging indent Ctrl Shift T

Cancel paragraph format Ctrl Q

Create with current or recent Create a new document of the same document type as the one used Ctrl N

Open the document Ctrl O

Undo the split document window Alt Shift C

Save the document Ctrl S

Related recommendations: "

Word Beginner's Tutorial"

Common Excel Shortcut Keys

Move to the next worksheet in the workbook CTRL Page down

Move to the previous worksheet in the workbook or select other worksheets ctrl page up

Select the current worksheet and the next worksheet shift ctrl page down

Unselect multiple worksheets ctrl page down

Select the current worksheet and the previous worksheet ctrk shift page up

Move to the beginning of the row or the cell in the upper left corner of the window home

Move to the beginning of the file ctrL home

Move to the end of the file ctrL end

Move one screen to the right Alt page down

Move one screen to the left Alt page up

Switch to the next pane in the split worksheet F6

Display the "Locate" dialog box F5

Display the "Find" dialog box. shift F5

Repeat the last search operation shift F4

select the entire column ctrl space

select the entire row shift space

select the entire worksheet. ctrl A

Fill the selected cell area with the current input item ctrl enter

Repeat the previous operation F4 or ctrl y

Fill down. ctrl d

fill to the right. ctrl r

Define name ctrl F3

Insert hyperlink ctrl k

Insert time ctrl shift:

Enter date ctrl;

Display the drop-down list of values ​​in the current column of the list alt Down Arrow

Enter the Japanese yen symbol alt 0165

After closing the editing state of the cell, move the insertion point to the edit column F2

In a formula, display the Insert Function dialog box. shift F3

Paste the defined name into the formula F3

Insert the "AutoSum" formula using the SUM function Alt =

Calculate all in all open workbooks Worksheet F9

Calculation activity worksheet. shift F9

Delete text from the insertion point to the end of the line. ctrl delete

Display the "Spelling Check" dialog box F7

When the "AutoCorrect" smart tag is displayed, undo or restore the last automatic correction. ctrl shift z

Display the Microft Office clipboard (multiple copy and paste) ctrl c then ctrl c

Cut the selected cell ctrl X

Paste the copied cell ctrl V

Insert blank cells ctrl shift

Display the "Style" dialog box alt `

Display the "Format Cells" dialog box ctrl 1

Apply "Regular" number format ctrl shift ~

Apply "currency" format with two decimal places (negative numbers are in brackets) ctrl shift $

Apply "percent" format with no decimal places ctrl shift %

Apply the "scientific notation" number format with two decimal places ctrl shift ^

Apply the "date" format with year, month, and day ctrl shift

#Apply the "time" format with hours and minutes and indicate AM or PM ctrl shift @

Apply "with two decimal places, use thousands separators and negative numbers represented by a minus sign (-) Number" format. ctrl shift!

Apply or cancel bold format ctrl B

Apply or cancel font italic format ctrl I

Apply or cancel underline ctrl U

Apply or cancel strikethrough ctrl 5

Hide the selected row. ctrl 9

PowerPoint common shortcut keys

Change character format between lowercase or uppercase Ctrl T

Change letter case Shift F3

Apply bold format Ctrl B

Apply underline Ctrl U

Apply italic format Ctrl l

Apply subscript format (automatically adjust spacing) Ctrl Equal sign

Apply superscript format (automatically adjust spacing) Ctrl Shift plus sign

Delete manual character formatting, such as subscripts and superscripts Ctrl Spacebar

Copy text format Ctrl Shift C

Paste text format Ctrl Shift V

Center align paragraph Ctrl E

Align both ends of the paragraph Ctrl J

Align the paragraph to the left Ctrl L

Align the paragraph to the right Ctrl R

Start the presentation in full screen. F5

Perform the next animation or advance to the next slide. N, Enter, Page Down, Right Arrow, Down Arrow or Spacebar

Execute the previous animation or return to the previous slide. P, Page Up, Left Arrow, Up Arrow or Spacebar

Go to slide number. number Enter

Displays a blank black slide, or returns to the presentation from a blank black slide. B or period

displays a blank white slide, or returns to the presentation from a blank white slide. W or comma

to stop or restart automatic presentation. S

End the presentation. Esc or hyphen

to erase the comment from the screen. E

Go to the next hidden slide. H

Set a new rehearsal time during rehearsal. T

The original rehearsal time will be used during rehearsal. O

Advance by mouse click during rehearsal. M

Re-record slide narration and timing R

Return to the first slide. Press and hold the left and right mouse buttons simultaneously for 2 seconds

Show or hide the arrow pointer A or =

The above is the detailed content of What are the office shortcut keys?. For more information, please follow other related articles on the PHP Chinese website!