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

Original title: "Douban 8.2!" After watching wandering Earth 2, I found this must-learn Excel skill! "

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

A flap score of 8.2! Has everyone seen the very popular movie wandering the Earth 2 recently?

I've seen not only wandering Earth 2, but also 34567.

▲ pictures from the Internet, this and last year's 84, 85, 86. 90 disinfectant. There are really similarities and differences.

▲ pictures come from the Internet, in fact, as long as you know a little about the drop-down filling in Excel, you can completely avoid this awkward situation.

Drop-down fill ❶ directly drop-down / double-click mouse fill data

❷ Click [Auto fill option] next to the cell

❸, just check "copy cells".

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

❷ select these two rows of data, drop-down / double-click the mouse to fill.

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 a big and a small black cross, drag / double-click the mouse 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.

Copy and paste in batches, copy and paste here does not allow you to copy a "wandering Earth 2" and then paste it one by one.

But copy it once and paste it in batch.

❶ press the [Ctrl+C] key to copy the data in the B3 cell

❷ selects other cells that need to be populated with data

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

Ctrl+D fills ❶ down and enters "wandering Earth 2" in cell B3.

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

Ctrl+E Smart fill ❶ enter "wandering Earth 2" in B3 cell

❷ select cell B4 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.

Ctrl+Enter batch fill ❶ Select consecutive cells that need to enter the same content

❷ enter "wandering Earth 2" and press [Ctrl+Enter] to complete the filling.

Write at the end:

Finally, 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

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: 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.