12 techniques greatly enhance the operating efficiency excel - China LED Industrial Lights

1 Quick Start Excel If you work every day to always use Excel,

Can start Windows, start it, set the method:

(1) Start the "My Computer" into Windows directory, in accordance with the path "StartMenu Programs Startup" to open the "Start" Folder .

(2) Open the Excel where File Folder, use Mouse The Excel icon onto the "startup" folder, then Excel shortcuts were copied to the "Startup" folder, next time you start Windows can be a fast start Excel.

If Windows has been activated, you can use the following methods to quick start Excel.

Method 1: Double-click "start" menu in the "Document" command in any of the Excel workbook you can.

Method 2: Use the mouse from the "My Computer" will drag the Excel application on your desktop, then from the shortcut menu, select "Create Shortcut in the current location" to create its shortcut, start can simply double-click its shortcut.

2, rapid get help For the toolbar 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 border, press the left mouse button and drag to the new location, then release the button you can move. To copy a cell, then release the mouse before you can press Ctrl.

4, workbook Quick Find You can use the worksheet in any text search methods are:

(1) Click the toolbar "open" button, in the "Open" dialog, enter the file's full name or partial name, you can substitute wildcard characters;

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

(3) Select "Find" button. Satisfy the condition of the file is found before the "Open" dialog box Status Bar will show "0 files found" message, you should be patient, only when the "Open" button available from the ash into a state of the state only when that search ended.

5, fast print the worksheet If you select "File" menu, "Print" command to print, there will be "Print" dialog box allows you to choose, cumbersome procedures. To skip the dialog box, you can click the "common" toolbar "Print" button or press the Shift key and click the "Print Preview" button on, Excel will use the "selected sheet" option to print .

6, fast switching worksheets

Press Ctrl + PageUp key combination to activate the previous sheet, press Ctrl + PageDown key combination can be activated by a sheet. You can also use the mouse to control the worksheet tab at the bottom of the scroll button to quickly move the table name, then click the worksheet to switch.

I am an expert from ledindustriallights.com, while we provides the quality product, such as China LED Industrial Lights , RGB Led Lighting, LED Industrial Lights,and more.

Related Articles - China LED Industrial Lights, RGB Led Lighting,

Email this Article to a Friend! Receive Articles like this one direct to your email box! Subscribe for free today!