10 practical tips that are often overlooked in Excel2010 use

The most common skill in office skills is Excel. Here are some frequently overlooked Excel tips, do you see any use?

"End+ Arrow" for quick positioning to the top edge of the cell

As shown in Figure 1, if the current cell is in the C3 position, press the end key and then press the ↑ key, the current cell jumps to the top C1 cell, and if you press the ↓ key, it jumps to the C5 cell, and the ← key jumps to the left cell, pressing the → Key jumps to the right-hand cell. That is, no matter where the current cell is, pressing the END key and then pressing the arrow key will position the cell on the edge. If there is a blank cell in the middle, it will first be positioned to a blank cell. The effect is that if you have many rows or columns in your worksheet, you can quickly find empty cells or navigate to cells on the edge.

Figure 1

The row and column quick paste

As shown in Figure 2, pressing the CTRL key and selecting A1, E1, A5, e5 four cells, copy paste will find the copied content connected together. This allows for rapid replication without connecting cells. Of course, if there is a blank cell in the middle, it cannot be selected.

Figure 2

Fill content #与 Fill content @ Cell format type

When you need to enter a lot of the same content in the previous or later sections, you can set the cell type in cell format to fill content #或 # Fill content, where "fill content" is the contents of the same part that is automatically populated, and "#" is the part that is entered manually. Use "#" when entering numbers, and "@" when entering characters.

Chinese and English input auto switch

When you edit a table, you have to type in English in some cells, some cells to enter Chinese, and repeatedly switch input method is inconvenient, you can select the need to enter the Chinese cell range, the implementation of the "Data → validity" command, open the Data Validation dialog box, switch to the "Input mode" tab, press "mode" The Drop-down button on the right, select the open option and make sure to exit. The Chinese input method is automatically turned on when you are elected to enter a cell in Chinese, and the Chinese input method automatically closes when other cells are selected.

Merge text with hyphen "&"

If you want to combine the contents of multiple columns into a column without using a function, you can easily fix it with the hyphen "&". Enter the formula in the last cell you merged: = Cell 1 & cell 2, and you can merge after you enter.

Position in the same cell after pressing the "Ctrl+enter" key combination

Sometimes, in order to test a formula, you need to repeatedly enter multiple test values within a cell. However, once you enter a value and press ENTER to view the results, the active cell is moved to the next cell by default, and it is extremely inconvenient to select the original cell with the mouse or the UP arrow. If you press the "Ctrl+enter" key combination, the active cell is still the current cell.

Automatically open a workbook

Place shortcuts to the workbooks you want to automatically open in the C:Program FilesMicrosoft Officeoffice10xlstart folder, and Excel will automatically open the workbook each time you start.

Enter content in selected cells

If you want to switch to the next line when you have finished typing on one line, it's cumbersome to move around with the mouse and navigate to the cell you want to enter before you start typing. However, we can first select the area to enter, and then press the TAB key to switch, if you want to return to the original cell can use the Shift+tab key.

Print multiple worksheets quickly

When you print multiple worksheets without a single print, you can select the label of the worksheet you want to print, and then click the Print button on the toolbar.

Quickly convert rows and columns with the "transpose" feature that you paste selectively

Sometimes we need to convert the ranks of a table in Word, and then we can copy it and perform "selective pasting → transpose" in Excel to quickly convert, accurate and convenient.

Discarding PS Word 2007 can also be a master of drawing

It168.com

Author: Cold Lonely Month

PR's old Zhang and Xiao Wang are doing market research outside, received the mail from the company, the request will be collected as soon as the picture data collated, old Zhang made a worry, many pictures should involve "pull the map", but their own notebook computer and did not install Photoshop Ah, Xiao Wang gathered over a look, Don't you have Word 2007 on your computer? You can use it. "Word 2007 how to pull the graph method?" I wouldn't. "Xiao Wang is demonstrating on old Zhang's computer ...

First, insert the picture after pruning save

Run Word 2007 to create a new blank document, click the Insert menu on the toolbar, click the Picture from File button in the floating tools panel that appears, and then insert the picture into the document (Figure 1).

Figure 1 Word 2007 Insert Picture

Then click the Crop button in the upper-right corner, and a black wireframe appears around the picture, and a wireframe that drags the edges cuts the picture to just the rectangular area that is just enough to contain the outline of the object you want to buckle (Figure 2).

Figure 2 Word 2007 cropping an image

Click the Office icon button in the upper-left corner to save the document as a Web page, select the Save Type as Web page (*.htm;*.html), and save the saved path so that you can create a folder that is the same as the named file name. In this folder there will be a picture similar to image001, which is the picture after cropping, and then we need to use it.

Second, the use of "free curve" hook map

