6 Excel quick operation tips, early meeting early leave work

** Like again, form a habit; Take credit for yourself. 阿鲁纳恰尔邦

Wechat search [Yixin Excel] to pay attention to this different we-media person.

In this paper, making github.com/hugogoos/Ex… Has been included, including Excel system learning guide series of articles, as well as a variety of Excel materials.

The world’s martial arts, only fast can not break. Fast is not only a realm, but also a kind of ability. Today I’m going to share 6 Quick Excel tricks that will save you even more time. After all, time is life and time is money.

1. Quick summation

So summation you know you can use the SUM function, but if you think about it, if you have a lot of rows and columns, how long does it take you to write a formula, and then apply that formula to each row and each column?

You have to write the formula at least twice like this, and then you have to do two more quick fillings.

Since it is called fast sum, then the spelling is naturally speed. Simply select the data area, then select one more column and row right and down in the C5:E9 cell area above, and press Alt+= to complete the quick summation:

2. Quick filling formula

How do you compute it quickly for a non-summation formula? I think most people type in the first formula, place the mouse in the lower right corner of the cell where the formula is, and drag the fill handle to fill the formula quickly.

Another simpler method is to input the formula first, and then place the mouse on the lower right corner of the cell where the formula is located. When the cursor becomes the filling handle, double click the left mouse button to fill the formula quickly:

3. Quick formatting

I believe you often use formatting, just need to select the cell you like, and then click on the format brush, click on the cell you want to process, you can turn the cell into their favorite style. If the cells you want to process are contiguous, format them once. What if the cells are not contiguous?

Real-time is also very simple, just need to double-click the format brush, this can quickly process the discontinuous cells:

4. Quickly select discontinuous cells

I think you usually select discrete cells by holding down the Ctrl key with one hand and clicking the mouse with the other. If there are too many cells and the Ctrl key is not held down at this moment, the mouse is clicked down again, congratulations on your chance to start again.

If you want to exit the selection state, just press “ESC”. If you want to exit the selection state, press “ESC”.

5. Quickly remove the time and keep the date

In the figure, we want to remove the time part from the date and time and keep only the date part. How do we do that? Of course it is possible to intercept string functions, but today we are going to show you another way, which is to use INT functions.

The INT function rounds a number down to the nearest integer. If you convert date and time into numbers, then the date corresponds to the integer part and the time corresponds to the decimal part, so you can use INT to intercept the integer part, which is the corresponding date:

6. Quickly adjust column width

When we usually deal with the table, it is inevitable to encounter the table column width is wide or narrow, resulting in some cell content cannot be fully displayed, or some cell content is too empty. What to do? Do you have to adjust cell by cell?

Of course not, select the column whose column width needs to be adjusted, and then place the mouse pointer between the two column headers. When the mouse pointer turns into a bidirectional single vertical arrow shape, double-click the left button of the mouse to quickly adjust the selected column width:

Today’s sharing ends here, but the road of learning has just begun, I hope we can keep moving forward on the road of learning, perseverance.

If you are interested in the feature, you can tell xiaobian oh, xiaobian will write a corresponding article for you. Of course, it’s first come, first written. I will make a schedule and try to meet everyone’s needs. So if the next article is not what you want, please don’t worry, it may be the next one. Let me know what you want to learn.

This article continues to update, you can search wechat “yixin Excel” first time to read, this article GitHub github.com/hugogoos/Ex… Excel System Learning Guide series, welcome Star.