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 .
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 .
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 .
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 .
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 .
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 .
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 .
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 .
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 .
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 .
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