Excel使用的50个小技巧（国外英文资料）.docVIP

Excel使用的50个小技巧 Excel uses 50 tips in 2007, 02, 27, and 12:35Excel using 50 tips Illustration: (1)... For number 1, and so on; A:... For method 1, and so on; Instructions, functions, introductions, or others; Notes for use. The connection between the steps of friends Cascading menu 50 tips for using Excel: (1) open quickly A: set xlstart directory shortcut: right-click the C:\My document under the .Xls file document onto the Program File\Microsoft office\xlstart directory is on the shortcut menu, select create shortcuts in the current position, create a shortcut to the destination file, you can. (2) adjust the startup directory Explanation: after setting up, every workbook in the xlStart directory and the alternate startup directory opens at the same time as excel is opened. A C:\My document\My: a excel folder, the book storing commonly used tools to the folder friends start excel tools / options / conventional input in the alternate startup directory in the workbook directory friends can be determined (3) set the number of recently used documents A: Tools / options / modify the conventional friends the most recently used file number. (4) increase the number of Excel undo Explanation: the number of defaults in excel is 16 times, but its often not enough at work. A: change the registry: open the registry editor to friends HKEY_CURRENT_USER/Software/Microsoft/office/9.0/excel/option= change or create the Undo History project Dword (decimal state changes) friends can complete set. B: to download and install automatically modify the registry plug-in, completed after 160 times. (5) set auto save A: check tools / save automatically. B: add: tools / add friends select auto save, add friends, and then run the tools to determine / auto save friends set the time interval, select the save , you can enter. note: after setting up, prompt information will appear when each system is saved. If you dont check the tools / auto save / save prompt, you can hide it (6) open or close mu