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

Hello, everyone. I'm Xiaolan who knows a little bit about Excel.

When I was surfing the Internet on 5G the other day, I saw a hot search related to Excel and full of "funny" flavor:

The ▲ picture comes from the network 84, 85, 86. 90 disinfectant. Boy, this is really good at using Excel, but not much.

Hot search below, many people have also complained: "often wait for the use of Baidu."

But! I don't know how to use such a simple Excel function, so should I reflect on myself [dog's head squint].

Today, we will specialize in drop-down filling in Excel!

Finally, remember to tell Xiaolan that how many of the seven uses explored by the Excel gods do you know?

01 drop-down fill ❶ directly drop-down fill data

❷ Click [Auto fill option] next to the cell

❸, just check "copy cells".

02 Select two rows to drop down and fill in ❶ to fill in two rows of data

❷ selects these two rows of data and drops down and populates them.

03 [Ctrl] + drop-down fill ❶ literally, hold down the [Ctrl] key

❷ places the mouse in the lower right corner of the first cell. When the mouse becomes one big and one small black cross, drag down to fill in the same data.

However, we need to remind students that in Microsoft Excel, if there are only numbers in the cell, instead of having both numbers and text as shown above, for example:

If you use the above method to populate the data, the numbers will be filled in ascending order.

When using it, you must pay attention to it.

04 batch copy and paste the so-called copy and paste here does not allow you to copy a "84 disinfectant" and then paste it one by one.

But copy it once and paste it in batch.

❶ presses the [Ctrl+C] key to copy the data in cell B1.

❷ selects other cells that need to be populated with data

❸ press the [Ctrl+V] key to paste.

05 fill down [Ctrl+D] ❶ enter "84 disinfectant" in B1 cell

❷ select B1 and all remaining cells and press the [Ctrl+D] key.

06 Smart fill [Ctrl+E] ❶ enter "84 disinfectant" in B1 cell

❷ select cell B2 and press the [Ctrl+E] key.

Knock on the blackboard:

The ① shortcut key [Ctrl+E] is called smart padding, and it is very powerful and useful. In addition to the function shown in the figure above, it can split & merge data, extract & add data.

👉 split & merge data:

👉 extraction & add data:

For more usage, you can dig slowly in practice.

② [Ctrl+E] requires a version of Office, which must be Microsoft Excel 2013 or above.

07 batch fill [Ctrl+Enter] ❶ select consecutive cells that need to enter the same content

❷ enter "84 disinfectant" and press [Ctrl+Enter] to complete the filling.

08 at the end, let's review today's knowledge points:

❶ drop-down fill-auto fill option-copy cells

❷ selects two rows of data drop-down fill

❸ press the [Ctrl] key to drop down the fill

❹ press the [Ctrl+C / V] key to copy and paste in batch

❺ presses the [Ctrl+D] key to fill the batch downward.

❻ presses the [Ctrl+E] key to fill the batch downward.

❼ press the [Ctrl+Enter] key to batch fill

One small problem:

Do you know why 84 disinfectant is called 84 instead of 85, 86. Is it?

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

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.