6 Office tips to make office more efficient

The information society pays attention to is the work efficiency, wants unceasingly enhances the work efficiency, besides grasps the daily Office software Office 2003 The correct use, skillfully uses its each skill is also the key.

1, make Excel exact

When you use Excel for financial calculations, a careful friend may find that its calculated results are sometimes slightly different from those calculated with an electronic calculator, especially if you are doing multiple division operations and leaving more than one number. 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 Skills

Sometimes when you have multiple pictures, AutoShapes, and WordArt in a Word document that you want them to move in an existing space, you can select them by holding down the SHIFT key and then using the left mouse button, and then using the cursor key or CTRL + CURSOR keys to move.

3, graphics and text mixing skills

If you paste a graphic into a Word document, the graphic hides the text and cannot move it with the cursor key. Then just use the left mouse button to select it and then right-click, select the Format AutoShape menu item, Point Layout tab, check "below the text" to make the picture in the document area to move any and will not obscure the text.

4, to the column document row number

If you want to insert a page number by column in a Word document that is already in a column, in addition to inserting a separator and then setting the page number method, you can also use the combination of AutoShapes and WordArt to achieve: First select an AutoShape, such as a rhombus or circle, to 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 the "personality" of Office2003

Microsoft in order to improve the efficiency of users, the usual use of the lower frequency of the menu commands are hidden, to use these commands must first click on the menu that the downward arrow, such a menu called the "Personalized" menu. This feature has both advantages and disadvantages, and sometimes reduces productivity. The 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" option, and to remove the Office2003 personality by clearing the "menu first show recently used commands."

6. Micro-shift Technique

When you use the cursor key to move a picture, AutoShape, or WordArt in a Word document, 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.