excel使用技巧（Excel usage skills）.doc

excel使用技巧（Excel usage skills） Excel tips 1. quickly select all sheets Right click the window below the sheet tab, in the pop-up menu, choose select all sheets command (). 2. quick start Excel If you want to start the system automatically Excel, can do this: 1. double click my computer icon into the Windows directory, open the Start Menu\Programs\ startup folder; 2. to open the Excel folder, use the mouse to drag the Excel icon to the startup folder, then the Excel shortcut will be copied to the startup folder, you can quickly start the next time you start Windows Excel. If the Windows system is started, you can use the following method: a method of quickly starting Excel: click start to document commands in the workbook can be either Excel. Method two: use the mouse from my computer, Excel applications onto the desktop, and then from the shortcut menu, select create shortcuts in the current position, after startup just double-click the shortcut. 3. quickly delete the selected area data If you use the right mouse button to the left (or reverse) drag the fill handle selected range of cells, not take it out of the selected area is the release of the right mouse button, it will delete the selected area in some or all of the data (i.e., in the process of cell area into a drag, grey fuzzy after the release of the right mouse button the contents will be deleted). 4. to rename the cell Excel for each cell has a default name, the naming rule is the column with D3 said fourth cells such as abscissa, columns and third rows. If you want to rename a cell, can use the following two methods: 1. as long as the use of a cell of mouse click, see its current name in the upper left corner of the table will use the mouse to select the name, you can enter a new name. 2. selected cells to be named, click Insert, name and definition command, display the define Name dialog box, enter a name in the name in the current workbook box, click OK button (). Note: the first character in the cell to