[Organize and share] 10 sets of magical and practical Excel shortcut keys, even masters use them!

Every Excel person has a dream of becoming a master, hoping that Excel can be operated smoothly and all data work can be completed quickly. How to become a great god? Or how to get close to the great god? Let’s start with the shortcut key operations that all the masters like. Through these shortcut keys, you can improve the efficiency of daily work by at least 80%. The following article will share with you several sets of Excel shortcut keys that are also used by great experts. Come and learn to use them to quickly improve your work efficiency and never work overtime again!

Zixijun has been in the world for decades, and he is always asked a question: How long does it take to improve Excel skills? Half a year? One year? Five years?

Today, the self-study gentleman will teach you (sorry, passed by, introduced) the "quick method", which can make everyone's Excel skills achieve a qualitative leap in just 10 minutes.

This quick method is to practice - practice - fast - shortcut - key!

Dismissive?

Maybe the first set of shortcut keys will shock (thunder) you!

Group 1: Shake and leave only one window

Recommended index: ★★★★☆

Hold down the mouse on what needs to be displayed If you shake the window, only the window you press and hold will be displayed on the computer desktop, and the others will be automatically minimized. Shake again, and the friends are back again. This method is not specifically targeted at Excel software, as long as it is a Windows system, it can be used.

#The following continues to shock (thunder) people.

Group 2: Routine operations, must be able to do it

Recommendation index: ★★★★★

Ctrl A All Select

Ctrl Z Undo

Ctrl X Cut

Ctrl C Copy

Ctrl V Paste

Ctrl B Bold

Ctrl S Save

Wow, this too Are they considered god-level shortcut keys? So normal! Some friends protested:

#Really, these keys are also commonly used by great masters, even though they are common.

The third group: F2 and F4, right-hand assistants

Recommended index: ★★★★★

F2 key Quickly enter the cell and enter the editing state, which is equivalent to the effect of double-clicking the left button. This shortcut key is considered a secret secret of self-study.

F4 key Repeat the previous action, or switch the relative reference, absolute reference and mixed reference of the cell address.

Repeating the previous action is the most awesome, it is simply a god-like operation. For example, if you want to set the "font size to increase, bold, and red" for some cells, we can use this technique.

The fourth group: double-click the left button, three magical functions

Recommended index: ★★★★★

Magical Use 1: Double-click the edge of the row or column to get the most suitable row width or column width. It is valid when the text in the cell is incomplete or there is space.

Magical Use 2: Double-click the lower right corner of the cell to automatically fill it downwards.

Magical Use 3: Double-click the cell border (either up, down, left or right) to jump directly to the corresponding furthest cell in the current table area.

##Group 5: Quick summation

Recommended Index: ★★★★★

Alt = Quick sum

The following animation shows the use of

Alt =The shortcut keys and the 6th group of quick-jump cell shortcut keys jointly perform the "happy" - complete the sum of 6000 rows of data in 2 seconds:

Group 6: Quickly jump/select cells

Recommended index: ★★★★★

##Ctrl arrow

Quickly move to the edge of the area in the direction of the data arrow. The arrow here refers to any of the four arrow keys →↓←↑ on the keyboard.

Ctrl Shift Arrow

Quickly select the area from the front cell to the edge in the direction of the arrow.

Ctrl Home

Move to the upper left corner of the worksheet, usually cell A1.

Ctrl Shift Home

Quickly select all cells from the current cell to the upper left corner of the worksheet.

Ctrl End

Move to the lower right corner of the worksheet.

Ctrl Shift End

Quickly select all cells from the current cell to the rightmost corner of the worksheet. The above shortcut keys may seem difficult to operate, but they actually follow certain rules.

Ctrl Arrow or Home, End are mainly used to select cells.

If you hold down Shift again, everything between the two cells will be selected.

Group 7: Find and replace, efficient operation

Recommended index: ★★★★☆

Ctrl F Find

Ctrl H Replace

Group 8: Line breaks within cells, must be able to

Recommended index: ★★★ ★★

Alt Enter Line breaks within cells

One of the most common difficulties encountered by Excel beginners is the inability to Wrapping input in a cell is not like copying and pasting or searching and replacing, which can be done directly with the mouse. Without this shortcut key, some operations cannot be completed.

Group 9: Quickly input the current time

Recommended index: ★★★☆☆

Ctrl; Quick input Current date)

Ctrl Shift; Quickly enter the current time

In fact, this operation is very 6 and very practical, the key Not many people know about it.

Group 10: Setting properties

Recommendation index:★★★☆☆

Ctrl 1 Setting properties

Regarding the setting operation, if you can’t find it in the menu bar, pressing this shortcut key will basically bring it out. Isn’t it very practical?

For example: Select any cell and press the "Ctrl 1" shortcut key, which is equivalent to right-clicking the cell and selecting "Format Cells".

Select the column chart and press the "Ctrl 1" shortcut key, which is equivalent to selecting the column chart, right-clicking and selecting "Format Axis".

#How about it? The shortcut keys introduced by the self-study gentleman did not disappoint you, right? These 10 sets of shortcut keys are selected based on the frequency of use and the degree of assistance to daily work. Although there are many articles on the Internet introducing Excel shortcut keys, most of them list a large number of them regardless of priority and are not targeted. Some operations we only encounter once in a century are actually "shortcut keys".

A message to all my friends, the shortcut key operation should be: practical first, cool second, and reliable for flirting with girls.

Related learning recommendations: excel tutorial

The above is the detailed content of [Organize and share] 10 sets of magical and practical Excel shortcut keys, even masters use them!. For more information, please follow other related articles on the PHP Chinese website!