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

Is the office too inefficient? That's because you don't know much about Excel! Today, Mr. Wang will share with you some classic Excel skills that are worth learning. I believe they can help you!

1. Disaggregation techniques by breaking down, we can squeeze the data into a cell and split it.

Select the column of data, go to "data"-"data tools"-"separate"-"next", and then enter your delimiter in the box next to "other". Next, select "Target area" to complete.

2. The fast fill sequence usually drops down and fills, which will repeat the cell data. If we hold down the Ctrl and fill it down, we will get the sequence.

3, double-click fill we usually drop down the cell, to achieve downward fill, if there is a lot of content, then keep dragging down. In fact, we also have an efficient way to double-click the border in the lower right corner of the cell to quickly fill it down.

4. Is the adaptive column width still adjusting the cell width manually? It's too inefficient. We can select the column and double-click the divider in the middle of the cell to adjust the width quickly and adaptively.

5, adjust the position of rows or columns if we need to adjust the position of a column of data, we can select the column, and then press and hold "Shift" not loose, with the left mouse button to drag to the target location, you can quickly adjust the position of a column.

6. In the fast summation work, we often calculate the summation. Here we share a quick summation method. First select the data in the table, and then use the "Alt + =" key combination, you will be able to sum with one button. Is it very fast?

7. The upgraded version of the above method of batch subtotal, which will teach you to work out subtotal in batch. First select the entire table, then press the "F5" button to enter the "positioning condition"-"null value", and then press the "Alt + =" key combination, you can quickly get all the subtotals.

8. Summation of two tables if there are two tables that need to be summed up, you can use the "operation"-"plus" in "selective paste" to help us finish quickly.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

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.