Chapter 1: Time for Something New 13
worksheet become available in the user interface (see Figure 1-2). Options related to
other worksheet tasks (for example, sorting or filtering data) are completely out of the way
(not simply grayed-out). This simplifies the work area and shows users only what they need
related to the task at hand.
Figure 1-2 The user interface displays only what you need to accomplish a specific task.
Tip For a detailed look at each of the features in the new Microsoft Office system user
interface, see Chapter 2.
Legacy Mode and Keyboard Support
If you are the type of user who prefers using the keyboard over the mouse (and there are many
of us out here!), you will be pleased to know that the 2007 Microsoft Office system includes a
number of features for keyboard lovers.
■ First, every keyboard shortcut you use in previous versions of Microsoft Office works
exactly the same way in the 2007 release.
■ Second, new KeyTips show you quick keys you can use to navigate through the user
interface without using the mouse.
■ And finally, the Microsoft Office system includes a Legacy mode that users can turn on to
bring keyboard accelerators to life. All the keyboard accelerators you’re familiar with will
work with the 2007 Microsoft Office system.
Create It Once; Use It Many Times
Because the 2007 Microsoft Office system is built completely on the new Office Open XML
file format, you can use the documents and data files you create in the Microsoft Office
system in a variety of other applications. Consider this: you spend a lot of time perfecting
the annual report for your small business. You’ve got the phrasing just right; you love the
images you selected; the template includes all the formats you want to use in your other
business documents.
14 Part I: Introducing the 2007 Microsoft Office System
As you create marketing brochures throughout the year, you can use the text you created in
your annual report without cutting and pasting. Why? Because it’s saved as XML data, and
you can pull that data directly into your brochure template in Office Publisher 2007. When
you want to create an Office PowerPoint 2007 presentation to show potential investors how
efficient your operation is, you can pull from that annual report (and the Office Excel 2007
worksheets that provided the financial data) because everything is saved as XML data.
Not only does the new Office Open XML format save you time and trouble but it also
decreases the margin for error that is introduced when you have to rekey information or copy
and paste portions of files from one document to another. You can work smarter, easier, and
faster—and produce more accurate results because of the Office Open XML format in the
2007 Microsoft Office system.
Coming Next
In the next chapter, you’ll learn more about that various aspects of the new 2007 Microsoft
Office system user interface. Read on to find out about the changes in the UI, as well as the
new contextual commands, Galleries, Live Preview, and much more.
Chapter 2
A New Look
What you’ll find in this chapter:
■ Learning the landscape: The new user interface
■ The new File menu
■ Using the Quick Access toolbar
■ New view controls
■ Keyboard support
The most talked-about change in the 2007 Microsoft® Office system—the one the public was
so excited to see for the first time—is the revolutionary change in the Microsoft Office system
user interface. As you learned in Chapter 1, a great amount of research, testing, thought, and
effort went into designing an end user experience that puts the needs of the information
worker (or business owner or manager) at the center. In other words, the software is sup-
posed to work the way you do. To accomplish that goal, the way the programs interact with
you must be smooth and seamless. Commands need to be easy to find; the right tools must
show up when you need them; and the work area must be open and uncluttered so you can
focus on the most important task at hand—completing your project, not wrangling with
multilevel menus and bottomless nests of dialog boxes.
Learning the Landscape: The 2007 Microsoft Office
System User Interface
The design of the 2007 Microsoft Office system user interface includes fully a dozen new
features that will ultimately make working with your favorite applications less work. If that
seems counterintuitive (12 new features will make things easier?), keep reading. This section
shows you how each component fits into the overall goal of simplifying and streamlining your
options so you always have what you need for your current task.
Tip Why do we need an easier interface? When you consider that the original version of
Microsoft® Office Word (1.0) had only about 100 commands, and the most recent version,
Office Word 2003, includes more than 1500, it’s easy to understand how the sheer number of
features has outgrown the original menu system. To find some commands, you have to hunt
through menus, multiple submenus, and dialog boxes. The new 2007 release user interface
brings the commands to you—with more power, more flexibility, and software that anticipates
what you need and when you need it.
15
16 Part I: Introducing the 2007 Microsoft Office System
Using the New User Interface
If you’ve been working with Beta 1 of the 2007 Microsoft Office system or if you read any of
the press coverage or blog posts about the new release, you’ve heard about the new user
interface, which is the dramatic new replacement for the customary menu system in previous
versions of Microsoft Office. The user interface stretches across the top of the work area in
most of the core applications, giving you tabs, contextual commands, and more that are
related to the current operation you are performing (see Figure 2-1).
The user interface is actually a collection of a number of components:
■ Command tabs (such as Home, Insert, Page Layout, Formulas, Data, Review, and
View in Microsoft® Office Excel® 2007) stretch across the screen just below the window
title bar.
■ Command sets are the commands available for the selected tab that relate to what you’re
trying to do. The name of the command set appears below the commands (for example,
Clipboard, Font, and Alignment are shown in Figure 2-1).
■ Contextual commands appear only when an object (table, chart, and so on) is selected.
Figure 2-1 The user interface includes command tabs and command sets that relate to a
specific aspect of your project.
Chapter 2: A New Look 17
Command Tabs
The menu system you are used to seeing in Microsoft Office has now been replaced with a
series of command tabs that relate directly to the tasks you need to accomplish. For example,
the new command tabs in Microsoft® Office Word 2007 are File (marked by the 2007 release
logo), Home, Insert, Page Layout, References, Mailings, Review, and View (see Figure 2-2). In
Office Excel 2007, the command tabs are File, Home, Insert, Page Layout, Formulas, Data,
Review, and View.
Figure 2-2 The command tabs in Office Word 2007 correspond to the different tasks of
preparing a document.
The tabs correspond directly to the stages of the process you’re likely to follow as you create a
project in an application. For example, when you’re creating a worksheet, you need com-
mands related to data entry, editing, and formatting. Further on in the process, you might
want to work with the information on the worksheet by sorting, filtering, consolidating, or
validating it. These commands are available in the Data tab, further down the row in the
Office Excel 2007 command tab display.
18 Part I: Introducing the 2007 Microsoft Office System
Command Sets
Different commands appear in the user interface, depending on the tab you selected. If you
click the Home tab in Office Word 2007, one set of commands appears in the user interface;
if you click the Review tab, a different set is displayed. This type of filtered tool display cuts
down on the number of menus, commands, and dialog boxes you have to sort through to find
the items you want. Each command set is grouped according to its function. In Figure 2-3, the
Page Setup, Themes, Background, and Arrange groups are all command sets for the Design
tab in Microsoft® Office PowerPoint® 2007.
Figure 2-3 The set of commands displayed in the user interface varies, depending on the
command tab you select.
Contextual Tools
To keep the design uncluttered and relevant to what you’re doing, contextual command sets
appear only when a specific object is selected. Figure 2-4 shows a set of contextual tools that
become available after you add a diagram with the SmartArt tool (available in the Insert tab).
The name of the displayed contextual tool set appears above the user interface and is
highlighted so that you can recognize it easily.
Chapter 2: A New Look 19
Figure 2-4 Contextual commands display only the commands you need that are related to the
currently selected object.
Dialog Launchers
Some command sets on the user interface are also available in traditional style dialog boxes.
You can display the dialog box by clicking the dialog launcher in the lower-right corner of the
command set. Here’s how it works. Click the command tab you want (for example, Home in
Office Word 2007). Now click the small arrow symbol in the lower-right corner of the com-
mand set you want to display, which launches the dialog box for that set of commands, as
Figure 2-5 shows.
Dialog launchers are also available at the bottom of any gallery that shows advanced options.
For example, when you choose the Page Layout command tab and click the Columns down
arrow, a gallery of column-wrapping settings appears. Click the More Columns option at the
bottom of the gallery to launch the Columns dialog box (see Figure 2-6).
20 Part I: Introducing the 2007 Microsoft Office System
Figure 2-5 Dialog launchers display some command sets in traditional dialog boxes.
Figure 2-6 Click the More Columns option at the bottom of a gallery to display a dialog box of
additional options.
Galleries
Galleries are a great visual addition to the design of the new program windows—they make
finding the look you want as simple as point and click. The 2007 Microsoft Office system
includes two types of galleries. Galleries with only a few selections are typically shown as part
of a command set in the user interface; but galleries with multiple selections (such as Themes,
Margins, and Position in Office Word 2007) display as drop-down galleries in which you can
make your selection.
When you select a command that has a down arrow next to it (which means that additional
choices are available), the palette of options appears (see Figure 2-7). You can see at a glance
which color combination, format, color scheme, transition, or chart type you want. Just click
your choice (or point to it if you want to use the Live Preview feature, described next), and the
setting is applied to the current document or a selected object.
Chapter 2: A New Look 21
Figure 2-7 Galleries enable you to easily find and select the choice that’s right for your project.
Live Preview
Live Preview enables you to try a choice on for size before you select it. Now when you
consider an option (such as the Page Color gallery shown in Figure 2-8), you can point to it.
The effect is then applied to your document, worksheet, or presentation so you can see how
it will look. If you want to keep the change, click the option. If you want to keep looking, point
to a different option.
Figure 2-8 Live Preview shows you what the result of your choice will look like before you actually
select it.
22 Part I: Introducing the 2007 Microsoft Office System
The new Office 2007 system user interface changes are currently available in Office Word
2007, Office Excel 2007, Office PowerPoint 2007, and Microsoft® Office Access 2007. Some
aspects of Microsoft® Office Outlook® 2007 also incorporate the new features.
The New File Menu
The File menu has had a major bit of cosmetic surgery—instead of the word “File,” the 2007
Microsoft Office system logo now marks the spot where the File menu resides. And the
changes in the File menu aren’t only cosmetic—functional changes help you focus on the file-
related tasks you need. The new File menu includes two panels. On the left, you see the major
file tasks; on the right, the choices related to those tasks appear when you point to one of the
commands on the left. For example, when you position the mouse over Save As, the options
shown in Figure 2-9 appear.
Figure 2-9 The File menu displays additional choices when you point to its major commands.
In each of the applications, the tasks in the File menu follow the basic progression of the life
cycle of your document. One great new addition is the Finish command, which provides you
with options for completing the document—whether the file is an Office Word document, an
Office Excel worksheet, or an Office PowerPoint presentation (see Figure 2-10). The Publish
command, also in the File menu, gives you the means to publish your files to a shared
document workspace, Excel Services, or your blog (perhaps the best-kept secret in Office
Word 2007!)
Chapter 2: A New Look 23
Figure 2-10 The Finish command gives you options for checking and protecting your file.
Quick Access Toolbar
To the right of the File menu on the user interface you see three familiar tools: Save, Undo, and
Redo. The Print tool is a smart addition to this group, placed along with the other tools for
easy access. These tools are part of the Quick Access Toolbar, which travels with you from appli-
cation to application. These four tools are available in the same spot in all the Office 2007 core
applications that have the new user interface. You can customize the Quick Access Toolbar to
add other tools you use regularly. For example, you might want to add the Hyperlink tool to
the Quick Access Toolbar so it is available in all your applications.
To add a tool to the Quick Access Toolbar, right-click the tool and select Add To Quick Access
Toolbar (see Figure 2-11).
Figure 2-11 Add your favorite tools to the Quick Access Toolbar.
Tip If you put a number of tools on the Quick Access Toolbar, you might want to display it in
its own row in the user interface. Right-click anywhere on the Quick Access Toolbar and choose
Place Quick Access Toolbar Below The User Interface. To return the display of the toolbar to its
original state, right-click the Quick Access Toolbar a second time and choose Place Quick
Access Toolbar Above The User Interface.
24 Part I: Introducing the 2007 Microsoft Office System
New View Controls
With all the changes in the 2007 Microsoft Office system interface, you might wonder where
some of your favorite tools have gone. How do you work with other open files, which used to
be the function of the Window menu? How do you move among views so that you can work
with your document outline, display Slide Sorter view in Office PowerPoint, or zoom in for a
closer look at a document?
The 2007 release uses the View tab to organize the controls you need for viewing your
documents. Everything you formerly found in the Window or View menus, you’ll now find
by clicking the View tab (see Figure 2-12). The familiar View tools appear in the lower-right
corner of the document window, to the left of a handy Zoom tool that enables you to enlarge
or reduce the display of your document incrementally while you work.
Figure 2-12 Switch between windows and change the view by using the commands in the
View tab.
Tip To magnify or reduce the size of the document displayed on the screen, drag the slider
in the Zoom tool until the document is the size you want.
Chapter 2: A New Look 25
Keyboard Support
People who become proficient with software often look for (or create!) shortcuts to help them
cut down on wasted keystrokes and mouse clicks when they do routine tasks. The 2007
Microsoft Office system includes a number of keyboard features that will make even the most
ardent shortcut key lover happy. Three different levels of keyboard support are available:
■ KeyTips enable you to toggle on the display of keystrokes you can press to navigate the
user interface using the keyboard.
■ Keyboard shortcuts in the 2007 release work exactly the same way they worked in
Office 2003 (see Table 2-1).
KeyTips
KeyTips in the 2007 release display all the available shortcut keys so you can choose the one
you want. To toggle the display of the shortcut keys, simply press Alt and wait a moment. The
KeyTips appear on top of the commands wherever they’re found; simply press the letter of
the command you want to select (see Figure 2-13).
Figure 2-13 Press Alt to toggle on the display of KeyTips.
Keyboard Shortcuts
There are so many keyboard shortcuts in the 2007 Microsoft Office system that it’s possible to
use your favorite applications without ever touching a pointing device. These keyboard short-
cuts are carryovers from Microsoft Office 2003—but the important thing is that if you’re a
shortcut fan, you’ll be pleased to know that every keyboard shortcut works the way it did in
the previous release (no unlearning required). Table 2-1 provides a list of the shortcuts that
are common to all the core applications, but each application has its own huge range of
keyboard shortcuts for you to put into service.
26 Part I: Introducing the 2007 Microsoft Office System
Table 2-1 Common Keyboard Shortcuts in the 2007 Microsoft Office system
Shortcut Command Shortcut Command
Ctrl+O Open Ctrl+E Align Center
Ctrl+Z Undo Ctrl+C Copy
Ctrl+Y Redo Ctrl+X Cut
Ctrl+S Save Ctrl+V Paste
Ctrl+P Print Ctrl+F Find
Alt+F4 Close the Active Window Ctrl+H Replace
Ctrl+B Bold Ctrl+A Select the Entire Document
Ctrl+I Italic F7 Start the Spell Checker
Ctrl+U Underline Shift+F7 Display the Thesaurus
Ctrl+R Align Right Ctrl+Shift+S Style dialog box
Ctrl+Shift+F Font dialog box
Coming Next
Now that you know the basic lay of the land in the 2007 Microsoft Office system, it’s time to
get into some of the systems. The next chapter shows you what’s changed in the Help system
and walks you through the ways to safeguard your files in your favorite applications.
Chapter 2: A New Look 27
Chapter 3
Important Systems: Help
and Security
What you’ll find in this chapter:
■ Finding help in all the right places
■ Using Super Tooltips
■ Changes in Microsoft Office Online
■ Safeguarding your files
■ Publishing files in PDF and XPS format
Productivity is all about movement—moving forward, creating documents, crossing tasks off
your To Do list, getting things done. Whether you are the manager of a large business or a sole
proprietor working alone in an office, the way you meet and resolve obstacles in your day has
a lot to do with how productive you—or your department or your company—can be.
This chapter is all about two important systems that help keep you moving on the road to
productivity using the 2007 Microsoft® Office system. The help system in the 2007 release
has been moved out of the task pane and now links users instantly to expanded and improved
resources. And improvements in the way you finish and protect your completed documents
give you a variety of ways to control who has access to your documents and how far that
access will let them go in modifying, sharing, or printing the files they receive.
Finding Help in All the Right Places
Software help systems usually get a pretty bad rap. The users who rely on them (oddly
enough, statistics show they are often more experienced users) are quick to point out what’s
missing, what doesn’t work, what isn’t helpful. And because help systems are where people go
when they are up against an obstacle and want an answer fast, there’s a level of frustration
built into pressing F1 and looking through a help system for the answers.
If you are the type of user who prefers to find your own way through a new program, you will
most likely click through all the menus and explore the available options, trying to figure
things out yourself instead of consulting a resource like help. If you are the type of user who
reads the manual (Hello! This book is for you!), you are likely to turn to the printed page (or
keep the book handy while you explore the software on your own). So where does the help
system fit in? Help is where you go when none of these other resources is producing what you
27
28 Part I: Introducing the 2007 Microsoft Office System
need to get unstuck; and when help is one of your last stops, you really want it to produce the
answer you need. Fast.
For administrators, help that's done well can be a first line of support for their users who are
new or unfamiliar with a Microsoft Office system application. A brief introduction to the help
system can plug users in to a steady stream of troubleshooting ideas (and creative resources
such as templates, online training, and more) that in the long run can save your company
valuable time and money that might have been spent chasing down an answer that was just a
few clicks away. And a help resource that meets users where they are and offers a range of
detail in the help that is provided—from a simple tool name (tooltips) to how-to articles,
templates, community newsgroups, videos, and training—provides a level of continuing
support beyond the reach of most stand-alone applications.
Changes in the 2007 Release Help System
The changes in the 2007 release help system are designed to get you the best answer for
your questions as quickly as possible. The new Microsoft Office system help viewer has been
designed to provide a variety of ways to find, display, and preserve the help information
relevant to what you’re trying to accomplish.
Figure 3-1 shows the Microsoft Office system Help window. The toolbar includes the familiar
navigation tools—-Back, Forward, and Stop—as well as a new Refresh tool you can click to
update the content of the window as needed. The Application Home tool gives you the option
of accessing additional information related to the program you are currently using.
Four additional tools help you find and view help information, and then preserve the informa-
tion you find. The TOC button enables you to display a listing of help topics related to the cur-
rent application (as shown in Figure 3-2), the Text Size tool increases (or decreases) the size
of the text in the Help window, the Print tool prints the current window, and the Pin tool lets
you “pin” the current Help page open so that you can refer to it while you work.
The Return of F1
If you’re a fan of pressing F1 to get context-sensitive help while you’re working with your
favorite application, you’ll be pleased to know that F1 is back in the Microsoft Office
system. According to Mike Kelly from Microsoft Office Online, “There was a technical
reason why it was difficult to do in 2003 that we fixed in 12. So while you won't always
see context-sensitive links when you press F1, you will always get to help where you can
search…and we will do context-sensitive links for the most common dialogs (one of the
other advantages of online help—we know what are the most popular searches and
context-sensitive requests and can focus on improving those first).” 1
1. Mike Kelly, from Office Online, commenting on Jensen Harris’s blog: http://blogs.msdn.com/jensenh/archive/
2005/11/29/497861.aspx.
Chapter 3: Important Systems: Help and Security 29
Refresh Application Home
Forward Text size TOC
Back Stop Print Pin
Figure 3-1 The new look of the 2007 Microsoft Office system Help window
30 Part I: Introducing the 2007 Microsoft Office System
Figure 3-2 The TOC tool gives you links to task-related help information.
More than a Name: Super Tooltips
One of the important design goals of the new look and feel of the Microsoft Office system was
to unclutter the work area and give you only the tools and options you need to accomplish
your current task. Super Tooltips offer a new way to get contextual help that comes and goes
without taking up a lot of room on the screen.
Super Tooltips give you more information than traditional tooltips (which display only the
name of the tool at the mouse pointer position). Although tooltips display for all tools in the
the 2007 release interface, Super Tooltips are used only for those items that need a little more
explanation. For example, consider the Super Tooltip displayed when the pointer is
positioned on the Format Painter tool (see Figure 3-3).
Figure 3-3 Super Tooltips provide more information than the simple tool name.
The developers of the help system in the 2007 release have envisioned Super Tooltips as the
missing link between the user interface and the help system. Not only do Super Tooltips pro-
vide the expanded descriptions, contextual suggestions, and sometimes even images but they
Chapter 3: Important Systems: Help and Security 31
also link back to the help system so you can press F1 for more detailed information about that
particular command. When you finish with the Super Tooltip, click outside the box to close it.
A Tip for a Launcher
Just so you’ll never have to wonder whether clicking a dialog launcher in the bottom-
right corner of a command set will produce the dialog box you want, you can position
the pointer over the launcher, and a Super Tooltip will show you which dialog box will
open when you click the launcher.
Previewing the dialog box in this way saves you at least one mouse click (and possible
frustration when you open two or three dialog boxes looking for the one you want).
New Offerings from Microsoft Office Online
Microsoft Office Online has new and improved visibility in the core applications—Microsoft®
Office Word® 2007, Microsoft® Office Excel® 2007, Microsoft® Office PowerPoint® 2007, and
Microsoft® Office Access® 2007. When you create a new document by choosing New from the
File menu, the opening window gives you several choices: You can choose a template; select
an existing file; start with a blank document; or scroll down to the Microsoft Office Online
area and click links there to find tips, tutorials, downloads, and additional templates for your
application.
Microsoft Office Online has been totally redesigned to streamline and expand the support
experience. In addition to detailed help information, you’ll find how-to articles, training links,
demonstrations, quizzes, IT and developer pages, Microsoft Security, Ask The Community,
and more. Additionally, you can find resources to help you with specific needs, such as Work
Essentials, Enterprise Solutions, Microsoft Learning, and Microsoft® Office Small Business
2007. Be sure to check out Microsoft Office Online and take advantage of the resources avail-
able to help you get the most out of the 2007 release.