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

756 Excel 2013 All-In-One For Dummies
Find Format dialog box, 217, 220
Find Printers dialog box, 272
finding
misplaced workbooks, 189 records with data
forms, 586
and replacing code in
macros, 726–728 first-page headers and
footers, creating
unique, 290–291 Fixed Decimal Places
feature, 99–100
Flash Fill feature, 109–111 Flip feature, 189
folders, saving worksheets
in, 117
following hyperlinks, 459 Font button, 144
Font Color button, 145 Font group, Home tab,
144–145, 162–163 Font Size button, 144 Font tab, Format Cells
dialog box, 163–164 fonts
filtering data lists by, 609 general discussion, 161 pivot tables, 679–680 selecting from Ribbon,
162–163
selecting in Format Cells
dialog box, 163–164 setting for workbooks, 47 sorting on, 596–597
for text boxes, 563 themes, 573
footers
for alternating even and
odd pages, 293
creating custom, 288–290 first-page, creating unique,
290–291
general discussion, 285–286
stock, selecting, 286–288 foreign key, 623
Form button, Quick Access
toolbar, 581–582 Format as Table feature,
126, 139–142, 579 Format Axis task pane,
538–541
Format Cell Alignment
option, 161
Format Cells dialog box
alignment options, 157–159
assigning number formats, 149–150
borders, 164–166
color options, 167–168 creating number formats,
155–157
custom number formats,
152–155
fills, 167–168
fonts, 161, 163–164 orientation options,
160–161 overview, 149 patterns, 167–168 predefined number
formats, 150–152 protection options, 441 text wrapping, 159–160 whiting-out errors
with Conditional
Formatting, 346 Format Chart Title task pane, 536–538
Format Painter, 149, 168–169 Format Picture button, 289 Format Selection option, 529 Format tab, customizing
charts from, 529–532 Format task panes for chart
elements, 536
Formats option, Paste Special dialog box, 213
formatting. See also Conditional Formatting feature; Format Cells Dialog Box
cell ranges, with Mini- Toolbar, 148–149 cell styles, 169–173
of cells, from Ribbon, 143–147
of cells in formulas, 301 chart elements, 536–541 clearing, 194
columns, 133–138 comments, 485–486 Format Painter, 168–169 headers and footers, 290 overview, 125–126 pictures, 559–560
pivot charts, 695
pivot tables, 676–681
in protected worksheets,
enabling, 443
rows, 133, 138–139 searching for, 217 SmartArt graphics, 571 tables, from Ribbon,
139–142
tables, with Quick
Analysis tool, 143 text boxes, 563–565
formula auditing
Error Checking feature,
353–358
Evaluate Formula feature,
358–359
overview, 347–348
Trace Dependents option,
352–353
Trace Precedents option,
349–352
Formula AutoComplete
feature, 50