Practical Excel skills sharing: clever use of [Ctrl] and [Shift] shortcut keys

In the previous article "Sharing practical Excel skills: Calculating the difference in years, months, and weeks", we learned about calculating time differences (differences in years, months, and weeks) Methods. Today we are going to learn two shortcut keys [Ctrl] and [Shift]. Learning these two shortcut keys will save you a day!

When it comes to shortcut keys, many people will use combination shortcut keys such as [Ctrl C], [Ctrl V], [Ctrl A], and [Ctrl S]. Other than that, I only use the mouse to operate, which leads to a lot of data that can't be processed for a long time.

So, how to improve efficiency? In fact, in ordinary mouse operations, using the two functional auxiliary keys [Ctrl] and [Shift] will have unexpected effects, and it is natural to improve the operation efficiency...

Below, small Let me teach you some common tricks on these two shortcut keys!

Case 1

In this case, I want to sort the data of these two arrays in the same way. However, if you use the "sort" operation, it will fail because the left side is sorted and expanding the selected area will affect the right array. (Of course, it can also be solved with custom sorting. This chapter will not talk about 乛ᴗ乛)

At the same time, except for Shanghai, other sortings are the same. Big-eyed Xiaoza took a closer look - yes! The ones with red frames are the same, and so are the yellow ones!

So, it can be solved by dragging the mouse (move the mouse to the border and start dragging when it turns into a cross), but it is still a bit troublesome!

Here Xiaoza tells you that there is a simpler solution! ——Use [Shift] to match.

Solution 1

As shown in the picture below, just hold down [Shift] and drag the mouse during the operation.

It can be seen from this that the function of holding down the [Shift] key and dragging the mouse is to move, insert and automatically fill the original gap! For Xiao Za, it is super commonly used and super time-saving!

Case 2

If we want to copy the data while moving the data in a certain area, will you use [Ctrl C], [Ctrl V] key to achieve it (I must have guessed it!).

Solution 2

In fact, you can directly hold down the [Ctrl] key and drag the mouse to achieve it, which is very fast.

Case 3

If I want to copy and insert the data in the red box below to the right What about the red line?

If you use the [Shift] mouse to drag, the data on the left will be lost.

Solution 3

You can use [Ctrl] [Shift] mouse dragging to achieve this. As can be seen from Case 2 above, in Excel, the [Ctrl] key represents copying and the [Shift] key represents moving. The solution to this case is to hold down these two keys at the same time.

Sort it out:

1. Shift mouse drag: move the selection and insert, automatically fill the original gap

2. Ctrl mouse drag: move the copied selection

3. Ctrl Shift mouse drag: move the copy and insert the selection

Today’s content is very simple, just hold down [Ctrl] and [Shift] is just two keys, but the function it implements is very, very efficient! Please use it flexibly.

Related learning recommendations:excel tutorial

The above is the detailed content of Practical Excel skills sharing: clever use of [Ctrl] and [Shift] shortcut keys. For more information, please follow other related articles on the PHP Chinese website!