Page 767 - Excel 2013 All-in-One For Dummies

Index 749
Design tab options, modifying with, 523–538
embedded, moving to other sheets, 518
embedded versus chart sheets, 518
Format tab, customizing from, 529–532
formatting elements of, 536–541
hidden rows and columns, adding to, 528
inserting specific types from Ribbon, 519–520
overview, 515
parts of, 516–517 printing, 544
Quick Analysis tool,
inserting with, 521–522 recommended, inserting,
518–519
saving as templates,
541–542 sparklines, 542–543 titles, editing, 532,
534–535
Check Accessibility
option, 464 circular references,
336–338, 405
Clear Outline option, 246 Clear Rules option, 174 clearing cells, 194–196 click-and-drag
conventions, 26 clip art, 554–556, 558 Clipboard, Office, 208,
211, 499 cloud, 117
Code window, 722, 723, 724 Collapse Field option, 676
collective editing
change tracking, turning
on, 475–479
comments, 483–486 digital signatures, 465–470 file sharing, turning on,
472–473
marking up with digital
ink, 486–488 merging changes from
different users, 479–482 metadata, adding to
files, 465 overview, 463 removing users from
shared workbooks, 483 Share Workbook options,
474–475
stopping sharing, 482–483 workbook properties,
checking before
distribution, 463–465 workbook sharing,
470–472
Color option, 559
Color Scales option, 174, 175 colors
automatic, changing in Windows 7, 164
chart settings, 523, 529, 530
color coding tabs, 249–250
conditional formatting, 177–178
of elements in Excel, 14 fill, 167–168
filtering data lists by, 609 of font, 163–164
for formula errors, setting, 50
gradients, 167
of gridlines, 59
of hyperlinks, 460
for indicating errors, 355 of number formats,
assigning, 154, 156 patterns, 167–168 saving data for other
Excel versions in
different, 54
for text boxes, 564 themes, 573
Colors dialog box, 164 column charts, 519, 542 Column fields, filtering, 682 COLUMN function, 417, 418 Column Headers option,
677
Column Width dialog
box, 136
Column Widths option,
Paste Special dialog
box, 213 columns
in charts, switching with rows, 525
deleting, 232–233 formatting, 133–138 Freeze Panes feature,
201–204 hidden, adding to
charts, 528
inserting, 232, 233–234 labels on, 28
lookup, 623
print titles, setting as, 282 range names, creating
from headings, 328–329 searching in, 218 selecting all cells in, 128 sorting, 592–596
Table Style options for, 142
Transpose option, 214–215
COLUMNS function, 417–418