technology center

Office Art and Design Team (OfficeArt team) to build a brand new Office 2007 document themes platform (Document Themes platform). Through this platform, the new PowerPoint design templates can be applied to Microsoft Word, Excel, even Outlook e-mail above. Every Office theme style files are fully compatible with these programs and can run well. Therefore, you can use this new feature, reuniting their own slides, documents, spreadsheets and e-mail forms.

Office Theme Styles: sing pretty songs to document

Office style based

Office Theme Change

Label design (The Design Tab)

Microsoft Office excel completely abandoned the previous pull-down menu, make a more intuitive tabbed menu, which greatly facilitates the user’s operation. Especially for the novice, fully able to “zero” time to get started operation.

More for some set of menu items, click on the button to the lower right corner to start the cascade up dialog box.

Double-click a menu label (such as “start”), you can label the corresponding up hidden menu, expand the editing area; again, click a menu tab, you can expand the corresponding menu tab.

2, the task pane to cancel good

As you know, since Ofice2002 version, the component adds a “task pane” feature. Due to start “task pane”, the total area of ​​nearly one third of the editing area, then, everyone through the “Options” settings, cancel the self-starting of the “Task Pane” feature. Well now, in Office 2007 download version, the “task pane” feature has been canceled.

3, folding edit user-friendly

In previous versions, but we enter a cell to a large number of characters, and then select the cell, then show the contents of the bar, and hide the following contents of some cells. In 2007, with the folding bar. Typically, only the contents showed a line, if you want to view the entire contents of the bar, simple click on the right side of the fold button. Expand bar, the entire table down automatically and will not cover anything off the table.

4, the combined center more scientific

As we all know, Excel has a “merge center” function – you can merge multiple cells into one cell. If we want more than one cell of each line into a single cell, in previous versions, only one line of operation. In Excel2007, you can one-time operation is complete:

Selected range of cells need to merge multiple lines, expand the “Start” menu tab, click the “Merge and Center” button on the right of the drop-down button, then the pop-up drop-down list, select the “cross merge” option that be.

5, intelligent positioning the dialog box

Excel2007 formatting dialog box for the appropriate positioning more intelligent: For example, we select a cell (area), in the “Start” menu tab, click the “Fonts” tab button on the bottom right corner of the cascade, to open “Format Cells” dialog box, and navigate to the “Fonts” tab.

6, the election that was set up font size

We select a cell (area), in the “Start” menu tab, click “Size” drop-down button on the right, the font size in the subsequent pop-up list, when we hover over a font is the time , the characters in the cell immediately to the appropriate font size display and inform the adjustment of row height to fit the size font size

7, quick to add header and footer

In addition to the traditional method can be used to set the header sheet (foot), the increase of the fast setting the header (pin) method: Click the status bar on the right of the “page” view button, switch to the Page Setup view, that is, the corresponding characters can be entered into the header (foot) position

8, the function really easy to follow

When we enter the functional number of leading operators and function names –”=” earlier letters, the system automatically lists similar functions for the operator to directly select the input, not only improves the function of type of input speed, but also to ensure that the function the accuracy of input.

9, to find more powerful

In the “Start” menu tab, click the “Find and select the” drop-down button on the right, in the subsequent pop-up drop-down list, select the appropriate option (such as “formula”), to complete the search and selection of appropriate operation.

10, color filter with magic bullet

May be due to a need, we give a column of cells (or characters) to set a different color, and now need to filter out data in the same color. In previous versions it is difficult to achieve, in the 2007 version, you can easily: select the appropriate column of a cell, switch to the “Data” tab menu, click click one of the “Filter” button into the “Auto Filter” state, click the column heading down the right button, then the shortcut menu (Figure 9), expand the “color-screening” the cascade menu below, choose one as needed ” Fill Color “or” character color “button.