Datasheet

Introducing the Quick Access Toolbar (QAT) — Previewing Your Formatting Live 15
Figure 1-7
The Backstage navigation pane includes an Options button, which gives you
access to various Excel options. We encourage you to visit the options from
time to time because you may find useful application, workbook, or worksheet
options that you want to turn on or off. An option in the Advanced tab of the
Excel Options dialog box, for example, allows you to increase the number of
documents displayed in the Recent Workbooks list to a maximum of 50. You’ll
find a list of recent workbooks in the Backstage Recent tab.
Previewing Your Formatting Live
When you hover over a formatting option with the mouse pointer, Excel lets you
see the effect that the formatting option will have on your selection before you
commit to applying the option. This feature is called Live Preview. Your selection
for Live Preview might be a cell, a range of cells, a chart, a table, a shape, and more.
Suppose that you want to change the font of some text in a cell. On the Ribbon, a
drop-down box called the font picker presents a list of available fonts. As you
hover over each choice in the font picker, your cell updates to show you what
the text would look like if you chose that font. Live Preview avoids the normal
tedium of committing to an option, then undoing the option because the result
03_527559-ch01.indd 1503_527559-ch01.indd 15 4/1/10 6:59 PM4/1/10 6:59 PM