excel编辑技巧（Excel editing skills）.docVIP

excel编辑技巧（Excel editing skills） Input of score If you input 1/5 directly, the system will turn it into January 5 solution: enter 0 and enter the blank to enter the score. The input for sequence 001 If you enter the 001 system automatically, the solution is: enter the in the western text, then enter 001. Date input If you type April 5, type 4/5 and press enter. If you want to enter the current date, click CTRL and; Two keys. Fill the stripe If you want to join the horizontal stripes in the workbook, can use alignment filling: first, fill in the cell with * or ~ and other characters, and then click the cell, drag the mouse to the right, select horizontal number of cells, point the mouse right click on a cell, select set the cell format - cell format, alignment, horizontal, fill, ok. Populate the discontinuous cell with the same data Selected cell, hold down the CTRL key, use the mouse to click the other cells, these cells all selected, enter data in the editing area, and then press CTRL key and press enter at the same time, the cell will appear the same content. Display the formula in the cell If the data in the worksheet is mostly generated by a worksheet, you want to know the formula for the cell to edit and modify. Can be like this: with the mouse the left key click tools menu - options - view - window options, formulas, ok Quickly delete the contents of the cell If you want to delete the contents of the cell or its annotations, formatting, etc., you cannot simply select the cell to delete. To clear the cell thoroughly, you can use the following options: select the range - edit - clear - all. 1. Similarly, the SUM summation formula can be used to perform subtraction operations in cell or cell area references. For example, the A1 case is 100, and the value of the B1 cell is minus, of course you can write the formula for C1 = A1 - B1. But its a little bit of a problem to ask for the formula to subtract a lot of cells, and its written as: 1. Discontinuous cell: A1 mi