Excel spreadsheet is an all-powerful, it is powerful, easy to operate, in addition to quickly generate, format of various forms, but also can do a lot of data in the table function of the database. Introduce you to fast for the next few ways to use Excel skills.
1 Quick Start Excel. If your daily work, often used to Excel, you can start it when you start Windows, set the method: (1) Start the "My Computer" to enter the Windows directory, in accordance with the path "Start Menu \ Programs \ Start" to open the "boot" file Folder: (2) Open the folder where Excel, Excel icon with the mouse to drag the "Start" folder, then Excel shortcut to be copied to the "start" folder, you can quickly start the next time you start Windows Excel has.
If Windows is on, you can use the following methods to quick start Excel. Method One: Double-click the "Start" menu in the "Document" command in any of the Excel workbook can be. Method Two: Use the mouse from the "My Computer" will drag the Excel application on your desktop, and then from the shortcut menu, select "Create Shortcut in the current location" to create its shortcut, just double-click the Startup shortcut can be.
2, quick access to help. For the tool bar or the screen area, you just press the key combination Shift + F1, then right click the toolbar button or the screen area, it will pop up a help window, the above elements will tell the detailed help information.
3, fast move or copy cells. First selected cell, and then move the mouse pointer to the cell borders, press the left mouse button and drag to a new location, then release the button you can move. To copy a cell, then press Ctrl before you can release the mouse.
4, quickly find the workbook. You can use the worksheet in any text search methods: (1) Click on the toolbar "Open" button in the "Open" dialog box, enter the file's full name or partial name, you can use through wildcards; to (2) in the "Text Properties" 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 "Find" can be. Documents to meet the conditions found before the "Open" dialog box, the status bar will show "0 files found" message, you should be patient, only when the "Open" button from the ashes of the state become available only when show that the search ended.
5, fast printing sheet. If you select "File" menu, "Print" command to print, there will be "Print" dialog box allows you to choose from cumbersome procedures. To skip the dialog box, you can click the "common" tool bar on the "Print" button or press the Shift key and click the "Print Preview" button, Excel will use the "selected sheet" option to print .
6, faster switching worksheet. Press Ctrl + PageUp key combination to activate the previous worksheet, press Ctrl + PageDown key combination can be activated by a sheet. You can also use the mouse to control the sheet tab at the bottom scroll button to quickly move the worksheet name, then click the table switch.
7, quickly switch the workbook. Workbook for small change, click the workbook where the window. Multiple windows to work under the switch over, use the "Window" menu, the most convenient. "Window" menu at the bottom lists the name of the workbook open to switching to a workbook directly from the "Window" menu to choose its name. "Window" menu lists up to 9 workbook, if more than 9, the "window" menu contains a "multi-window" command, use the command, while there is an alphabetical list of all open workbook name dialog box, just click the name of one can be required.
8, quickly insert Word tables. Word Excel can handle the data listed in the table, you can quickly insert a Word table the following methods: (1) Open the Word document where the table; (2) Open the Excel table to handle Word documents, and adjust the position of the two windows, so as to form and to insert a table to see the area; (3) Select the Word in the form; (4) Hold down the left mouse button, drag the table to Excel window, release the left mouse button on the need to position the table can be.
9, quick links online data. You can use the following methods to quickly build and on-line data in the workbook links: (1) Open Internet on the need to link the data with the workbook, and selected data in the workbook, and then click the "Edit" menu "Copy" command ; (2) Open the need to create a linked Excel workbook, the data in the area need to show the link, click the upper-left cell; (3) Click "Edit" menu in the "Paste Special" command in the "Choice of Paste "dialog box, select" Paste Link "button. If you want to create links in the workbook is not open Internet, you can click the link at the needs of the cell, then type (=) and the URL address and the workbook location, such as: = http://www.Js.com/ [ filel.xls].
10, quickly create toolbar. The toolbar you can quickly access frequently used commands or custom macros, you can quickly create their own tools required field. Method: Click the "Tools" menu in the "custom" command, select "Toolbars" tab, click "New" button, type "New Toolbar" name, and then click "OK." Then the new toolbar appears in the window, you can use the mouse to drag the other new toolbar button in the toolbar, the button will be in this "settled." If pressing Ctrl key while dragging, then copied the button. Note: You can drag the button "Customize" dialog box or work table, otherwise the button will be deleted.
11, using a template to create the workbook. Template is a workbook used as a framework to create other forms, use it to quickly create a similar workbook. Create a template methods are: (1) Open a workbook to be used as a template; (2) Select "File" menu "Save As" command, open the "Save As" dialog box; (3) in the "File Name" Enter the name of the template from the "Save as type" list, select "Template (*. xlt)" option, then "Save" will automatically switch to the default Templates folder template folder; (4) " Save in "select" spreadsheet template "folder, click" Save "button. This way, you can quickly create the template of the new workbook.
12, with "super-connected" to quickly jump to other files. Use hyperlinks to jump between the various locations is very convenient, if you want to switch to another file, just use the mouse to point to the blue underlined hyperlinks to files, and then click a hyperlink to jump to the pointing up the sub-location, after reading To return, simply click on "Web" toolbar "back" button.
没有评论:
发表评论