1, How to quickly select a specific area?

Use F5 key to quickly select a specific area. For example, to select A2: A1000, the most simple way is to press F5 key, the “location” window, in the “reference” column enter the region need to select A2: A1000.

2, How to quickly return to check the region?

By Ctr + BacksPae (that is, backspace).

3, how to quickly navigate to the cell?

Method one: Press F5 key, the “location” dialog box, enter the reference column cells Skip To address, a single city “OK” button.

Method 2: Click the left column to edit the cell address box, enter the cell address.

4, “Ctrl + *” special function

In general, when dealing with a work table there are many forms of data through the selected cell of a table, and then press Ctrl + * key to select the entire table. Ctfl + * the selected region is determined: Based on the selected cell to the surrounding radiation data involved in the largest regional cell.

5. How to quickly select all worksheet cells that contain formulas?

Sometimes, the need for a worksheet that contains the formula for all the units in order to protect, or fill in with other cells of different colors to remind users to not have this color in the region of the input data.

6, how quickly different cells enter the same number of content?

Selected range, enter the value, and then press Ctrl + Ener key, can be realized in selected range in a one-time importation of the same value.

7, only remember the name of function, but do not remember the parameters of the function, how should I do?

If you know the function name to be used, but do not remember all the parameters of its format, then can use a keyboard shortcut to paste the parameters to edit the column.

The specific method is: In the editorial column then enter a function name later to equate, and then press Ctr + A button, Excel will automatically enter the “Function Guide – Step 2 of 2.” When using the easy-to-remember name and has a very long string of parameters of function, this method seems particularly useful.

8, how to select one or more cell drag and drop to a new location?

Hold down the Shift key can quickly modify the contents of the order of the cell.

The specific method is: the selected cell, press the Shift key, move the mouse pointer to the edge of the cell, until the emergence of drag-and-drop the arrow pointer (hollow arrow), and then press and hold the left mouse button to drag and drop. Drag the mouse up and down at the border between the cells will become a standard of “workers”-like logo, will be dragging around a vertical “workers”-shaped logo, release the mouse button to complete the operation, the selected one or more cells by drag and drop on to a new location.

9, how to make working space on the screen larger?

Can be used to hide the toolbar, you can maximize the Excel window, or in the “View” menu, select “full screen” command.

10, how to use pop-up menu?

Pop-up menu, including a number of operations in the most commonly used commands, using them can greatly improve the operational efficiency. Select a region first, and then click the right mouse Kin can pop-out menu, in accordance with the need to choose a different order of operations.