Understanding the Excel 2007 Interface Ribbon Ribbon

The Purple Circle section of the figure is the Microsoft Office Button.

The green section is the Quick Access Toolbar.

The red section is the Ribbon (Ribbon).

The orange section is an intelligent ScreenTip.

The blue part is the right mouse button to click on the Mini toolbar and shortcut menu that appears in the cell.

Icon: Excel2007 interface (click to see larger image)

The Office2007 Ribbon (Ribbon) consists of a variety of content, including dialog boxes, libraries, and some familiar toolbar buttons. In each Office application, ribbon has different content, but it is located at the top of the application and is made up of similar components.

Tab: At the top of the Ribbon. The Standard tab is start, insert, page layout, formula, data, review, view, add-ins, and the default tab is the Start tab, which allows users to click on the tab you want to select.

Group: Located inside each tab. For example, the Start tab includes groups such as clipboard, font, alignment, and related commands that are grouped together to accomplish a variety of tasks.

Commands: The form has boxes, menus, or buttons, and is arranged within the group.

Note: In either tab, double-click the mouse to hide the Ribbon (Ribbon), and in the hidden state, click a tab to view Ribbon and select the command. Double-click the mouse function area (Ribbon) again to restore the display.

About the Ribbon user interface Bill Gates said, "The Office 2007 Fluent/ribbon user interface, Microsoft risked a certain amount of risk." Over the years, in our Windows and Mac software, the ' file ', ' edit ', ' View ' menu model has become the standard. But we find that doing so hides part of the functionality. The reality is that the Drop-down menu is getting longer and the user doesn't know the options at the bottom of the menu. This means that the functionality that the user asks us to implement, we already have. ” After Office 2007 employs the Fluent/ribbon graphical user interface, Microsoft employs a similar concept in office 2008 for Mac. Microsoft also authorized Third-party developers to enhance the functionality of ribbon. "So we think that if you don't change the UI, then the user will be unaware of the use of some features." So we use the Ribbon theme. We had a strictly prohibited usability test and we got very positive feedback. ” Now, Fluent/ribbon is not only used in office, but Microsoft also makes it part of the graphical interface of Windows 7. "Ribbon is really starting from office 2007, but we want it to be extended to all software," Gates said. It has been proved that the interface can fit the touch screen well and can give full play to the function of the software. ”

Here's a detailed description of EXCEL2007 's functional area.

　　Computer Tutorial diagram: Excel2003 interface

Second, the tab in the Ribbon (Ribbon)

In Excel 2007, the Ribbon (Ribbon) combines related commands and features into different tabs, as well as tabs that appear based on the tasks that are performed.

Excel2007 the Start tab

Illustration: In the Ribbon of Excel 2007, each tab contains several groups of related commands

If you want to insert an object, select the Insert tab of the Ribbon (Ribbon), which includes the objects and related commands that you can insert on the worksheet, and if you continue to select chart in INSERT, the Ribbon will appear with tabs associated with the chart. That is, users can easily find the commands they currently need, rather than looking for a menu with a menu like the original.

As with standard tabs, other two types of tabs related to the current task appear in the Ribbon (Ribbon): Contextual tabs and Program tabs.

The contextual tab appears when you use, WordArt, chart, or table. For example, when you select a chart, the design, layout, Format tab appears under the Chart tools, and these tabs provide more appropriate commands for manipulating the chart. When these objects are not selected, the contextual tabs associated with them are also hidden.

Diagram: Contextual tabs that appear after you select the chart tool

When you use one of the authoring modes or views, the Program tab replaces the Standard tab. For example, when you click the Print Preview command, the Print Preview tab replaces the Standard tab.

Diagram: Programs tab that appears after you select the print Preview command

Development Tools Tab

Development Tools tab This tab contains commands related to program development and XML functionality, which are usually hidden.

To display the Hidden Development Tools tab in the Ribbon (Ribbon), you must press the Round Office Button to select Excel Options-Common in the menu, and check the "Show the Developer tab in the Ribbon".

In some groups in the ribbon, such as the Clipboard, font, alignment, and so on in Figure 1, there is a small icon in the lower-right corner called the dialog Box Launcher. Click the icon to open a related dialog box or a task panel with a set of commands, allowing you to select more options.

Icon: After clicking on the dialog Box Launcher in the lower-right corner of the Clipboard, the task panel appears

Smart ScreenTips in the Ribbon (Ribbon)

The tooltip features are enhanced in the Ribbon of Excel 2007. When you point to a command in the Ribbon, the pop-up window displays not only the name of the command, but also the detailed functionality or use of the description, such as the shortcut key for the command, the action performed by the command, typical usage, A graphical demo command can also display dialog boxes that can be opened to access more options.

Diagram: Mouse pointing to merge and center, a smart ScreenTip appears

If you want to remove the smart prompt, you can press the Round Office Button to select Excel options on the menu, and in the Standard tab of the Excel Options dialog box, you can select ScreenTip style to display feature descriptions without ScreenTips or no ScreenTip. "