2 hours to sort out the 10 excel operation skills, animation demonstration, collection spare it
A wonderful life 2021-02-23 10:54:45
【 reminder 】 dear friend , Please click before reading 【 Focus on 】, Your support will be my biggest motivation !

Master some Excel Tips , It can save us a lot of trouble in our work , And then over time , Then your job may be to count 、 Press... A few times , It's done in a flash , Today, Mr. Zhong shared some tips that can greatly improve work efficiency .

01. Double click the mouse to quickly select the last cell in the front row

usage : Select cell , Move the mouse to the border under the cell , Into a cross with arrows , Then double click to jump to the last cell in this column , No matter how many rows this table has , It's suitable for many table rows , Need to get to the last line quickly .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


02. Double click the mouse to fill the formula

usage : When a column needs to be filled with a formula , You can input the first formula , Enter to confirm , Check this cell again , Move the mouse to the lower right corner of the cell , In the shape of a little cross , Then double-click to complete the whole column formula filling , As long as the preceding cells are continuous , More lines will do .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


03. Click the mouse to select all sheets

usage : When the mouse clicks on the upper left corner of the worksheet , A position with an oblique triangle , Just select the entire worksheet , We can set up the entire worksheet .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


04. Quickly select a contiguous range of cells

usage : Enter the cell address in the name box , Press enter to select this area , For example, you need to select B3:F9 Cell range . This method is suitable for selecting a large range of cells .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


05. Auto sum function button

usage : If you use the above for the sum 02. Double click to fill in the formula if it's too much trouble , You can try : Select the data area and the column of the calculation result , Click on 【 Start 】 Tab 【 Automatic summation 】 Button , The sum calculation can be completed .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


06. Drag with the right mouse button

usage : When our formula area needs to be converted to a numerical value , You can select the data area , Hold down the right mouse button , Drag to the right , Drag it back , Release the right mouse button and the menu will pop up , We choose 【 Copy values only 】, The formula becomes a value .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


07. Quick positioning worksheet

usage : When a lot of worksheets are created in the workbook , It's troublesome to find which worksheet to activate , We can right-click on the blank space on the left side of the worksheet tab , The list dialog box pops up , Double click the worksheet you want to display .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


08. Quickly select the empty cell

usage : You need to enter empty cells in the table " nothing ", We can press Ctrl+G Key to call up the positioning window , choice 【 Location condition 】-【 Null value 】-【 determine 】, The empty cell is selected , Input " nothing " Post press Ctrl+ Enter all done .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


09. Zoom the selection

usage : When you display data with a projector , We want to display all or part of the forms on the screen , You can select the data area to display , Click on 【 View 】 Tab 【 Zoom to selection 】 Button , You can enlarge the data area you need to display .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


10. Quickly insert multiple blank lines

usage : When a table needs to insert multiple empty rows , For example, we need to insert a blank line after the third line , First click on the line number 3, Pick number three , Hold down Shift Key not put , Move the mouse to the lower left corner of the first cell , When the cursor changes to a double horizontal line with a down arrow , Press the left mouse button and drag down , You can insert a blank line , Drag down as many blank lines as you want to insert .

2 It's been hours 10 individual Excel Operation skills , Dynamic diagram demonstration , Save it for later


friends , In the use of Excel What other problems have been encountered in , Comments area comments, discuss learning together , It's not easy to stick to originality , Your like forwarding is the biggest support for Xiaobian , For more tutorials, click on the column below .

Ctrl And 17 A combination of symbol keys , Master the work more handy , Keep it in reserve

Ctrl Key and 10 A number key , stay Excel You can play like this , It is worth collecting

Excel Shortcut key tips ,Ctrl+Shift+ Numbers , Take your time
版权声明
本文为[A wonderful life]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210223105346500p.html
相似文章

2021-08-09