technology center

Text box and quantity delicious

Word2002/2003 does not provide built-in text box, simply have to manually insert a rectangular text box, position and size can only be manually adjusted. ms office 2007 Word  provides many built-in text box, edit the copy in the rain quote and feed more convenient. For example, to illustrate a particular design and marketing demands, click the “Insert” tab in the “text box”, see Figure 1 menu offers many of the fine text box. Choose a feed to use the text box and insert it into the page inside the selected prompt, enter the text you can directly see the effect. In addition to changes inside the font, font size other than the location and size of text boxes generally do not change.

Tip: a small division of newspaper editorial pages in A3 put more articles inserted in the page at this time as long as a few text boxes, text box, stored for each article, you can make these articles on the page. “ peaceful coexistence “of the.

Horizontal vertical instantaneous change

Before the rain and the small division with the “vertical” text box, enter the text to the inside is very awkward. After a careful exploration of Word2007, rain found the text box “vertical” Text method: according to the method described above into a variety of text box, then double-click the text box to enter text open the “Text box tool” tab, click “Text ”area” text direction “button, the text of which can be vertical, and click again will become horizontal.

Good and fast built-in styles

Rain on the pursuit of perfection, the built-in text box the default style is not any copy are applicable. To make the text box and copy the perfect fusion, light rain to use the built-in styles to the text box to “add depth

Workers “: Double click the text box edges, open the” Text box tool “tab click the” text box style “area in the” other “, you can see in Figure 2 built-in text box style. mouse to point to a style you can see the page in the text box changes, click on it satisfied the formal application.

Outline style changes and more

Text box outline color, thickness and linear very attractive “eye”, according to the method described above in addition to the application other than built-in styles, light rain can be free to play according to their needs: double-click the Open text box outline “text box tool” tab . Click the “text box style” area “Shape Outline” drop-down button, point to the list in Figure 3 of a color, or to the “thickness” or “dotted line” under the value or linear, you can see the text box profile change, feeling satisfied with a single click application of effects of the current style.

Liang internal filling effect

To copy a more expressive, light rain where the company acquired a color laser printer, to the text box “color” has become an important task. Set within the previous Word2002/2003 fill more cumbersome, rework of the day. Now simply open rain Word2007 “Text box tool” tab, click the “Shape Fill” drop-down list button to open the Figure 4, point to “theme color” or “standard colors” text box color will occur immediatelychange. Open Figure 4 in the “gradient” or “texture” sub-menu, you can choose from the list and preview the selected effects. Need to use a picture or text box fill pattern, click the list in the “picture” or “pattern”, select it.

Any change shape and lively

Newspaper on the “motto reading” section, a small division to open the list in Figure 1, click the “Simple Text Box” insert page, double-click the text box to enter text outline, click the “Text box tool” tab “to change the shape of the ”drop-down button, select the most suitable shape, text box into a look, immediately cut. Rain also use the copy of the “marked” text box, point to specific content feeds and quoted.

The impact of three-dimensional effect is more

Rain will play familiar ordinary two-dimensional text box after he started using three-dimensional text box: insert a text box after the page is open “Text box tool” tab, click the “three-dimensional effect” pull-down by

Button to open the list, mouse, select the “parallel” or “Focus” under the effect of three-dimensional text box you can see the effects. In addition, click the “Text box tool” tab of the “three-dimensional effect” area “upturned”, “look down under” and other buttons, three-dimensional graphics can produce the effect of rotation on the page, three-dimensional text box unique!

Adjust the position more quickly

Arrange a small newspaper article a few “golden” position, for example, the upper left corner, upper right, and so on. microsoft office 2007 download Word can easily use these locations: Double-click the text box has been opened into the page “text box tool” tab, click “Location” button to open the drop-down list, select the appropriate location as needed, to the text box move to the area. In addition you can also use the “other layout options” command, open the “Advanced Layout” dialog box “Text Wrapping” tab, where you can select more of the “Text Wrapping” and “wrap” mode. Or click the “order” in the “Text Wrapping” button, open the list, select the “compact surround”, etc..

01, how existing cell volume by adding a fixed character?

For example: in the unit’s personnel information, enter in microsoft office 2010 excel, due to the higher level in the original certificate of title number two all together, that is in front of everyone and added double-digit certificate number 13, a change if a it is too much trouble, then we can use the following methods, save time and effort:

1) Assuming the certificate number in column A, column A and click the right mouse button, insert a column to column B;

2) in cell B2 write: = “13″ & A2 after the carriage return;

3) see the results for it? Mouse into the B2 position, not the bottom of the cell has a small square dots do, according to drag the left mouse button down until the end. When you release the mouse button when all changing for the better. If the original certificate number followed by 13 in cell B2 write: = A2 & “13″ after the carriage return.

02, how to set the file pull-down window at the bottom of the last run number of the file name?

Open the “Tools”, select “Options”, then select “General” in the “Recently used file list” entry box below the number of files you can change the number of files. If the menu displays the most recently used file name, the “Recently used file list” check box can be removed before.

03, in MICROSOFT OFFICE 2010 EXCEL input such as “1-1″, “1-2″ sort of format it will become the January 1, January 2, etc. The date format, how to do?

