Office2007 office software shortcut key general usage

We need to master some common shortcuts to help us improve efficiency. For office novices, the first shortcut key that needs to be mastered is f1, that is, help, when we have problems with the use of the software, we can press f1 to activate the help document, and then we can enter our problem search solution. There is also the office general shortcut, which has the same function in word, excel, and ppt, and lists it:

Ctrl+N New, Ctrl+O Open, Ctrl+S Save, Ctrl+W Close, Ctrl+C Copy, Ctrl+V Paste, Ctrl+X Cut, Ctrl+A Select All, Ctrl+Z Undo, Ctrl+Y Restore Repeat, Ctrl+F Search, Ctrl+H Replace, if you want to know more, hurry up to Boyuan Education to learn!

ctrl+n

Create a new file.

ctrl+o

Open the file. ctrl+s

File saving. ctrl+p

Printout. ctrl+a

Select all.

ctrl+x

Shear. ctrl+c

Copy. ctrl+v

Stickup. ctrl+z

Resume the operation. ctrl+home

Move the cursor to the file header.

ctrl+end

Move the cursor to the end of the file.

ctrl+f

Find. ......Wait, it's too much.

You can press the F1 key and search for all the shortcuts in the help.

There are also commonly used screenshot shortcuts:

prtsc copies the entire screen to the clipboard.

alt+prtsc

Copies the current window to the clipboard.

Let's take a look at what useful shortcuts are available for officeWord commonly used shortcut keys. Find text, formatting, and special items ctrl+f

Make the characters bold ctrl+b.Add an underscore to the character ctrl+u.Remove paragraph formatting ctrl+q

Copy the selected text or object Ctrl+CCut the selected text or object Ctrl+XPaste text or objects Ctrl+V

There is also the office general shortcut key, which has the same function in word, excel, and ppt, and lists it: ctrl+n new, ctrl+o open, ctrl+s save, ctrl+w close, ctrl+c copy, ctrl+v paste, ctrl+x cut, ctrl+a select all, ctrl+z undo, ctrl+y restore duplicate, ctrl+f search, ctrl+h replace.

There are so many shortcuts in Office that you don't need to memorize them all. Just remember the ones that are commonly used.

1. New: ctrln

2. Open: CTRLO

3. Print: CTRLP

4. Save: imitation denier ctrls

5. Select all: CTRLA

6. Bold: ctrlb

7. Italics: ctrli

8. Copy: CTRLC

9. Paste: ctrlv

10. Find: CTRLF

11. Positioning: CTRLG

12. Replace: ctrlh

13. Cut: CTRLX

14. Repeat: ctrly

15. Undo: ctrlz

16. Left alignment: CTRLL

17. Left indent: macro defeat ctrlm

18. Standby Absolute Disturbance Right Alignment: CTRLR

19. Font format: ctrld

20. Center alignment: Ctrle

21. Align both ends: ctrlj

22. The first line is indented: CTRLT

1. Ctrl+Shift+4: currency format.

Purpose: Set Amount to currency format.

Method: Select the target cell area, i.e. G3:G12 area, and use the shortcut key Ctrl+Shift+4 to do so.

2. Ctrl+Shift+5: Percentage format.

Purpose: Set the completion rate to a percentage format.

Method: Select the target cell region, i.e. G3:G12 region, and use the shortcut key Ctrl+Shift+5 to select the target cell region.

Interpretation: If you want to keep decimals, you still need to set [Format Cells] to achieve it.

3. Ctrl+Enter: Batch filling.

Purpose: To enter "batch filling" in the h3:h12 area at one time.

Method: Select the content of the target cell, enter "Batch Fill", and then press Ctrl+Enter to fill in batches.

Interpretation: The range of batch population can be multiple rows and columns, or multiple selected regions.

4. CTRL+T: One-click beautification**.

Purpose: Beautify**.

Method: Select the target cell region, i.e., the A2:H12 region, press CTRL+T to open the [Create Table] dialog box, and click [OK] to close the [Create Table] dialog box.

Interpretation: If you want to cancel the deletion option, you can click Convert to Region in the Tools group in the Table Design menu.

Purpose: Fill part of the cells in red.

Method: Select the first target cell and fill it in red.

II. III ......target cells, f4.

6. Ctrl+shfit+arrow keys: quickly select multiple rows and columns.

Objective: Quickly select the target area.

Method: Select the base cell, such as A2, shortcut keys Ctrl+Shift+ and Ctrl+Shift+.

Interpretation: In addition to selecting content to the right and down, you can also select content left or up.

7. Ctrl+D: Fill down.

Method: Select the target cell or range, shortcut key Ctrl+D.

8. Ctrl+R: Fill to the right.

Purpose: Fill the left side to the right.

Method: Select the target cell or region on the right, and press CTRL+R.

9. alt+=: fast sum.

Purpose: Quickly sum sales by "month" and individual.

Method: Select the target cell region, including the summation region, i.e. C3:I13 region, and the shortcut key Alt+= is sufficient.

10. Ctrl+E: Fill or extract according to the rules.

Purpose: Extract the date of birth from the number in the province.

Method: Enter the first person's birth date and month in the first target cell, select all target cells, including the first cell with the birth date and month, and shortcut key Ctrl+E.