How to Switch Classic Interface in excel2007

A survey by Microsoft shows that only a small number of users will modify the interface of Office. In addition, this unchangeable interface also rationalizes the options and becomes a more user-friendly platform. However, because many advanced Office users don't like the new interface, they will still ask for some ways to customize the Office 2007 interface.

Vendors of third-party software smell this opportunity, so they have introduced some software that can replace and enhance the new ribbon interface of some applications in Office 2007. We also use such a software here.

A tab containing Office 2003 is added to the classic menu. The organization form of option commands in this tab looks very similar to the application of Office 2003, although it is not customizable. If you are an advanced user of Office and hope that Office 2007 can work in your way, then this software introduced in this article can help you get rid of the shackles of Microsoft and control your ribbon according to your own wishes.

Installing additional classic menu software is very simple: you just need to choose to add the new tab to the leftmost word of the existing tab. After the addition is completed, a file named. Menu? Tab, which can provide menus similar to Office 2003.

In this menu, you can see? All of them? Option, which is a drop-down menu with first-level commands, i.e. file, edit, view, etc. In addition, it is the main menu in Word 2003, and each item contains submenus of related commands. What are these? Menu? The menu items in the tab are actually duplicate options, but they can be viewed more intuitively.

And some new orders in 2007, such as? Release? Will be placed in? Documents? In the menu.

Classic menu is inserted as a new tab, so it will not affect the internal code of Word, Excel and PowerPoint 2007. But when you click on the menu items at the top, such as file and edit, you will find that the commands in the list use the icon of Office 2007.

Not everything can really be like the 2003 version of Word, Excel and PowerPoint, and some subtle differences still exist. ? Opinion? In order? Header and footer? Different from the past, it also contains a submenu. There are other strange differences: in Word 2003? Tools > macros > macros? Into this place? Tools > Code > Macro? . In the classic menu in Word 2007, there is another striking thing that is not available in Word 2003: in? Documents? In the menu, there are two? Page setup? Command, one is to open the dialog box, and the other is to open the submenu of the setting command.

You can't change the settings of the classic menu. This program just installed a new label, that's all.

There is an operation you may want to use: new? Menu? The tab will be added to the quick access toolbar and hidden in the ribbon. In this way, you can use the QAT icon directly without using the ribbon.

Classic menus can help you find the commands you need in the old-style menus, but you can't expect to use the same shortcuts as in Office 2003. For example, in Office 2003, you can use Alt+F to open it? Documents? Drop-down menu. In Office 2007, Alt+F is equivalent to clicking the Office button, because? Documents? The commands in are contained in this button. Even if Classic Menu is installed, pressing Alt+F triggers the Office button instead of opening it? Documents? Menu.

Although shortcuts are different from those in Office 2003, you can still use some shortcut keys to select from the menu. Shortcut? More keystrokes are often needed. For example, in Office 2003, you can press Alt+A to view the table menu, and then press? Me? Select from the drop-down menu? Insert? And then press it? t？ Insert a table. In the classic menu of Word 2007, the key to be pressed is more complicated: press Alt+Q to open the ribbon? Menu? Tab, and then press? Answer? 、? 1? Select from the top menu? Form? Command, then press the right arrow key to open the next menu, and finally press? Me? To choose? Insert? Orders. All this really doesn't seem enough? Quick? .

Excel usage skills

Prompt 1, forced line break in cell

Press alt+ ENTER after a character in a cell to force the cursor to switch to the next line.

Tip 2: Lock the title line.

When you select Line 2, View-Freeze Pane-Freeze the First Line (or select Line 2-Freeze Pane) and then browse down, the header line always appears at the top.

Tip 3: Print the title line.

If you want to display the title on every page when printing, Page Layout-Print Title-Title Line: Select the line to display.

Tip 4: Find duplicate values.

Select Data Range-Start-Conditional Format-Highlight Cell Rule-Duplicate Value.

Display effect:

Tip 5: Delete duplicate values