12 tips for improving Excel's operational efficiency

Source: Internet
Author: User

First, quickly start Excel

If you want to use Excel frequently in your daily work, you can launch it when you start Windows and set the method:

(a) Start "My Computer" into the Windows directory, follow the path "Start Menu Programs" To open the Startup folder.

(ii) Open the folder where Excel is located, drag the Excel icon to the Startup folder with the mouse, and the shortcut to Excel is copied to the Startup folder, and the next time you start Windows, you can quickly start Excel.

If Windows is started, you can quickly start Excel in the following ways.

Method: Double-click the any Excel workbook in the document command on the Start menu.

Method Two: Use the mouse to drag an Excel application from my computer to the desktop, then choose Create Shortcut from the shortcut menu to create a shortcut to it, just double-click its shortcut at startup.

Second, get help quickly

For a toolbar or screen area, you just press the key combination shift+f1, and then click the toolbar button or screen area with the mouse, and it pops up a help window that tells the element's detailed help.

Move or copy cells quickly

Select the cell, then move the mouse pointer over the cell border, press the left mouse button and drag to the new location, and then release the key to move. To copy a cell, press CTRL before releasing the mouse.

Four, quickly find a workbook

You can use any text in the worksheet to search by:

(a) Click the "Open" button in the toolbar, in the Open dialog box, enter the full name of the file or part of the name, you can use wildcard characters instead;

(b) In the Text Properties edit box, enter the text you want to search for, preferably the word or phrase you think is unique, so that the search is easier to succeed;

(iii) Select "Start Find". Before you find a file that satisfies the criteria, the status bar for the Open dialog box displays the "0 files found" message, and you should be patient, indicating that the search has ended only when the Open button becomes available from the grayed out state.

V. Quick Print Worksheets

If you choose the Print command on the File menu to print, the Print dialog box appears to allow you to choose a program that is cumbersome. To skip this dialog box, you can click the Print button on the Standard toolbar or press the SHIFT key and click the Print Preview button, and Excel will print with the selected sheet option.

Six, quickly switch worksheets

Press the Ctrl+pageup key to activate the previous worksheet and press Ctrl+pagedown to activate the latter worksheet. You can also use the mouse to control the label scrolling buttons at the bottom of the worksheet to quickly move the name of the worksheet, and then click the worksheet to toggle.

Seven, fast switch workbooks

For fewer workbook switches, click the Workbook's window. To switch multiple jobs under multiple windows, it is most convenient to use the Window menu. The bottom of the Window menu lists the names of the workbooks that you have open, to switch directly to a workbook, and choose its name from the Window menu.

The Window menu can list up to 9 workbooks. If there are more than 9, and the Window menu contains a command called multiple windows, a dialog box that lists all the open workbook names in alphabetical order is available, just click the name you want.

Eight, quickly insert word form

Excel can work with the data that is listed in the Word table, and you use the following methods to quickly insert a Word table:

(a) Open the file in which the Word form resides;

(b) Open the Excel file that you want to process the Word table and adjust the position of the two window so that you can see the table and the area where you want to insert the table;

(iii) Select the forms in Word;

(four) hold down the left mouse button, drag the table to the Excel window, release the left mouse button to place the table where you want.

Ix. Fast Link online data

You can quickly establish a link to data in a Web workbook in the following ways:

(a) Open the workbook that contains the data you want to link to on the Internet, and select the data in the workbook, and then click Copy on the Edit menu;

(b) Open the Excel workbook where you want to create the link, and in the area where you want to display the linked data, click the upper-left cell;

(iii) On the Edit menu, click Paste Paste, and in the Paste a button dialog box, select the Stick link. If you want to create a link without opening the Internet workbook, click the cell where you want the link, and then type (=) and the URL address and the location of the workbook.

Ten, quickly create a toolbar

Toolbars enable you to quickly access commonly used commands or custom macros, and you can create your own toolbars as needed. Click Customize on the Tools menu, select the Toolbars tab, click the New button, enter the name of the new toolbar, and then click OK. When the new toolbar appears in the window, you can use the mouse to drag buttons from the other toolbars to the new toolbar, which will be "settled" here. If you press the CTRL key while dragging, the button will be copied over. Note: You cannot drag a button to the Customize dialog box or to a worksheet, otherwise the button will be deleted.

Xi. creating a workbook quickly

A template is a framework for creating other workbooks that you can use to quickly create similar workbooks. The template method is created by:

(a) Open a workbook to be used as a template;

(b) Select the Save As command on the File menu to open the Save As dialog box;

(c) Enter the name of the template in the File name box, select the template (*.xlt) option from the Save as type list, and the save location will automatically switch to the default Template folder Templates folder;

(d) in the Save in location, select the Spreadsheet Templates folder and click Save. That way, you can quickly create a new workbook from that template.

12, quick jump to other documents

It's convenient to jump between locations with hyperlinks, if you want to switch to another file, just point to the underlined blue hyperlink file with the mouse, and then click the mouse to jump to the point where the hyperlink points to the child, after reading to return, just click the Web toolbar on the "Back" button.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.