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

The title of the original text: "the 10 classic skills of Shift key, the daily office is indispensable?" "

Do you know the use of the "Shift" key in Exce? Today, Mr. Wang is here to share with you the ten classic uses of the "Shift" button.

1, one button to close all workbook work, we often open multiple Excel windows, to close when the trouble, but also one by one to click close. If you hold down the "Shift" key and then close one of the windows, all the windows will be closed.

2. Insert blank lines how to quickly insert multiple blank lines? Select the entire line, then position the cursor at the bottom of the line, when the cursor changes to "two-way arrow", hold down the "Shift" key and drag down to create a blank line.

3. Do you want the figure to move horizontally or vertically? do you want the figure to drag on a straight line or vertical line? Hold down the "Shift" key and drag it.

4. How to draw a square and circle how to draw a circle or square? Just hold down the "Shift" key and draw it.

5. When the data table for exchanging rows and columns is ready, what if the data of some rows or columns need to be adjusted and swapped? Select the row or column that needs to be adjusted, hold down the "Shift" key, and drag the left button to the appropriate position.

6. Enter the same content in multiple worksheets. How to enter the same content in multiple worksheets? Press and hold the "Shift" key, then select multiple worksheets, and then enter the contents in the table.

7, select the entire row or column of data area first select the first cell, and then position the cursor to the bottom of the cell, press and hold the "Shift" key, and then double-click the left button, you can select the entire row or column area.

8, one click to select the entire row or column data area we can also use the shortcut key to select the entire row or column data area, "Ctrl + Shift + →" select the entire row, "Ctrl + Shift + ↓" select the entire column data area.

9. One-click insert comment shortcut key "Shift + F2" can insert an annotation with one click.

10. Insert a new worksheet "Shift + F11" to create a new worksheet!

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

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.