Collapse button (Access), 764
Collapse button (OneNote), 528, 559
Collapse Page Tabs button (OneNote), 529
Collapse Section button (PowerPoint), 385
collapsing
bullet points, 402
OneNote notebooks, 528
OneNote Page Tabs Bar, 529
OneNote subpages, 559
ribbon, 757
subdatasheets, 764
collating printed documents, 217, 493
Color button (Word), 171
Color gallery (Word), 171
color gradients, 429, 975
Color Model dialog box (Publisher), 889
color of pen, 509
color of Word user interface, 18
color palettes, 426
color scales, 335, 336
color schemes, 951
applying, 958
applying to cards, 954
applying to slides, 426
creating, 426, 444, 951
for calendars, 978
for cards, 957
in templates, 965
previewing, 951
switching, 951
viewing, 426
viewing all, 958
coloring backgrounds, 176, 426
coloring pictures, 171
coloring shapes, 934, 961-962
coloring text boxes, 905
colors
adding to publications, 952
changing, 835
Colors button (Access), 829
Colors button (PowerPoint), 427
Colors dialog box (Access), 835
Colors dialog box (Excel), 321
Colors dialog box (PowerPoint), 444
Colors dialog box (Publisher), 960
Colors gallery (PowerPoint), 426
column breaks, 140, 146
column headers, 261, 356
column width in views, 665
Columns button (Word), 141
Columns dialog box (Word), 144
columns, document, 139. See also table columns
applying to entire document, 141
formatting, 140
hyphenating text in, 141, 145
indenting text in, 145
justifying, 141-142
margins, 143
overview of, 140
section/column breaks in, 140, 142
separated by tab stops, 147-148
spacing, changing, 144
columns, form, 838
Columns gallery, 140, 141
columns, publication, 760
adjusting to fit contents, 805
hiding, 806, 807
resizing, 763
selecting multiple, 849
columns, table
deleting, 153
inserting, 153
resizing, 153
setting width of, 159
columns, worksheet
changing multiple, 237
copying, 261
deleting, 238
##### error code, 301
filtering. See filters
formatting, 312
hiding, 238-239
inserting, 237, 239
labels, and filtering, 349
labels, as range names, 283
labels, hiding, 249
moving, 261
selecting, 261
unhiding, 238
width, changing, 237
width errors, 301
combining cells, 153-155
commands. See also ribbon
adding to Quick Access Toolbar, 32, 244, 251
from previous versions, adding, 7
comments
in worksheet ranges, 282
printing, 493
commercial print settings, 888
Compact view (Inbox), 619
company contact information in Publisher, 879
creating, 882
editing, 884, 887
comparing worksheet values, 335-337
compatibility
checking, before distributing document, 219
with earlier versions of PowerPoint, 503
with earlier versions of Word, 44
Compatibility Mode, 45
completing records, 798
completing records 991