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

The original title: "efficiency is 10 times faster!" Excel unexpectedly hides these dreamy functions! "

Hello, everyone! I am Xiaolan who "loves and kills each other" with Excel.

In previous articles, we have learned many keyboard shortcuts that can be done without a mouse, such as:

[Ctrl+T]: Super table

[Ctrl+E]: smart fill

[Alt+F1]: quickly insert bar chart

……

However, Excel still has a lot of work that can be done by dragging and dragging the mouse. It's cool to be proficient in using them!

Today, I'm going to teach you seven of these tips!

Let's take a look. How many do you know?

Table area, move ▋ if you want to move one column of data to another column method ❶:

Select a column of data, move the mouse to the intersection of the column marks, turn into a black cross, hold down the left button and drag directly to other columns, and release the left button.

▲ data Source: NetEase Digital Reading (what is the most bald job? If the other columns have data, after releasing the left button, you need to click OK in the pop-up dialog box.

Method ❷:

Select a column of data, right-drag to the specified location, release the right button, and select "move to this location" in the pop-up options.

▋ two-column / row data interchange method ❶:

Hold down the [Shift] key and the left mouse button, drag to the column sideline and release, and the two columns of data will be exchanged. It's the same thing.

Method ❷:

Hold down the right button and drag to the right to the specified location + 1 column, release the right button, and select "move selected area, move original area right" in the pop-up options.

Knock on the blackboard:

When ① uses right-click to swap row data, you need to select "move the selected area, move the original area down".

When ② uses right-click to swap row and column data, drag right and down to add + 1 column / row to the specified position; left and up are not necessary.

▋ move table region method ❶:

Select all the table area, move the mouse over the edge of the table, turn into a black cross, hold down the left button and drag, and then release.

Method ❷:

Select all the table area, move the mouse over the edge of the table, turn it into a black cross, hold down the right button and drag, and select "move to this location" in the pop-up options.

Copy a variety of forms and quickly copy tables in ▋ with one delay: ❶:

Hold down [Ctrl] and the left mouse button to drag the copy.

Method ❷:

Drag the right mouse button and select "copy to this location" or "copy the selected area, move the original area to the right / down".

▋ Quick copy format Select the format you want to copy, hold down the right mouse button and drag, and select copy format only from the pop-up options.

▋ Formula to numerical value select the column where the formula is located, right-click to drag to one side, do not release and drag back to the original position, select "copy values only".

Table rows and rows, quickly insert / delete ❶ hold down the [Shift] key and drag down when the cursor displays "two-way Arrow"

Drag ❷ up to quickly delete rows.

Quickly insert / delete columns, same as above.

All right, that's all for the operation part, let's sum it up again:

To sum up, by dragging ❶ with the mouse, you can move, copy, insert / delete rows and columns in the table area.

❷ right-drag to complete the following tasks:

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