Practical Excel skills sharing: 5 shortcut keys to improve work efficiency

This article will share with you the 5 most commonly used Excel shortcut keys to improve work efficiency, so that you can become a master in the eyes of your boss who can use the keyboard to make tables without the mouse. I hope it will be helpful to everyone.

#Everyone can use Excel, with varying levels of skill. If you can open this article today, you must want to improve your Excel skills. As the saying goes, only after you have high standards can you improve. So today I plan to follow the investment banking standards - throw away the mouse and just use the keyboard to share with you some of the most commonly used Excel shortcut keys.

The most commonly used shortcut keys in Excel 1: Ctrl arrows (up, down, left, and right)

If there is content in each row of the table, this operation can Allows you to jump from the "top" to the "bottom" of the table area with one click.

[Case]

We usually deal with a large series of data, such as the annual employee performance table, etc. There are hundreds of rows of data, and we can't rub the mouse. Scroll wheel or keep pressing the down arrow.

For example, if you want to jump from East China to Central China, first select the cell in East China, then hold down the Ctrl down arrow, and it will jump directly to cell A7, and then press the arrow again to jump to Cell A9;

If you want to select these at the same time, you have to hold down the Shift Ctrl down arrow.

【Summary】

Ctrl arrow can jump quickly. If there is an empty row in the middle, jump to the previous row of the empty row. Ctlr shift up/down arrows can quickly select consecutive multi-line areas.

The most commonly used Excel shortcut key 2: Shift Space

This function can quickly select an entire row of data.

For example, if your boss is discussing with you the sales of electrical appliances last year, you can select the fourth row of TV sales in East China at once, and visually distinguish them clearly without moving the mouse. The boss must look at you differently.

[Case]

I now want to turn all the text on the sales situation in East China into red. Without using the mouse, first hold down Shift + Space to select line 3, then release. Then hold down Shift ↓ and select lines 3 to 7 in sequence, and then change their font color to red.

【Summary】

Shift space can quickly select an entire line; hold down the Shift key and click multiple times The up/down arrow can select multiple rows continuously. The two methods can be used together to quickly select many rows continuously.

The 3 most commonly used shortcut keys in Excel: Ctrl D (copy top to bottom) and Ctrl R (copy left to right)

Very Commonly used functions, Ctrl D is to copy the content above to the bottom, D means down; Ctrl R is to copy the content on the left to the right, R means right.

[Case]

As shown below, cell B3 has no content. Press Ctrl R to copy the content of A3; then hold down Shift and press down arrow, select B3:B7, and press Ctrl D to copy all the contents of B3.

##[Summary]

Ctrl D/R is very important for daily work Commonly used functions. With this pair of shortcut keys, there's no need to copy and then paste.

The most commonly used shortcut keys in Excel 4: F2 to edit cell content

If you need to modify the cell content, just press F2 Call up the cursor. When only a cell is selected, inputting content directly will replace the original content. And use F2 to add content based on the original.

The most commonly used Excel shortcut keys 5: Alt Enter (line break within each)

This function requires holding down F2 first to enter the state of editing cell content, then press the left and right arrow keys to move the cursor to the corresponding position, and press Alt Enter to force a new line.

[Case]

As shown below, the number of words in A7 exceeds the cell size. It needs to be changed to two lines. The operation process is as follows: animation

Have you got all the above shortcut keys? Although you don’t need to force yourself to give up the mouse and use the keyboard when you usually work, when your boss or colleague encounters a problem and is puzzled, you go over and just click the keyboard to solve it, and you are instantly in their mind. So tall! Those who can get promotions and salary increases, don’t they do things that their bosses can’t do~

Related learning recommendations: excel tutorial

The above is the detailed content of Practical Excel skills sharing: 5 shortcut keys to improve work efficiency. For more information, please follow other related articles on the PHP Chinese website!