Excel2010 Office software processing skills Daquan

1. A better way to quickly locate "super long" row data

Enter A8937 in the Excel current worksheet name box and press ENTER. The name box is at the left end of the formula bar and is the left neighbor of the equation box.

2, Excel in the implementation of the cell across the table drag

In the same excel2003/2007 worksheet, dragging the border of a cell or range of cells enables you to move the selected area, but it cannot be implemented across worksheets, and you can actually hold down the ALT key and drag the cell or range of cells you want to move to the label on the destination sheet. Excel will automatically activate the worksheet so that you can place the cell or range of cells you want to move to the appropriate location on the target worksheet.

3, set the Excel table shadow spacing effect

If you have more records in the excel2003/2007 table, setting a table's shadow spacing effect not only helps to beautify the table, but also makes it easy to see the information in the table. The method is set up by selecting the range of data in the table, click Conditional Formatting on the Format menu to select the formula input formula =mod (row () _1.10) =0 in the list of criteria 1: If the table has only 1 row headings, start with the 2nd row of the table. The shadow spacing effect is set at 10 lines per interval and can be changed according to your needs. You can then specify the color of the shadow fill that satisfies the Criteria row, click the Format button in the dialog box, select a fill color on the Pattern tab, and then you can see the effect of the shadow spacing setting.

4, "Automatic" decimal point, fast record data

When we enter data with both numbers and characters in an Excel worksheet, to continuously switch between Chinese and English input mode, this not only reduces the input efficiency and will also appear forget to switch and mistakenly put the decimal point into a period, in fact, we can set tool options to enable the number of cells to automatically add a decimal point, The steps are as follows: Step one: Click the tools → Options command in the menu bar to open the Options Properties dialog box.

Step Two: Click the Edit tab and tick the "Automatically set decimal point" check box, and then enter decimal places in the Number box "You can determine the number of decimal places to keep, typically 2 bits, and then click OK." After the setting, and now in the cell input value "such as 123", we press ENTER, it will automatically become "1.23", the decimal point is automatically added up.

Tip: The Automatically set decimal point option is only valid for numbers entered after the setting is made, and the number entered before setting is not affected. To temporarily cancel the Automatically set decimal point option, type a decimal point as you enter a number.

5, excel2003/2007 discontinuous cell quickly enter the same content

When you enter information in Excel software, a contiguous cell can quickly enter the same or regular data by dragging the fill handle. If the cell is not contiguous, the padding method will not work. However, we can quickly enter the same information in the following ways. First, hold down the Ctrl key while clicking the left mouse button to select all of the cells that are not contiguous in the same input, and then click the keyboard to enter the contents of the cell, and then press CTRL + Enter, and all the selected cells will be filled with the contents of the keyboard input.

6, Excel2007 in the simple setting of horizontal input

A simple set of Excel2007 will allow you to press the ENTER key and the cursor will automatically jump to the adjacent cell. In Excel, click tools → options → advanced, select "Press ENTER" to move the selection, and in the small right, you can choose up/down/ Left or right, click OK to jump the cell in the way you used to.

7, excel2003/2007 without tools directly to the Excel table screenshot

Sometimes we need to use screenshots to intercept one of the tables in Excel and then insert them into other documents. In fact, without the screenshot tool can be directly intercepted Excel table. First select the range of Excel cells that you want to capture. Then hold down the SHIFT key while you open the Edit menu in the toolbar, where the original copy command in the Drop-down option has been turned into a command to copy pictures, select to copy the selected Excel area as a picture, and then use the Paste command to complete the screenshot entry.

8, Excel rapid production banner characters

At present, the banner used for publicity is mainly through to the printing shop to print, with projection equipment projection strokes and their own hand lettering three ways to make. How to let the common printer around us, the banner in big print? The use of Excel to combine the way to quickly produce a very professional banner characters.

Open Excel2003, click "file → print preview" in the menu, or click the "Print Preview" button in the toolbar directly, at the same time the window display ratio of 25%, with the mouse randomly selected 4 pages, click the "file → print area → set print Area" menu commands, and then click the Toolbar " Print Preview button, the selected area automatically generates pages 1th through 4th in order and defaults to A4 paper format.

When the selected range setting is complete, insert a WordArt in Excel2003, like "hot", select a good font, move the WordArt to a blue line range, and set the font size to ensure that the height and width are set in the print area of the height and width range of the two A4 sheets, and adjust slightly.

When the above operation is completed, it is saved into a transverse plate, in the future, as long as the production of banners, call the template, by double-clicking the corresponding text, click the "Print" button will print out each part of the big characters, they will be able to spell good to get a complete Chinese characters, and then use a little solid glue to paste them in the cut lead paper, With a knife and ruler will be engraved in large characters, will be equal spacing of the word placed, with a pin on the banner, you can make a professional banner.

9, excel2003/2007 skillfully draw slash head

Sometimes we need to draw a table in the Excel table with a number of diagonal headers, and to ensure that the position of the table header is accurate and beautiful, the three commonly used methods are text boxes, superscript, in-line.

The first and 32 types can be entered directly in Excel, and the second way you can enter the text in Word and then copy it to Excel, superscript, subscript is done in the formula bar. The steps are as follows:

First in the cell text → in the formula bar to select the superscript or subscript words; right-click → set cell format → special effects, and then enlarge the cell size.

10. Excel fills data automatically

In Excel, for faster autofill, we can double-click the fill handle of the selected cell, fill the cell contents down a column, and fill the same number of rows as the adjacent columns. A simple example: if you type data in cell a1:a10, type a formula or text in a far-reaching lattice B1, press ENTER, and then double-click the fill handle, Excel populates the data along the column, from cell B1 to cell B10.

11, Excel Cell Find neighborhood

When you edit an Excel worksheet, when you press ENTER in the active cell, the adjacent cells below become the next active cell. However, at some particular moment, you want to press Enter and the adjacent cell to the right becomes the active cell. What should I do? Click Microsoft Office buttons and then click Excel Options. Click Advanced, under Edit, select the move selection after the Enter key check box, and then in the direction box, select the direction you want to be the active cell, such as right, and OK.

Now that you have finished editing a cell in an Excel worksheet, pressing the ENTER key moves the insertion point to the cell on the right. Perhaps you don't want to make changes to the default settings for Excel, just temporarily change the moving direction of the active cell, then try the following key settings: Shift +enter key → up. The tab key → to the right. shift+ the Tab key → to the left. The above can be used in Exce2007 as an example, different in other versions.

12, Excel lets the content press the screen to scroll

Excel lets the content scroll on the screen and is unaffected by the sroil look key opening and closing state.

The PAGE DOWN key------Scroll down one screen page up-------scroll up one screen

Alt +page down key------Scroll one screen to the right-----alt +page up key and scroll one screen to the left.