Like and see, form a habit; When trees shine in the forest, the wind will destroy them. Wechat search [Yixin Excel] to pay attention to this different we-media person. In this paper, making github.com/hugogoos/Ex… Has been included, including Excel system learning guide series of articles, as well as a variety of Excel materials.
While Shift is a frequently used shortcut in everyday computer use, it has at least 20 uses in Various combinations in Excel. Today, I’m going to share with you the four key combinations of the Shift shortcut and the seven key combinations, and this does not include any other key combinations, just Shift and mouse.
1. Select the region
1.1. Select the continuous area
When selecting continuous areas, we usually select the starting cell, hold down the left mouse button, and drag the mouse to the target cell to complete the selection of continuous cells. This method is usually the most used method, but this method is not very friendly for choosing a relatively large area.
The “Shift” shortcut is perfect for this.
The operation method is also very simple, first select the start cell, then find the target cell, you can use the mouse wheel to make the target cell appear within mouse click range, hold down the “Shift” key and click the target cell.
If scrolling to find the target cell is still annoying, you can also enter the address of the target cell directly from the name box in the upper left corner of the cell.
Here is a concrete demonstration:
It should be noted that when using the name box, you need to press “Enter” to Enter the address of the target cell, so the screenshot software will display “Shift+Enter”, but this is not a combination key function, only the name box needs “Enter”.
1.2. Quickly scroll down/right to select the area
Quick down/right selection refers to the quick down/right selection from the currently selected area to the last row/column of continuous data, paying attention to continuous data.
The operation method is also very simple. For example, if you select cell A1 first, hold down the “Shift” key and move the mouse to the bottom line of cell A1. When the mouse turns into A black cross arrow shape, double-click the mouse, and the n consecutive rows in column A will be quickly selected. Similarly, if you hover over the right line of cell A1, double-clicking will select the first row, columns A through N.
If A1:B1 is selected and selected down, n consecutive rows in AB can be quickly selected. A1:A2 is also selected and selected right to quickly select the first and second rows from A to N.
So there are two things to note here: ① You can actually select data regions, not just individual cells; ② Then select the last row of continuous data down/right.
Take a look at the renderings:
2. Move the area
2.1. Quickly insert rows/columns
The “Shift” shortcut can also be used to quickly insert multiple blank lines.
The principle of inserting rows/columns is the same, so let’s take the behavior example. First, there are two options: select the entire row or select a partial range of cells.
Hold down the Shift key and move the mouse pointer to the fill handle at the lower left corner of the selected row. When the mouse pointer turns into a bidirectional double horizontal arrow, drag the mouse pointer down to quickly insert any blank row.
Hold down the “Shift” key while selecting the middle cell area and move the mouse pointer to the fill handle in the lower right corner of the selected cell area. The following operations are the same as when selecting the entire row to quickly insert a blank row.
Insert columns refer to how rows are inserted. Let’s look at the dynamic effects:
2.2. Move rows/columns quickly
To be exact, you can move an entire row or column, or you can move a region of selected cells.
After selecting the cell area you want to move, hold down the “Shift” key and move the mouse over the border line
Turn into a black cross arrow and drag the mouse to move the cell area.
3. Draw a positive picture
3.1. Insert a positive shape and horizontal line
Insert positive shape refers to positive triangle, square, circle, etc.
Select the shape you want to draw by clicking “Shape” in the “Illustration” command group under the “Insert” TAB, hold down the “Shift” key, and then draw it in the worksheet.
Horizontally drawn by “straight lines” in “lines”;
Triangles are drawn by isosceles triangles in basic Shapes.
A square is drawn by a rectangle inside a rectangle;
Circles are drawn by “ellipses” in “Basic Shapes”;
The heart is drawn by “heart” in “Basic Shape”.
Let’s take a look at the effect directly:
4, multi-table operation
4.1. Modify worksheet contents in batches
For a batch of worksheets with the same specifications, when we find that the data in a certain cell area is out of order and needs to be modified, do we really need to modify worksheets one by one?
Of course not. Just hold down the “Shift” key, select all the worksheets that you want to change, and then make changes in the cells that you want to change.
4.2. Quickly close all files
I don’t know if you’ve ever had to open multiple Excel files at once, but it would be a waste of time to close them all. Just hold down the “Shift” key and click any Excel Close button.
Here are seven simple “Shift” shortcuts to use.
Today’s sharing ends here, but the road of learning has just begun, I hope we can keep moving forward on the road of learning, perseverance.
If you are interested in the feature, you can tell xiaobian oh, xiaobian will write a corresponding article for you. Of course, it’s first come, first written. I will make a schedule and try to meet everyone’s needs. So if the next article is not what you want, please don’t worry, it may be the next one. Let me know what you want to learn.
This article continues to update, you can search wechat “yixin Excel” first time to read, this article GitHub github.com/hugogoos/Ex… Excel System Learning Guide series, welcome Star.