办公技巧(国外英文资料).docVIP

办公技巧 1, how to add a fixed character in a batch of cells already? For example: in the personnel data input unit, 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. 2, 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 file number under the recently used file list file number input box. If the nearest filename is not shown in the menu, remove the check box before the list of recently used files. 3, 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 under the label of the cell format into text format on the line. 4, how do you make it automatically timed to save files in EXCEL like WORD? Click the tools menu, save them automatically, and set the time interval for the automatic save folder. If there is no auto save menu item under the tools menu, then under the tools menu, add macro..., select save automatically, and OK. Then you can set it up. 5, when you use Excel to do multiple page tables, how do you make a title like the Word table, that is, the first line (or line) of