EXCEL经典用法全集（EXCEL classic usage complete set）.docVIP

EXCEL经典用法全集（EXCEL classic usage complete set） Journal Go to my space to share with friends, copy URL, log address: Please copy it with Ctrl+C and paste it to your friend. Hide the signature file, one of the small fonts, and the next one back to the log list [EXCEL]!!! Reprinted from slightly sweet boiled water, reprinted in 2010, 04, 01:19 read (3) review (0) 20 Category: personal diary Report EXCEL classic usage!!! 01, how to add a fixed character in a batch of cells already? For example: in the unit personnel data input in Excel, due to the higher level in the title certificate of the original number plus two, that is to be in everyones certificate number before adding two digit number 13, if a change it is too much trouble, so we can use this way, time and effort: 1) assume that the certificate number is in the A column, right-click on the A column, and insert a column for the B column; 2) write in B2 cell: = 13 A2, then carriage return; 3) did you see the result as 13xxxxxxxxxxxxx? The mouse is placed in the B2 position. Isnt there a small square below the cell? Drag it to the end with the left mouse button. When you release the left mouse button, its all changed. If the certificate is behind the original plus 13 in cell B2 =A2 write: 13. 02, how to set the file drop-down window at the bottom of the number of recently running file names? Open the tools, select options, select routine, change the number of files under the recently used file list file number input box can be. If the nearest filename is not shown in the menu, remove the check box before the list of recently used files. 03, in EXCEL input such as 1-1, 1-2 and so on the format, it becomes January 1st, January 2nd and other date form, how to do? This is because the automatic recognition of EXCEL caused by the date format, you can click on the main menu format menu, select cell, then digital menu label the cell format into a text format. 04, how do you make it automatically timed to save files in EXC