file formats, 44
icon sets in, 335
online version, xi, xv
program window, customizing, 241
starting, 4, 227, 229
user interface, customizing, 241
Excel, earlier versions of. See also Excel 2007
Paste Options button , 261
pasting in, 261
Excel formats, 229
Excel Options dialog box
Customize The Quick Access Toolbar page, 244, 251
Customize The Ribbon page, 246, 252
Excel table styles. See table styles
Excel tables
AutoExpansion, 275
columns, adding/removing, 276
converting to range, 277
creating, 275, 277
data, adding, 275, 277
data series in, 276
Design contextual tab, 277
fill color, 324
filtering. See filters
formatting, 322
formulas in, 276, 277, 293
in formulas, 289
names, adding to formulas, 295
overview of, 255
renaming, 276, 278
resize handle, 276
rows, adding/removing, 276
summarizing data in, 276, 277
table style gallery, 275
Total row, 276
Excel workbooks
arranging multiple windows, 243, 251
copying worksheets, 233, 235
creating, 228, 230
default, 228
display font, changing, 313, 315
displaying side by side, 243
Document Properties panel, 229
filtering ranges, 284
properties, 229-232
saving, 229, 232
switching between, 227, 243, 251
themes. See themes, Excel
Excel worksheets
backgrounds, 341-344
columns. See columns, worksheet
copying, 233, 235
creating, 233
deleting, 234, 236displaying, 233
filtering. See filters
hiding, 234, 235
images, adding, 339, 342
purpose of, 233
renaming, 233, 235
reordering, 234-235
rows. See rows, worksheet
searching, 264
tab color, changing, 234-235
unhiding, 234, 236
Exchange address list. See Global Address List (GAL)
exiting. See closing
Expand button (Access), 764
Expand button (Mini Translator), 87
Expand Contact Card button, 631
Expand Navigation Bar button (OneNote), 527
Expand Section button (PowerPoint), 386
Expand The Ribbon button, 8, 33, 751
expanding ribbon, 8, 33
exporting presentations as outlines, 380
extensions, file name, 617, 791
External Data tab, 756
external files, linking in OneNote, 565, 572F
fancy effects. See WordArt objects
faxes, creating, 605
Field Chooser dialog box, 664
field codes for mail merges, 971
Field Name column, 809
field names, 829
Field Properties area, 810
fields
captions, changing, 812
customizing, 664, 666
data type, changing, 809-810
deleting, 810
description of, 809-810
filtering records by, 851
freezing, 807
hiding, 806
inserting, 812
moving, 808
naming, 809-810
naming conventions, 800
properties, viewing, 810
Quick Start, 799, 803
renaming, 798, 800
resizing, 805
selecting, 806-807, 809fields 997