EXCEL使用技巧大全(绝对值得收藏)（国外英文资料）.doc

EXCEL使用技巧大全(绝对值得收藏)（国外英文资料） In unit personnel information, for example: after input in excel, due to the higher requirement in the original title certificate number plus two entirely, namely before everyone certificate number added double-digit 13, if a a change really is too much trouble, so we can use the following method, save time and effort: 1) assume that the certificate is in column A, right after A column, right-click, insert A column, column B; 2) in the B2 cell write: = 13 a2 and return. 3) did you see the result? The mouse is placed in the B2 position, and the bottom of the cell is not a small square, dragging down the left mouse button until the end. When you let go of the left mouse button, its all done. If you add 13 after the original certificate number, write in the B2 cell: = A2 13 and return the car. How do you set up the nearest running file name of the file drop-down window? Open tool and select options, then choose normal, under the recently used file list file number in the input box to change the file number. If you do not display the recently used file name in the menu, remove the checkbox before the recently used file list. What happens when you enter a format such as 1-1, 1-2 in EXCEL, and then it becomes January 1, January 2, etc.? This is due to the automatic identification of EXCEL to date format, you just click on the main menu of the format menu, choose cell, and under the number menu labelling set the cell format into a text format. How do you save the files automatically in EXCEL like WORD? Click on the tools menu to auto-save items and set the time for automatically saving folders. If there is no automatic save menu item under the tool menu, then load the macro... under the tool menu. Choose autosave and be sure. Then you set it up. When you do a multitable in Excel, you do the same thing as a table in Word, the first line (or a few lines) of each page. But not with a header? In EXCEL file menu - page Settings - worksheet - print t