Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
6, fast-switching worksheet press Ctrl + PageUp key combination to activate the work of the previous table, press Ctrl + PageDown keys can be activated after the combination of a working table. You can also use the mouse to control the worksheet tab at the bottom scroll button to quickly move the table's name, and then click to switch sheet. 7, fast-switching workbook switch for less workbook, click where the window workbook. Multiple windows to work under a number of switches, using a "window" the most convenient menu. "Window" menu at the bottom of the list has been opened in the name of the workbook, it is necessary to switch directly to a workbook, from the "window" menu to choose its name. "window" menu lists up to nine workbook, if more than 9, a "window" menu includes a "multi-window" command, choose the order, then there is a list in alphabetical order All of the workbook name to open the dialog box, simply click the name of which you need. 8, fast data link online You can use the following methods to quickly create the workbook and on-line data link: (1) open Internet, the need to link data with the workbook, and selected data in the workbook, and then click the "Edit" menu "Copy" command; (2) the need to create a link to open the Excel workbook, the data need to show the links area, click the upper left corner of the cell; (3) Click "Edit" menu's "Paste Special" command in the "Paste Special" dialog box, select "Paste Link" button. If you want to create a link in the Internet do not open workbook, click the Agency need to link the cell, and then type (=) and the URL address and the location of the workbook, such as: = http://www.Js.com/ [ filel.xls].
9, insert a Word table fast Word can handleExcel table data, you can use the following methods to insert Word tables quickly: (1) open the Word document where the table; (2) open a Word form to deal with Excel files, and adjust the location of the two windows in order to see the forms and tables to insert the region; (3) select the Word in the form; (4) Hold down the left mouse button to drag the Excel spreadsheet window, release the left mouse button on the forms required location. 10, to quickly create the toolbar through the toolbar you can quickly access commonly used commands or custom macros, you can quickly create their own toolbar. Method: Click the "Tools" menu in the "custom" command, select "Toolbars" tab, click "New" button, enter "new toolbar" name, and then click "OK." At this time the new toolbar appears in the window, you can use the mouse to the toolbar in other onto the new toolbar button, the button will be in this "settled." If according to the Ctrl key when dragging, it would be a button to copy them. Note: You can not drag the button "Customize" dialog box or table, otherwise the button will be deleted. 11, to quickly create workbook used as a template is a workbook to create a framework for other forms, it can quickly create a similar workbook. Methods to create a template: (1) to open a workbook as a template; (2) Choose "File" menu "Save As" command, open the "Save As" dialog box; (3) in the "File Name" box, enter the template name, from the "Save as type" list choose "Template (*. xlt)" option, then "Save location" will automatically switch to the default template Templates folder folder; (4) in the "Save Location" select "spreadsheet templates" folder, click the "Save" option. In this way, you can quickly create the template of the new workbook. 12, quickly jump to other documents use hyperlinks to jump between the various locations is very convenient if you want to switch to other documents, just use the mouse to point to a blue underlined hyperlink document, and then click the mouse to jump to hyperlinks by pointing up the sub-location, after reading to return, simply click the "Web" toolbar "Back" button. |