This is due to MICROSOFT OFFICE 2010 EXCEL automatically recognized as a date format caused, you just click the main menu “Format” menu, select “cell” and then in the “digital” menu tab to the cell format set to text on the line.

04, in MICROSOFT OFFICE 2010 EXCEL how to make it as an automatic timed save as Word files?

Click on “Tools” menu “Auto Save” item, set auto-save folder interval. If the “Tools” menu, there is no “auto save” menu item, then the implementation of the “Tools” menu under “Add-Ins …” choose the “Auto Save”, “OK.” Can then be set.

05, using Microsoft office 2010 excel to do multi-page form, how do like Word’s table a title that the first line of each page (or lines) is the same. But not done with the header?

In the MICROSOFT OFFICE 2010 EXCEL file menu – Page Setup – Sheet – print titles; can be top or left to set the title, the dialog box by pressing the button folded, you can use the mouse scoping. This Microsoft office 2010 excel will automatically add you to the page designated as part of the header.

06, in Microsoft office 2010 excel, how to set up a weighted average?

Weighted average in financial accounting and statistical work, often used, is not a very complex calculation, the key is to understand the total value of the weighted average of fact (such as the amount) divided by the total number of units derived from the average, while not simply the value of each unit (such as price) that the average unit value obtained.Formulas in Microsoft office 2010 excel can be set to solve (in fact, is a division formula), the denominator is the sum of all values, the number of molecules is the sum of all corresponding, its result is the weighted average of these values.

07, if an Microsoft office 2010 excel file contains multiple worksheets, how to set more than once the same worksheet headers and footers? How can one print multiple sheets?

Mouse over the name of the table at work , then right click, the pop-up menu, select” Select All Sheets “menu item, then you are all operating table for all the work, no matter what headers and footers, or print your worksheet.

08, MICROSOFT OFFICE 2010 EXCEL number in a column, because of the adjustment form, number chaotic whole, a change may be a serial number if the manual is really slow too much trouble, how we can quickly resolve?

If the number is not content with other forms of adjustment to change, then when in the production of MICROSOFT OFFICE 2010 EXCEL table number should be separated from the field and other fields, such as in the “Total” and “ranking” of the open a space between, in order not to affect the display appearance, you can set this field empty columns hidden, so adjust the table (data list) will not affect the contents of the serial number.

09, made with Microsoft office 2010 excel2000 payroll, pay only the first individuals of the section head , want to export into the form of wages. How to do?

Should do to solve this problem: first copy a payroll, and then select the Page Setup options for a worksheet, set the print worksheet row headings, section head of the selected wage, and then insert rows in between each individual page character, then set the page length to the height of wages. Way to use custom Chinese reinstall again Office, Microsoft office 2010 excel’s only A4 paper option one, how do? Just install a printer driver on it.

10, can not enter the decimal point in Microsoft office 2010 excel, press the decimal point, it is displayed in a comma, no matter how set the options to no avail, how to do?

This is a rather special problem, I have spent a dozen hours this time, but it plainly is simple. In the Windows Control Panel, click on “Regional Settings” icon in the pop-up “Regional Settings Properties” dialog panel in the “Regional Settings”, select “Chinese (PRC)” in “Regional Settings Properties” dialog panel on “ number “attribute to the decimal point”, press” OK “button to finish. Microsoft office 2010 download excel will then open the way everything is normal.

 

 

You may have accidentally crashes encountered, if the Internet crashes when browsing the web that not only what it wants to re-open. If we are using Ms office 2007 word crashes when editing a document, then re-open Ms office 2007 word is not so simple, if not in time to save, that loss may not use language to describe it. Although Ms office 2007 word 2007 can automatically recover accidentally turned off to save the document, but who can guarantee foolproof? Moreover, if the settings in Ms office 2007 word auto-recovery time is the default time information (the default automatic recovery is 10 minutes), then the 10 minutes of work, may go down the drain.

Then we can only be a passive acceptance to us by the crash caused the damage? In actual fact, the key moment let’s manual not automatic. Just open the “C: \ Documents and Settings \ Administrator. User name-CC19B9C4FD1 \ Application Data \ Microsoft \ Ms office 2007 word” this folder (due to different user name, display may vary slightly), can be found in the folder automatically when the crash Save the file.

As the “Microsoft \ Ms office 2007 word” folder is hidden, so open the process somewhat cumbersome, we can operate, in the Ms office 2007 word window, click “Officel icon → Options”, open the “Options” window, select “Save”, after the right side of the window, “AutoRecover file location” box, copy the file path, and then open on the desktop “My Computer” will just copy paste the file path into the address bar and press Enter that be.

In the open folder, right click, select “Arrange Icons → modify time”, to all the files folders arranged by time, so that, even if Ms office 2007 word does not automatically restored, we can get back with Dead Time corresponding file, and open the first file, then save it as you can.

Tips

Usually when editing a document, it is best to “Save AutoRecover information interval” is set to 1 minute. Is in the Microsoft  office 2007 download word window, click “Officel icon → Options”, open the “Options” window, select “save” after the right side of the window “Save AutoRecover information interval” was changed to 1 minute, click on ”OK” button. Thus, even if unexpected problems occur, it can be to minimize the loss