Excel 2010 Bible

979 Index Import Data dialog box, 687 Import/Export button, 545 importing, 679–680. See also external database file data IMPOWER ...

980 Index Web sites contextures, 948 daily dose of Excel, 948 David McRitchie’s Excel Pages, 948 Jon Peltier’s Excel Page, 948 M ...

981 Index letter grades for test scores, 322 levels, outline, 588 Life argument, 351 Light style category, tables, 103 line char ...

982 Index determining letter grades for test scores, 322 exact values, 318–319 HLOOKUP function, 313–314 looking up values by us ...

983 Index Merge Across option, 125 Merge Cells option, 125 Merge command, Ribbon, 14 Merge Conditional Formatting (G) option, 86 ...

984 Index moving cells and ranges adjacent cells, 82–83 drag-and-drop, 81–82 Office Clipboard, 84–85 to other sheets, 83 overvie ...

985 Index NEGBINOMDIST function, 918 NEGBINOM.DIST function, 930 nesting parentheses in formulas, 198 network server, 157 NETWOR ...

986 Index examples of dates and times, 566 filling cells with repeating characters, 568 fractions, 564–565 leading zeros, 564 ne ...

987 Index Options button, Clipboard task pane, 84 Options dialog box. See Excel Options dialog box; Solver Options dialog box Or ...

988 Index pasting links, 590 Path property, 896 Patterned distribution option, Random Number Generation dialog box, 790 Payment ...

989 Index grouping items manually, 717–718 non-numeric data, 715–717 overview, 695–696, 715–717 pivot charts example of, 736–738 ...

990 Index procedure arguments function with no argument, 829 function with one argument, 829–831 function with range argument, 8 ...

991 Index customizing adding new commands, 543–545 overview, 17–19, 541–542 making macros available on, 855–856 overview, 6–7 Qu ...

992 Index reading comments, cells, 96 ReadMe file, 942 read-only permission, 628 read-only property, 815–816 Read-Only Recommend ...

993 Index result_vector argument, LOOKUP function, 315 returning errors, 653 reverse pivot table, 731 reverse pivot.xlsm sample ...

994 Index workbooks containing macros, 798 overview, 147–148, 896 worksheets as PDF files, 645–646 Scale with Document check box ...

995 Index shape examples.xlsx sample file, 939 Shape images adding hyperlinks, 611 adding text to, 520 aligning and spacing, 523 ...

996 Index eliminating intermediate formulas, 374–376 finding row of value’s nth occurrence, 385 overview, 357–358 ranking data, ...

997 Index overview, 503 specifying date axis, 512–513 types of, 504–505 special characters, inserting, 233 Special format catego ...

998 Index function of, 928 overview, 282 ranges with error values, 379–380 single array formula, 358 summing all cells in range, ...