Back in Word2007, click the Insert option on the menu bar. In the show Options group of the floating tools panel that appears, locate shapes, and then click the Scribble icon and drag the mouse along the edge of the picture to outline the part of the image that is more complex to the edge (such as hair, clothing, etc. , you can remove some details for a while, but do not leave a blank space around the characters, the completion of the sketch automatically formed a closed curve.

Tip: In order to make the figure out more accurate, you can right-click the curve from the pop-up menu select "Edit Vertex", the curve will appear on a large number of vertices, by moving the vertex to make the curve and the contour edge of the figure to match more accurately.

You can also hold down the CTRL key while you edit the vertices and click on the existing vertices to remove some unnecessary vertices, and click to add a new vertex to the point where you need to add vertices, and carefully adjust to the curve just enough to surround all the contours (Figure 3).

Figure 3 Word 2007 apply a freeform curve

Third, fill the graphics and finish the drawing

Click on the background picture and press Del to delete the original picture. Just leave the outline curve, then click to select it on the Closed curve box, right-click to select Format AutoShape to open the Format AutoShape dialog box (Figure 4), and on the Color and Line tab, under the Fill tab page , click the drop-down arrow for the "Color" item, and select "Fill Effect" from the in the Fill effect box that appears, select Picture, click the Select Picture button, locate the picture you prepared for the first step as a fill picture, and then return to the Format Picture dialog box to set line color to wireless bar color. When you are sure to return to the slide, you can see the plucked picture. If you are not satisfied with the details, you can again right-click to select "Edit Vertex" to adjust the picture again until you are satisfied.

Figure 4 Word 2007 Fill effect

Tip: The above drawing process is actually using the "free curve" tool to check the characters of the picture, then use the same size of the picture to fill the outlined graphics, so the picture used for filling and drawing the closed curve figure must be the same size (which is why to cut first), Otherwise, it will result in the image and curve dislocation after filling and anastomosis is not good.

Common text typesetting techniques in Word and WPS

Whether you use Word or WPS typesetting documents will inevitably use text alignment, paragraph settings, this article summed up the word and WPS common text layout skills, I hope that the work of typesetting to help.

1. Cell number decimal point alignment

Select the number for which you want to process decimal alignment, select a cell, and then select the tab Stop command on the Format menu to open the tab Stop dialog box, if it is a row within a table, a list of numbers that need to be aligned. Under tab stop position, enter a tab stop value, select decimal point in Alignment, and leader to select None. Then click the "Settings" button, specify the tab stop, the unwanted tab stops can be removed by the "clear" or "Clear All" buttons, and then exit the dialog box. The decimal point that is entered in the cell is then automatically aligned.

2. Paragraph alignment

Generally we indent the first line of text in each paragraph with 2 characters, and the document is written without the paragraph formatting. After writing, select all the paragraphs and click the right mouse button to select the paragraph command, open the Paragraph Settings window, and apply the "first line indent" Under special formatting in the Indent and Spacing tab. Effect, set "measure" to "2" OK. If you want the text content to automatically fit on the width of the page, you can set alignment to distributed alignment under the General option.

3. Set the "column" distance skillfully

In the paragraph setting, we can use the spacing function to set the distance between lines of text, but there is no setting option for the column spacing. To set the spacing between columns, you can open the Page Setup dialog box under the Text menu. Then select Alignment grid in grid on the Document Network tab, and then set the number of characters per line in the character, such as "20", to increase the distance between the text and increase the column spacing in disguise.

Two techniques to speed up the data entry of WPS table

We may have done a lot of "hard work" typing data into the WPS form, but we didn't notice it. Input data, the general choice of horizontal input or vertical input. Horizontal input and vertical input can be used on the keyboard "tab" key and "Enter" key to switch to the next cell to continue typing.

Why do we do a lot of "hard work" when we enter data? When we entered the horizontal, F1 cell entry to switch to the A2 cell when the key will need to keystroke many times, with the mouse, the hand will leave the keyboard. Vertical entry also has such a problem.

To speed up entry, you need to reduce the number of mouse dependencies and invalid keystrokes. The methods described below can effectively reduce the number of keystrokes on the mouse when data is entered. Select the cells you want to enter data with the mouse, and the cells that appear as anti-white are the active cells

Then start to input data, the active cell record, if you choose to enter data across the keyboard to the "tab" key to switch to the next cell; If you choose to vertical input data, keep pressing the ENTER key on the keyboard to switch to the next cell. If you have a cell in the front of the error, you can press the "Shift+tab" key or the "Shift+enter" key on your keyboard to return and select the cell that entered the error.

Second, batch input the same data and formula

With the mouse to select the need to enter the same data or formula cells, in the formula bar input data or formulas, and then press the "Ctrl+enter" key on the keyboard can be. To enter the same formula as an example, select the bulk input formula cell, and then in the formula bar, type the corresponding formulas for the active cell, press the "Ctrl+enter" key on the keyboard.