Shulou(Shulou.com)11/24 Report--

The original title: "the madam is easy to use!" These Excel shortcuts make you 10 times more efficient! "

Hello, friends, I am a farmer who specializes in difficult and complicated numbers.

I heard a psychological term yesterday: the butterfly effect, that is, a small change in a time or place can have a great impact later or elsewhere.

Thinking of my actual work a few days ago, I suddenly found that our work efficiency could not be improved. In addition to objective factors, we did not attach importance to trivial time. I thought it was nothing to waste a few seconds at a time, but it added up to a considerable amount.

So, how to make full use of every second in data processing?

This requires us to skillfully master the commonly used shortcut keys!

Today, I will introduce to you the wonderful use of the [Shift] key in Excel to help you improve the efficiency of Excel data processing.

01, record data with [Tab] and [Enter] keys, we can quickly switch cells when entering data, come and go freely.

Add the [Shift] key, and you can move it backwards.

02. Selecting region selecting data region is one of the high-frequency operations that use Excel to process data.

Many friends are used to clicking the first cell with the mouse, and then dragging to the last cell.

Actually, there's a faster way, ↓.

Select the first cell, hold down the [Shift] key, and then click the last cell to select all the fields.

If you want to select consecutive rows or columns in an area, we also have a good idea: select the corresponding first row / first data and press [Ctrl+Shift + Down Arrow / right Arrow].

It should be noted that if there are blank rows or columns in the data, we need to press the "arrow in the corresponding direction" several times to select all the data ~

03. Change the data ❶ to insert empty rows / columns in batches. Xiaobai: click right mouse button-[insert].

Master: select the whole row or column of data, place the mouse cursor over the lower-right corner of the row or column, hold down the [Shift] key, and when the cursor changes into a separate shape of the up and down arrows, you can drag the mouse to insert any number of empty rows or columns.

The advantage of this is that if there is other data in the nearby area, no matter how many rows or columns are inserted in the area of the table, there will be no sudden increase in blank rows or columns in other data areas.

❷ modifies content in batches. When we deal with data, we often encounter multiple worksheets, for example, we deal with sales data sheets from January to December or the scores of multiple classes, if we want to sum the scores or sales in each worksheet, it is obviously a waste of time to click on each worksheet to sum.

At this point, we have to use the [Shift] key for batch summation.

Select the first worksheet, hold down the [Shift] key, and select the last worksheet that needs to be modified

Then select the corresponding content to sum it, do you feel efficient enough to fly?

If you want to modify the content in batch, the operation is the same as above.

Note: the selected worksheet structure (number of rows, columns, fields, etc.) must be exactly the same.

❸ moves data locations quickly. To move a row or column of data to the appropriate location, our routine operation is to select the column of data, cut it, and finally paste it in the selected location.

This operation is also inefficient, and a simpler way is to select this column of data, press the [Shift] key and drag to the appropriate location to OK.

04, keyboard shortcuts Excel there are many shortcuts related to the [Shift] key, here I will only list a few of the more commonly used.

❶ quickly closes all workbooks. Many friends must have the experience that when we are dealing with data, there are too many workbooks open in the computer desktop, and the computer taskbar does not close the same task, but when we want to close after work, one is too slow, and the computer is easy to stutter if it doesn't perform well (don't ask me why).

At this time, we just need to hold down the [Shift] key, and then click any workbook [close] to close all the forms at once.

Please remember to save it! Don't be like me!

❷ quickly opens the insert function window. When writing a function, if we don't know how to write the function, we can usually click the insert function button on the left side of the edit bar, or click the insert function command in the Formula tab to open the insert function window.

In addition, we can also choose to use the [Shift+F3] key combination to quickly call up.

❸ quickly inserts annotations. When we enter or process data, we use the annotation function if we need to comment on the corresponding data.

There are many ways to insert comments in Excel, such as pressing the right mouse button "New comment" or clicking "New comment" on the "Review" tab.

If you want to go faster, use [Shift+F2]!

05. Knowledge Review uses the [Shift] key to do all kinds of Excel operations. Do friends feel that they can save a lot of time in their daily work?

Next, let's summarize the main points of this article, 👇👇👇:

❶ records data. [Shift+Enter]

[Shift+Tab]

❷ selects the region. [start cell + Shift key + end cell]

[Ctrl+Shift + down arrow / right arrow]

❸ changes the data. Insert empty rows / columns in batches

Modify content in batch

Quickly move data location

❹ shortcut key. Quickly close all workbooks

Quickly open the insert function window-[Shift+F3]

Quick insert comment-[Shift+F2]

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: farmer, Editor: Yali Zi, Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.