15 Excel Tips

　　1. Save files in Excel automatically and regularly

Click the "Auto Save" item on the "Tools" menu to set the time between automatically saving folders. If you do not have the AutoSave menu item under the Tools menu, execute the Add-ins option on the Tools menu, and then select Auto Save and OK. Then you can set it up.

　　2. Enter the decimal point in Excel

In the decimal point of the time we may meet can not hit the decimal point, how to play are "comma" situation. At this point you need to open the Windows Control Panel, in regional settings, locate the Regional Settings Properties dialog panel, regional Settings Select Chinese (China), and in the Regional Settings Properties dialog panel, in the number attribute, change the decimal point to "." and OK.

　　3. Change the format of 1-1, 1-2 into the form of date January 1, January 2

Click the main Menu "format" menu, select "Cell", and then under the "Number" menu label the format of the cell text format is OK.

　　4. Set the number of recently opened filenames

Open tools, select Options, select General, and change the number of files in the number of files boxes below the recently used file list. If you do not display the most recently used file name in the menu, remove the check box before the recently used file list.

　　5. Set headers and footers for multiple worksheets at a time

Move the mouse over the name of the worksheet, and then right-click and select the menu item "Select All Sheets", where the header and footer will all work for all worksheets.

　　6. Replace cell address with Chinese character name

Select the range of cells you want to name, and then choose Insert Name, definition, and the name of the key in the current Workbook Name dialog box. or select a range of cells and enter the name directly in the Name box. Formulas that use names are simpler than formulas that use cell address references.

　　7. Quickly enter a discontinuous cell address in a formula

Hold down the CTRL key to select the area. When selected, select Insert, first name, define, name the area, and then use the area's domain name in the formula.

　　8. Secure the workbook

Open the workbook, select the Save As command on the File menu, choose Options, enter the "Open file password" or "Modify file D order" according to the user's needs, and make sure. Of course, you can also protect some of the important cells in your worksheet. Select the range of cells you want to protect, select cells on the Format menu, choose Protect, choose Lock from the dialog box, and then exit. Then select Protect Sheet on the Tools menu, and then exit as prompted.

　　9. Make the color and shading in the cell not print

Select File Page Setup sheet, and in the Print column, select the cell monochrome printing option. After that, the printed form becomes the same.

　　10. Define local names?

By default, all the names in the workbook are global. Changing the name to "sheet" can be effective for a worksheet.

　　11. Named constants

Some constants we use when we type, and input is more trouble, such as interest rate 4.4%. At this time we can choose "Insert" "name" "Definition", in the "name of the current Workbook" box, enter "interest rate" in the "Reference location" box, enter "= 0.04.4", OK.

　　12. Using an array formula

You must first select the range of cells you want to use to hold the results, enter the formulas in the formula bar, and then press Ctrl+shift+enter to lock the array formula, and Excel will automatically add parentheses "{}" to both sides of the formula. Don't type curly braces yourself, otherwise, Excel thinks you entered a body tag. To edit or clear an array formula. To select an array range and activate the formula bar, the parentheses on either side of the equation disappear, then edit or clear the formula, and then press the Ctrl+shift+enter key.

　　13. Batch modification Data

Sometimes a set of data needs to increase or decrease the same amount at the same time, and you can use the "Paste Selective" feature. For example, now you need to add 100, you can enter 100 in a blank cell first, when selected, select Edit Copy, select the column you want to modify, select Edit Paste Paste, select the add operation in the Operations column of the Paste Selective dialog box, and then press OK.

　　14. Quickly delete specific data

Sometimes you need to delete some specific data, such as a row with a number of 0. We can do this. First select the range (including the header row), and then select Quantity, Filter, AutoFilter. Select 0 in the Quantity column Drop-down list, and all rows with 0 are listed. When all rows are selected, select Edit Delete Row, and then press confirm, and then cancel the AutoFilter.

　　15. Split or cancel splitter window

On the main menu, click Window Split window. The Window splitter window command when the splitter window is canceled. Alternatively, you can place the mouse pointer over a horizontal split or vertical split line or a double split point, and then double-click to cancel the split window.