Index RI TE MA D TE GH RI PY CO absolute references, formulas, 212, 393 Accept Changes dialog box, 67 active cells, 13 add 3-D effect, objects, 252 borders to cells, 114–115 cells, 118–119 columns, 17, 140 comments, worksheets, 19 decimals, 25 footers, 282–283 headers, 282–283 misspellings, 102 rows, 304 shadows, 252 subtotals, 170–171 Watch Window, 354–355 worksheets, 374 add-ins about, 2 Analysis ToolPak, 90 Data Analysis tools, 92–93 find, 91 install, 2, 90–91 load, 90–91 remove, 91 Solver, 90, 94–9
Cells, 13 cells add, 118–119 addresses, 13 data alignment, 96–97 delete contents, 184–185 delete formatting, 184–185 freeze, 218–219 insert comments, 144–145 Name box, 51 references, 13 unfreeze, 218–219 Center alignment command, 3 center data, 248–249 change background, worksheets, 376 chart type, 125 default file locations, 146 default font, 147 elements, charts, 124 fields, PivotTables, 280 page orientation, 284 PivotTables to PivotChart, 279 position, objects, 254–255 records, database, 176 style, numbe
Index Custom tab, 64 Custom View, 22 Custom View dialog box, 22 custom views, 352–353 Custom Views dialog box, 353 Customize, 23 customize AutoCorrect, 103 AutoFill, 105 AutoShapes, 111 cell comments, 144–145 change default file locations, 146 change default font, 147 charts, 388 create new menu, 148–149 desktop themes, 389–391 dialog box, 23 menus, 152–153 new toolbar, 150–151 program windows, 154–155 Taskbar, 380 Text to Speech tool, 339 toolbars, 156–157 tracking, 345 Cut button, 24 Cut command, 20, 24,
E e-mail about, 28 attachments, 28 worksheets, 192–193 edit database records, 176–177 functions, 223 hyperlinks, 231 Edit menu Copy, 20 Cut command, 24 paste, 57 Edit Web Query dialog box, 259 elements, chart, 389 Embed command, 29 embed objects in worksheet, 194–195 embedded Uniform Resource Locators (URLs), 44 encyclopedia, 66 equal sign, 39 Equal To option, 94 erase border lines, 117 Error Checking feature, 4, 196–197 errors checking, 98–101 checking tools, 4 fix, 196 messages, 99 Remove Precedents butto
Index Format Picture dialog box, 134 format styles, 8 Formatting toolbar, 50 Formula Auditing toolbar, 4, 37, 84 Formula bar, 65 formulas about, 392 absolute references, 212, 393 construct, 214–215 construct arguments, 394 copy, 216 functions, 394–395 operator precedence, 390 operators, 391, 392 problems, 393 reference cells, 393 reference cells from other worksheets, 217 relative references, 213, 393 structure, 392 freeze cells, 218–219 panes, 218 Freeze command, 38 Freeze Panes, 38 Freeze Panes command, 7
L languages, spelling, 327 layer objects, 259 Legend button, 14 line charts, 389 line color Drawing toolbar, 27 formatting, 208 set, 236–237 Line Color button, 134 line style formatting, 209 set, 238–239 Line Style button, 134 line thickness, 27 linear charts, 14 lines Drawing toolbar, 27 formatting, 208–211 link about, 48 data, 240–241 load add-ins, 90–91 locate files, Temp folder, 384–387 lock columns, 38 rows, 38 M Macintosh, 30 Macro dialog box, 49 macros about, 49 create, 242–243 manage, 244 run, 245
Index P Page Break Preview, 55 page breaks about, 55 views, 351 page margins, set, 246–247 Page Setup dialog box, 42, 56 Page tab, 56 panes freeze, 218 unfreeze, 219 passwords, assign workbook, 296–299 paste copy attributes, 266–267 data, 160–161 Paste Special command, 266–267 Paste button, 57 Paste command, 20, 57 Paste Special command, 266–267 Paste Special dialog box, 48 Patterns tab, 31 Percent Style, 18, 57 Picture toolbar, 60 pictures about, 59 crop, 268–269 format, 270–271 insert files, 272–273 pie c
resize columns, 143 objects, 261 rows, 307 restore files, 387 review changes, tracking, 343–344 Reviewing toolbar, 67 rotate data, 164–165 objects, 262 ROUNDUP functions, 183 rows about, 17, 68 add, 304 delete, 305 freezing, 38 hide, 306 print headings, 291 resize, 307 select, 321 subtotals, 75 run macros, 245 Web Query, 356–359 S save about, 69 file to default location, 308–309 Web Query, 359 workbooks, 310–311 worksheets as Web pages, 312–313 Save As dialog box, 30, 69 scatter charts, 121, 389 Scenario M
Index T Task Manager about, 378 force-quit application, 379 Shut Down menu, 379 view system, 378 Task Pane, 77 task panes close, 33 display panes, 332 reopen, 333 Taskbar customize, 380 hide, 380 move, 381 remove, 382 Telnet client, 382–384 Temp folder locate files, 384–387 manage files, 384–387 templates about, 78 apply, 334–335 create, 336–337 Templates dialog box, 78, 335 Templates folder, 78 temporary Internet files, 387–389 text boxes, draw, 190–191 Text to Speech tool, 79, 338–339 Text to Speech toolb
create, 367 delete, 368 delete sheet, 378 open, 369 open automatically, 370 open folder automatically, 371 print, 290 save, 310–311 sharing, 347, 372–373 worksheets add, 374 adding comments, 19 change background, 376 change tab colors, 375 copy, 377 e-mail, 192–193 hide, 379 hide gridlines, 384 move, 380 name, 381 print, 290 protect, 382–383 save as Web pages, 312–313 select cells, 320–321 show gridlines, 384 spelling, 326 split, 385 X XLS file extension, 69 Z Zoom button, 63, 87 Zoom dialog box, 87, 386
