Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Custom-tailoring the Excel workspace
CHAPTER 3
Custom-tailoring the Excel workspace
Customizing the ribbon. . . . . . . . . . . . . . . . . . . . . . . . . . . . 75
Customizing the Quick Access Toolbar ...............84
Controlling other elements of the Excel 2010
interface.........................................95
Enhancing accessibility ............................99
Installing apps...................................101
YOU NEEDN T settle for the way the Microsoft Excel 2013 command and control system is
organized. You can customize the Quick Access Toolbar and the ribbon, so if you feel
that the Microsoft interface designers didn’t exactly have you in mind, you can make
a lot of adjustments to Excel 2013.
Customizing the ribbon
When the ribbon was introduced in Office 2007, it was fixed—you couldn’t modify the user
interface unless you were conversant in VBA or XML. In Office 2013, the ribbon is open for
interpretation; you can freely rearrange command groups; change the order and position of
tabs; remove groups; and create custom commands, groups, and tabs. The bad news: you
cannot add or delete commands from existing groups, and you cannot delete existing tabs.
But this really isn’t much of a problem; a truly dedicated customizer can create a whole new
set of tabs and stick them in front, forcing the default tabs off the screen, or simply hide all
the default tabs.
Start by right-clicking anywhere on the ribbon and selecting the Customize The Ribbon
command on the shortcut menu that appears. This opens the Excel Options dialog box
with the Customize Ribbon category selected (saving you several mouse clicks), as shown in
Figure 3-1.
Does your ribbon look different?
The screen images shown in this topic were captured at the screen resolution,
magnification, and text size that is optimum for publication purposes. The ribbon on your
screen might not look the same as the one shown in the topic. For example, you might
see more or fewer buttons in each of the groups, the buttons you see might be
represented by larger or smaller icons than those shown, or the group might be represented
by a single button that you click to display the group’s commands
75
Search JabSto ::




Custom Search