Page 360 - Excel Workbook for Dummies
P. 360
43_798452 bindex.qxp 3/13/06 7:42 PM Page 343
Index 343
fill color button, 26 Formatting toolbar
Fill handle displaying, 27
copying a formula with the, 19–20 formatting cells with the, 26–27
creating data series with the, 310–311 Formula Auditing toolbar, 102, 102–104
entering data with the, 18–19 Formula bar for data entry, 16
Filter Data dialog box, 218–219 formula errors, 101–104
filtering records in a data list, 214–216 formulas
financial functions, 115–116 alternate calculations in, 153–155
Find (Ctrl+F), 66 alternate values in, 150–153
Find and Replace array, 313–314
(Ctrl+H), 66 building arithmetic, 75–76
editing with, 66–68 building array, 99–101
finding records with the data form, 206–207 building with built–in functions, 78–81
Fit To Scaling option, 43 building with common date functions, 109–111
floating toolbar, 65 building with common time functions, 112–113
font building comparative, 76–77
color button, 26 building with a custom function, 302–303
customizing settings for headers/footers, 41 building with date functions in the Analysis
drop-down buttons, 26 ToolPak, 111–112
tab on the Format Cells dialog box, 28 building with external links, 84–86
Font dialog box for headers/footers, 41 building by hand, 74–78
Footer dialog box, 41 building with nested IF functions, 155–156
footers/headers building overview, 73–74
adding custom, 39–41 building using summing functions, 129–131
inserting codes in, 40–41 circular references in, 104–105
Format Cells dialog box copying with absolute cell references, 91–92
alignment tab on the, 30–31 copying with AutoFill, 20
applying number formats with the, 28–30 copying with mixed cell references, 92–96
conditional formatting and the, 33–34 copying with relative cell references, 89–91
formatting cells with the, 26–31 copying using the Fill handle, 19–20
number tab on the, 29 creating range names in, 96–99
opening with Ctrl+1, 28 date, 107–112
options on the, 27–28 decision-making, 149, 150–156
Format menu displaying with the Options dialog box, 47
hiding columns/rows using the, 34–35 editing, 81–82
resizing columns with the, 24 error-trapping, 156–159
resizing rows with the, 25 finding the source of error values in, 102–104
Format Painter modifying the recalculation mode of, 86–87
copying formatting to multiple cells with, 32 operator precedence in, 82
formatting cells with the, 32–33 overriding with the $ sign, 19
overview, 31 overriding calculation order in, 82–84
Format Tab Color dialog box, 14 placement of in a two-variable data table, 236
formatting printing spreadsheet, 46–47
cells with the alignment tab, 30–31 text, 161–164
cells with the Format Cells dialog box, 27–31 with text functions that join data entries and
cells with the Format Painter, 32–33 change their case, 165–167
cells with the Number tab, 29–30 text that join data entries, 162–164
charts, 180–182 that perform horizontal lookups in a table,
conditional, 33–34, 312 143–144
hypertext, 279 that perform vertical lookup in a table, 145–146
modifying in a pivot table, 250–251 time, 107–109, 112–113
removing with Ctrl+Z, 33 using the Lookup Wizard to build ones that per-
shortcut keys, 319 form two-way lookups in a table, 147–148
a table with AutoFormat, 32–33 versus array formulas, 313–314
techniques, 26–34
