Final Review: The Lowdown on Office 2007
Should you upgrade to the latest version of Microsoft Office?
Computerworld - Editor's Note: This story, originally published on Oct. 11, 2006 and based on Microsoft's Technical Refresh of Office 2007 Beta 2, was reviewed and updated on Jan. 25, 2007 to ensure that it is consistent with the shipping version of Office 2007.
Simplify, simplify, simplify. The challenge for Microsoft in revamping Office was to better organize all the options available without negatively impacting productivity. For new users, that's a particularly important goal, since the menus and toolbars in current versions may appear to be a mishmash.
The overriding design goal for the new user interface, Microsoft says, is to make it easier for users "to find and use the full range of features these applications provide" while preserving "an uncluttered workspace that reduces distraction for users so they can spend more time and energy focused on their work." The redesign makes most Office 2007 applications look completely fresh, clean, new -- and more colorful. From Ribbons that offer clearly labeled buttons to thumbnail previews of most graphic features, the applications bear only a slight resemblance to their former selves.
We've put Office 2007 through its paces, exploring new features, both Office-wide and in specific apps, and taking a particularly close look at the new SharePoint Server 2007.
A new look, starring the Ribbon
In Word, Excel, PowerPoint, Access and most areas of Outlook, the menus and toolbars of previous versions are history. In their place is the Ribbon, a tabbed, horizontal bar divided into groups of icons and buttons organized by task.
The Home Ribbon in Word (see Figure 1) contains groups related to the Clipboard (cut, copy, paste and, for some odd reason, the Format Painter), Fonts (font style and size, plus formatting characteristics such as bold, italic and subscript), Paragraph (for bullets, indenting text, sorting paragraphs, alignment, line spacing and shading), Styles (displayed as a thumbnail gallery), plus Editing (find, replace and text/object selection).
The Home Ribbon covers about 90% of everything you'll need for simple text editing -- the remaining features are dispersed throughout the interface: spell check is on the Review tab, while headers and footers have been moved to the Insert tab (from the View menu in earlier versions). The core formatting features appear on yet another pop-up menu when you select text.
If you want to add a little more spice to a document, the Insert Ribbon has groups for creating and inserting tables, images, links and special text (one group for boxes, WordArt and drop caps, another for equations and symbols). Other Ribbons are provided for controlling page layouts, performing reviews, and defining the current view.
Word's Home Ribbon has most of the tools you need (Click image to see larger view)
Excel's Ribbons are similar: Home (for worksheet editing, formatting and sorting tasks), Insert (to add charts and graphs, hyperlinks and headers/footers), Page Layout (for controlling cell size, grid lines and backgrounds), Formulas (including a new Name Manager for handling named ranges), Data (for import/export, removing duplicates and grouping data), Review (for comments and data protection), and View (freezing panes, adding page breaks and more). At the bottom of some groups is a tiny arrow button that, when clicked, opens a familiar dialog box. Most dialog boxes are unchanged from previous versions of Office -- still dull gray, but at least the options are where you expect them to be.
These "standard" Ribbons are supplemented with contextual ribbons that appear when you're working with a particular object -- a table in Word (see Figure 2), an Excel chart, a diagram in PowerPoint -- then disappear when you click away from that object.
Microsoft says the Ribbon doesn't occupy more space than the standard toolbars of previous versions, though it feels larger. Fortunately, Ribbons can be hidden (Ctrl + F1 is the secret toggle), giving you more document workspace.
The Ribbons can't be customized from within the Office application. Microsoft's Office UI guru, Jensen Harris, says that they're XML-based, and that the company is working with third-party developers who are building ribbon-editing utilities for customizing the interface. We know of only one that is shipping: RibbonCustomizer Professional.
Instead, Jensen suggests, users who want a customized look can add icons to the Quick Access Toolbar (QAT), a button strip that can be docked above or below the Ribbon. (It's above the Ribbon in Figure 1.) Right-clicking on the QAT, or from several other dialog boxes, lets you add buttons, such as the spell check, that are missing from the Home Ribbon. Keyboard shortcut enthusiasts can press the Alt key to see small boxes that represent the available shortcuts for the current Ribbon plus all buttons on the QAT.
Press Alt to see the shortcut keys for editing commands
We found that the new interface made some tasks in Office 2007 harder to complete than in previous versions. With no menu, and depending on what you're doing, it can take a greater number of mouse clicks or keyboard tapping to perform simple tasks, such as switching between two open Excel workbooks -- another reason you may soon find yourself with a crowded QAT.
- Virtually Delivered High Performance 3D Graphics "A picture is worth a thousand words." That old phrase is as true today as it ever was. Pictures (i.e., those with heavy...
- Who does NSS Labs "Recommend" for NGFW? In 2012, NSS Labs found that most available NGFW solutions "fell short in performance and security effectiveness." In 2013 NSS Labs noted "marked...
- CIOs Deliver Productivity Breakthroughs with Intelligent Digital Signage Retailers have long recognized the influence that digital signage provides over a shopper's point-of-purchase decision making process.
- Improving Business Value of WAN Optimization Want to achieve faster ROI with WAN optimization? Read the latest IDC report and discover how you can cut IT costs without compromising...
- Live Webcast IBM FlashSystem V840: Leveraging Software-Defined Flash to Drive Your Business With end-to-end, tightly integrated functionality and super-fast flash technology, products like IBM FlashSystem V840 Enterprise Performance Solution empower businesses to leverage the efficiency...
- What should I look for in a Next Generation Firewall? SANS Provides Guidance With so many vendors claiming to have a Next Generation Firewall (NGFW), it can be difficult to tell what makes each one different....
- IBM FlashSystem V840: Leveraging Software-Defined Flash to Drive Your Business With end-to-end, tightly integrated functionality and super-fast flash technology, products like IBM FlashSystem V840 Enterprise Performance Solution empower businesses to leverage the efficiency... All Networking White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!