这些技巧简单易记,确可大大提高工作效率,作者可以按需（These techniques are simple and easy to remember, it can greatly improve the working efficiency, the author can according to need）.docVIP

这些技巧简单易记,确可大大提高工作效率,作者可以按需（These techniques are simple and easy to remember, it can greatly improve the working efficiency, the author can according to need） 1, the rapid input of the euro symbol Hold down the Alt key, then press the number keyboard on the 1, 2, 8, can enter the euro symbol at this skill in Word, Excel, in general. 2, fast switching table: The shortcut key combination Ctrl+PageUp switch to the current work form before a work table; the Ctrl+PageDown key combinations can be switched to the current sheet after a work table. 3, with automatic mark Format Cells failing grades Assume with red font below 60 points, blue font above 90 scores. Then right click on the cell format cells, cell format, digital, custom, type of input box input [[red blue][=60];][60] (all half English state characters, not including Chinese double quotes). 4, quickly enter the product number. As a kind of product model for ABC-1245, the product model have fixed the prefix ABC-, a large number of input, you can set the cell from the fixed input prefix. Then right click on the cell format cells, cell format, digital, custom, input type input box: ABC- # (all half-width character, not including Chinese double quotes). 5, select a worksheet adjacent or non adjacent. The sheet tab press the Shift button with the mouse select the other worksheet label can be in the adjacent table to select; press the Ctrl button with the mouse select other work table can be selected is not adjacent to the table. 6, quickly remove the cell line. Selected to be screened, the mouse click data and screening and automatic screening. Select the non blank in the drop-down in the head of the sword. You can. 7, the rapid expansion of narrow working area ratio. Hold down the CTRL, and scroll the middle mouse button, can enlarge or shrink the work area showed that the proportion of excel. 8, direct input size. The default font size toolbar maximum is 72 (pounds), is not subject to this restriction, can directly