excel的一些技巧（Some of Excels tricks）.docVIP

excel的一些技巧（Some of Excels tricks） The first chapter operates Excel 20071 1 personalized start 1 skills skills 2 automatically open the specified file 3 processing skills 3 start error problem 5 skill 4 use Microsoft Office button 6 skill 5 customize the Quick Access Toolbar 7 skills 6 using 8 functional areas use shortcut keys 9 skills 7 The second chapter operation workbook 10 8 fixed common document 10 skills skills 9 based on creating a workbook template 11 skill 10 quick open workbook 13 skill 11 custom template 13 12 techniques to modify the default workbook 14 skill 13 personalized Excel work area 16 Excel 2003 and Excel 14 skills to solve the problem of 2007 compatible 19 skills 15 custom Excel 2007 format function 21 skill 16 add protection function 23 skills 17 converted to SYLK 25 skills 18 using a symbolic link file open and repair workbook 25 skill 19 large files using third party software repair workbook 26 28 coping skills 20 rather baffling The third chapter operation worksheet 29 21 tips to change the sheet tab color change label font size 29 skill 22 31 skills 23 change of the selected cell background color 32 skill 24 row or column 33 freezing technique 25 filling the blank cells 34 skill 26 switch table 35 27 36 data protection skills skills 28 protection work table 37 skills 29 change the default sheet number 38 skill 30 table 39 shows a number of techniques to hide and display work table 31 39 32 41 33 skills skills change the width of a column hidden rows or columns of table 42. 34 ranks 43 transpose skills 35 form Excel into picture 44 36 skills for the worksheet rename 45 skill 37 hidden sheet in a grid of 46 skills 38 worksheet password forget how to do the 46 skills in Excel 39 nested table 46. The fourth chapter, operation cell 48 40 skills selection of continuous 48 cell 41 cell 49 discontinuous selection skills skills 42 quick selection of non blank cells 50 skills 43 quick selection worksheet or the beginning of the last 51 skills 44 cu