Office Six tips: making office more efficient

Information society is about work efficiency, to continuously improve work efficiency, in addition to mastering the correct use of day-to-day office software office 2003, skilled use of its skills is also the key.

1, make Excel exact

When you use Excel for financial operations, a careful friend may find that the calculated results are sometimes slightly different from the results computed with the electronic calculator. Especially in the case of multiple division operations and leaving more than a few. The solution is also simple, the use of the Round function for each intermediate value rounding operation, the format is: Round (numeric, reserved decimal places), it is the role of the specified number is rounded, to retain the specified number of decimal places.

2, selection tips

Sometimes there are multiple pictures, AutoShapes, and WordArt in a Word document, and you want them to move in an existing space, you can hold down the SHIFT key and then click the left mouse button to select them. Then use the cursor key or CTRL + CURSOR keys to move.

3, graphic blending techniques

If you paste a graphic into a Word document and the graphic hides the text and can't move it with the cursor key, just select it with the left mouse button and right-click, and select the Format AutoShape menu item. The Point Layout tab, where you can move the picture in the document area without obscuring the text, by selecting "below the text."

4, arrange page numbers for column documents

If a Word document that already has columns wants to insert page numbers by column, in addition to inserting a separator and then setting the page number, You can also use the combination of AutoShapes and WordArt to achieve: First select an AutoShape, such as a rhombus or circle, draw it to the position of the page number, and then enter a WordArt page number, moved to the middle of the graphic. Repeat each column and change the page number so that you can make a personalized page number.

5, remove Office2003 "personality"

Microsoft in order to improve the efficiency of users, the usual use of low frequency menu commands are hidden, To use these commands, click the down arrow on the menu, which is called the personalized menu. This feature has both advantages and disadvantages, and sometimes reduces productivity. The settings option to cancel it is also hidden deep, not in the general settings of the tool options, nor in the view bar, to open the tools → customization → options, and clear the menu to display the most recently used commands first.option to get rid of OFFICE2003 's personality.

6, nudge tips

When you move a picture, AutoShape, or WordArt in a Word document with the cursor key, it is a character  . Mobile, unable to achieve precise typesetting, then if you use the mouse to select it with "CTRL + Cursor key" can make the object a pixel of the precise movement of pixels.

Mastering These techniques will help you in your office automation operations.