1. Create a level Boundary
The use of WORD, in the beginning of his position more than three consecutive type “-” »minus sign», and then return, there will be fine level Swiss delegation. This is the WORD automatic correction features. You can use this feature to create many beautiful Boundary level. To achieve the above functions, must do the following settings: from the “Tools” menu, select “automatic correction” order, in the dialog box choose “type automatically applied format” tab, the “type of automatic” under the ” Border “box on the Application List system.
2. Upgrade for the text title
First, the cursor location to be upgraded to a title of the text, when the Alt + Shift + ← button, the text can be upgraded to a title, and style for the title 1, and for the Alt + Shift + → keys, could be heading for the title of a lower 2 , Title 3…… heading 9.
3. Rapid cancelled automatically
Although the Word of the code function automatically stronger, but according to the author trial, found that automatic code orders often disorder phenomenon. In fact, we can through the following methods to quickly cancel automatic code.
(1) When the Word automatically add its code, you just press Ctrl + Z keys estoppel operation, then code will automatically disappear, and re-type figures, the feature will be banned;
(2) Select “Tools” → “automatically correct option” orders, opened in the “automatic correction” dialog box, click “type automatically applied format” tab, then uncheck “automatic code list” check Box (Figure 1), and finally click “OK” button can be completed;
4. Word rapid removal of horizontal line under the header
Word header removed under the horizontal line can use the following methods:
(1) horizontal line color can be set to “white”;
(2) The header and footer set up, set up tables and borders for the “no”;
(3) The header and footer settings, select and delete the paragraph tag it;
(4) The “style” icon field inside the “header” with “text” on the line
(5) to open the eyebrows of the establishment of the Word document, click the “format” Toolbar, open the “style and format” project. In the pop-up “style and format” dialog box choose to display “all style.” “Style”, selected in the “header” and then click “edit” button. Then click on the “format” button, the pop-up menu selected “border” order, pop-up “border and Diwen” dialog.
(6) selected the “border” tab, if you want to remove one of the small horizontal line, in selected settings of the “no” if you want to change it, will be in the “linear” and “Colours” , “Width” conducted in other settings. Footer on the pattern of settings, as long as footer to regional settings.
5. Delete embedded in the Office Toolbar
Many user-friendly software to operate and provide the Office of the embedded Toolbar. However, some Toolbar we do not necessarily need, a waste of space interface and a waste of system resources. What is more, the Toolbar is very high-handed, even in the view menu cancelled, when the next launch is still there. If you have similar problems, try the following method.
Open Word or other Office components, click on “Tools → custom”, select the “order” tab, select the type of “tool” to find the right “COM add-ons” (FrontPage for “Loading Item “), will drag the toolbar anywhere, closing the” custom “dialog. Click on the toolbar “COM add-in” order to open a dialog - Office Toolbar embedded secret lies. Office XP/2003 inside lists all the available add-ons (as shown), all embedded in the Office Toolbar will appear here. Aware of this secret, to “hegemony” of the Toolbar we can deal with - would not require the Toolbar front of the Duigou removed, the next time you start Word, the Toolbar will not appear, if not Select “FastAIT 2002 Word Addin”, to remove the Jinshan fast translation of the Toolbar; do not check “SnagIt Add-in”, such as SnagIt 7.0 can be removed from the Toolbar.
6. Changes to the default way around the picture
In Word or paste into the picture around the default mode for “embedded” in such a way around the picture can not drag the rotation can not shift into the picture format will often need to be adjusted to “around” to deal with . In fact, we can set the default to “around”, the specific methods of operation: select “Tools → Options” menu command, the dialogue box that appears, select “edit” tab, click the “image insertion / paste Means “drop-down list, choose from” around “the last click” OK “button
7. Graphic-on-demand to amend the default format
Insert the default choice for 0.75 pounds graphical format connect black, white filling, for change the default format, set up by the following methods: first a painting-on-demand graphics, and then right-click the mouse in the pop-up menu, select fast “set-on-demand Graphic format “command, the dialogue box that appears, select” colors and lines “tab, in which the custom settings” lines “and” filled with color, “set up after the click” OK “button. Finally, right-click again-on-demand graphics, select “set the default graphics-on-demand effect” can be ordered.
8. Activated when the input method commonly used to open
As long as one is usually open Word 2003 will automatically switch to “Microsoft Pinyin input method”, if you used this is not the input method will probably find it very bothering. Word can not start to open automatically when we used the input method? » This is actually not difficult to achieve.
Followed by open “Control Panel → Add or Remove Programs”, from the list to find “Microsoft Office Professional Edition 2003″ and click the “Change” button. Office 2003 installed in the window click the “add or remove features the” single-option and click Next, then check the “Select the application of advanced custom,” then click the checkbox next step, from the middle of the list, followed by Start “Microsoft Office → Office sharing → Chinese optional user input → Microsoft Pinyin input method in 2003,” click “Microsoft Pinyin input method 2003″ before the button to select “install” (Figure 2), click ” Update “button. Such as the installation is complete after re-entering the Word, Microsoft is not the Pinyin input method, but input in the first row in the list of Chinese input method. Last as long as the input method commonly used to row in the first place can be.
If you do not want to start automatically when Word opens in the Chinese input method, then there is another more simple approach can be used. Select “Tools → Options” menu command, the dialogue box that appears, select “Edit” tab, uncheck one of the “input method is active control” to the box.
10. Quickly insert the current date or time
Sometimes after write an article, find it necessary to insert in the article at the end of the current date or time, most people are to achieve by choosing the menu. In fact, we may be Alt + Shift + D key to insert the system date and press the Alt + Shift + T combination of keys into the system at present time, very soon!
How to automatic summation in Excel
We can use Excel in quick summation (automatic summation) function, can greatly improve our work efficiency, the use of specific methods are as follows:
(1) how to seek out the data and the same. To assume that cell A2 to the data of the A6 and A7 fill in the cells, operating as follows:
First selected cell A7, double-click on the editorial column “=” and then double-click on the tool bar] [common summation symbol “Σ”; then click with your mouse cells B2 and has been drag to B5, election B2_B5 in the entire region, then in the edit field and B6 can be seen in the formula “= sum (B2: B5)”, click Edit column “√” (or press the Enter key) confirmed that the formula for the establishment of the end. At this point if the B2 to B5 cells indiscriminate importation of data, and immediately they will appear in a cell in the B6.
(2) how to seek data and peer. If you want to D2 cell B2 to the data and fill in the cell E2, is also a similar operation, but the cross-cutting operation to note: The formula for the establishment of the cell (in the case of the E2) must be in the [unit Grid format] [in the dialogue box, select the level of alignment - “conventional” methods, such cells appear in the formula will not affect next to the cells.
(3) how to seek a separate line (or out) and data. If the cell to B2, C5 and the D4 in the data and fill in the E6, the operation is as follows:
First selected cell E6, double-click on the editorial column “=” and then double-click on the tool bar] [common summation symbol “Σ”; then click the cell B2, type in a comma, “”, and click C5, type “,” and then click D4, then in the edit field and E6 can be seen in the formula “= sum (B2, C5, D4)” formula that is confirmed after completion of the establishment.
In summation between the two tables
N-the assumption that the same format and the schedule table, if these should form the same location cells (for example, B2) of all aggregated data, the results will fill in another form of the same format B2, the operation is as follows:
Summary of the first selected cell B2, double-click on the editorial column “=” and then double-click on the tool bar] [common summation symbol “Σ”; then click the tab Table 1, do not hold down the Shift - Fang, then click the tab table n (Note: The summary of the tables should be included in tables 1 and the location between n), after the release Shift-click the cell B2, at this time can be seen in the editorial column To the formula “= sum ( ‘Table 1: Table n’! B2)”, confirmed after the completion of the establishment of the formula.
If you want to Form 1 to Form n the corresponding cells to aggregate all the data summary table in the corresponding cells to, you can use an approach similar cases, one-time summary of the B2 selected E6 to the entire rectangular area, In the original cell has been established in the B2 copied a formula.
If the four cases to several different formats of data in the table (for example, Table 1 B3, Table 2 of the C5, Table 3 of the D3, Table 4 of the E4……) to another table summary of the cell B2, Operation are as follows:
Summary of the first selected cell B2, double-click on the editorial column “=” and then double-click on the tool bar] [common summation symbol “Σ”; then click the tab Table 1, then click the Cell B3, type “,” and then click the tab Table 2 and its cell C5, type “,”…… and so on, each of the labels and selected cell on January 1, the final table After the cells do not type “,” At this time in the editorial column of the formula is: “= sum (Table 1! B3, Table 2! C5, Table 3! D3, Table 4! E4……)”, after confirmation Established formula that is finished.
Can not be wrong for peace
As the operation in the field of numerical changes, the summation of the field all cells did not result in changes in values, resulting in normal operation. You can click on “Tools → Options” orders, opened in the “Options” dialog box, click the “re-calculation” tab. “Calculated” option in selected areas “automatically be” radio button, click “OK” button, can automatically calculate and update cell values.
Fix the size of table in Word
When we use the Word, to enter text in the table, it may be automatically extended to accommodate the width of text, but if we do not want to let cell event of a change in the size, Word can also automatically adjust for the pitch Size to adapt to the cell. To use this feature, the need to set some of the following:
Check the cells. From “table” menu, select “form attribute” order, followed by “Form Properties” dialog. “Forms” tab, click the “Options” button, and then pop-up “form options” dialog, removing the “auto-tune size to adapt to the content” box to form a fixed size. “Cell” tab, click the “Options” button, pop-up “cell option” dialog box, click the check “to the text” box. To allow cell Rongxia as many as possible of the text you can cell margins are set to 0. Upon completion of settings, click “OK” button from the “Form Properties” dialog.
After this adjustment, Word forms will be automatically adjusted to meet character spacing cell size, but the same characters and famous. In Excel can also set up a similar form to allow for the size, is the implementation of the “format → cell → alignment → narrow font filled” command.
Use “Shift” key to change Excel cell into picture
Specific methods of operation are as follows:
First need to copy the selected Chanyuangegouyu into the picture, and then hold down the Shift key, choose “Edit → Copy Image” command, and then pop-up “Copy Image” window, select “picture” single-click option “OK” button. Then the selected region on the form has been reproduced into the picture.
And to require the use of this picture select “paste” can be ordered (or press the Shift key to select the “Edit → paste picture” command), for example, be in Word paste.
In addition, if you select “Print effects such as” single-option, the picture is converted to data in accordance with the region to deal with the effects of the print, for example, set up a rough frame, then paste the pictures out there will be rough frame.
PowerPoint Viewer 2007 viewer
Do you have some PowerPoint file but you don’t have PowerPoint?or PowerPoint is too expensive to by?No problem,you can downlaod PowerPoint VIewer 2007 for free! download it!
PowerPoint VIewer 2007 is a software that only can be used for play PPT but not to build or change it any more.But it is free!
Insert Word table into PowerPoint
We know that in PowerPoint can create forms, but if a Word form in hand, of course, no longer have to waste time and energy to re-create. The use of object function can be easily inserted into Word forms will be inserted into PowerPoint presentations, it is clearly better than the form from scratch to create greater efficiency.
Below with PowerPoint 2007 as an example, Word forms into specific steps.
1. Presentations edit mode, click function of the “insert” tab.
2. Click “copy” in the group “objects” button.
3. “Insert” Object dialog box, click “from the document creating” radio button, then click the “Browse” button to find and select the forms contain the Word document, and click the “Open” button. At this point the selected document will be displayed in the “document” in the text box below.
4. Click “OK” button. Word form is inserted at the current presentation.
Edit Excel data in Access
Excel is very powerful, is not it? But sometimes you will find that if exce document contains so much data excel will become very slow, it is because for those who excel not need to deal with a large amount of data users and design. If you have a large amount of data to deal with, and the need of many other Excel function of the formula could not be completed, I suggest that you use a database, for example, Access. Access is a desktop database software, although it is not professional, but I think to some extent it meet your request, for example, to deal with those that excel handle more data. And the use of the database language SQL, you can also make some very simple to excel, the more complex tasks, for instance, that you want to excle in a series of all the figures are added another figure in this task in exce more complicated, but the use sql language, you can use a very simple order to complete this task.
Well, you first need to import data from Excel inside out, and this how do Which? Do not worry, you create a document Access, click menu “document”, and then click “access to external data”, and then inside the dialog box pops up to open the file type changes. xls, and then select you want to open the document excel it.