{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
12 kinds of methods for excel operational efficiency
Finishing by: Date:2009-08-10 15:54:17 Popularity: Tags:

Excel is us commonly used spreadsheet software. How to use Excel more efficiently? For the next, introduce few Excel quickly skills for you to use.

1, Quick get help

for the toolbar or the screen area, you only need to press the key combination Shift + F1, and then use the mouse to click the toolbar buttons or the screen area, it will pop up a help window, the above elements will tell the detailed help .

2, Quick Start Excel

If you want to work regular day-to-day use of Excel, be able to start when Windows start it, set the method:

(1) start the "My Computer" to enter the Windows directory, in accordance with the path "Start MenuPrograms start" to open the "Startup" folder.

(2) Open the folder where the Excel in, Excel icon with the mouse to drag the "Startup" folder, then Excel on the shortcut to be copied to the "Startup" folder, next time the Excel can Quick Start when you start Windows .

if Windows has been activated, you can use the following method of quick-start Excel.

methods I: Double-click "Start" menu in the "Document" command in any of your Excel workbook.

methods II: with the mouse from the "My Computer" will drag the Excel application on your desktop, and then from the shortcut menu, select "create shortcut location in the current approach" to create a shortcut to it, start at only two-can hit the shortcut.

3, workbook Quick Find

You can use the worksheet in the search for any text, the method:

(1) toolbar click "Open" button in the "Open" dialog box, the input file's full name or partial name, you can use wildcards in place of;

(2) in the "Text Properties" edit box, enter the text you want to search, it is best do you think is the only word or phrase to search more successful;

(3) Select "Start Search" button. Found the document to meet the conditions, "Open" dialog box will show the status bar "0 files found" message, you should be patient, only when the "Open" button from the ash into a usable state when the only show that the search ended.

4, fast-moving or copying a cell

first selected cell, and then move the mouse pointer to the cell border, the press the left mouse button and drag to the new location, and then release the button mobile. To copy the cell, then release the mouse before you can press Ctrl.

5, fast print worksheet

if you choose "File" menu "Print" command to print, there will be the "Print" dialog box lets you choose, the procedure cumbersome. To skip the dialog box, you can click the "common" on the toolbar the "Print" button or press the Shift key and click the "Print Preview" button, Excel will use the "selected sheet" option to print .

there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1