R1C1 reference style, 431–432
RADIANS function, 980
RAND function, 500, 574, 851, 980
RANDBETWEEN function, 500, 576, 980
random-number sets
generating, 553, 574–579
troubleshooting, 575
random numbers, 500
range operators (:), 458
ranges. See also cell ranges; named references
array, 468
conditional formatting, 287
consolidation, 711
Descriptive Statistics tool, 569
names, 12–13
new and changed features, 12–13
rank-and-percentile functions, 555–558, 573–574
rank-and-percentile tables, 553
Rank And Percentile tool, 573–574
RANK function, 557–558, 980
RATE function, 540, 980
rates
arguments, 536
hurdle, 536, 540–541
internal rates of return, 540–541
modified internal rate of return, 541
security interest rates, 544
read-only files
opening, 65
previously-shared workbooks, 798
publishing tables to SharePoint sites, 819
SharePoint files, 808
readability and worksheet design, 117–118
reading IRM-protected documents, 803
real estate regression analysis, 563
rearranging fields in PivotTables, 716–721
recalculation
calculating portions of formulas, 463–464
interrupting, 460
iterative calculations, 466
manual process, 461–462
stopping, 461
RECEIVED function, 546, 980
recent workbooks, 46
recognizers, 229
recoloring
objects, 385
pictures, 369, 381
recording macros. See macros
records
databases, 122
duplicated in filtering, 698–699
filtering for mail merge, 903
grouping in Query, 776
sorting for mail merge, 904
sorting in Query, 763–764, 768–769
recovering data. See also troubleshooting
after crashes, 79–82
AutoRecover feature, 79–80
charts, 67
Dr. Office, 80–81
Excel Web site, 82
formatting, 67
Office Diagnostics program, 80–81
product support, 82
repairing files, 65, 66–67
using links, 67
red triangles, 251
redemption values of securities, 544
redoing actions, 206
#REF! error, 438, 682
reference functions, 512–520
reference operators, 458
references. See cell references; named references
references to other worksheets, 250–251
reflections, 370, 371
refreshing
external data, 747–748, 750
imported XML data, 757, 758
PivotTables, 721
Web queries, 780, 784
regional settings, 755
regions. See also worksheets
active areas, 125
defined, 125
jumping to, 132, 133
keyboard shortcuts, 128
navigating to, 126–127, 128
selections, 131, 134
registering Excel 2007, 21–22
regression analysis
creating, 553
exponential, 566–567
future values, 567
linear, 559–566
multiple, 560
real estate example, 563
standard errors, 566
trendlines, 660
regression sum of squares, 561
regrouping objects, 387
reinvestment rates, 536
rejecting changes, 797
relationships
queries, 761–762
SmartArt graphics, 359
relative cell references
computed filter criteria and, 695–697
copying, 432
defined, 429–430
ignoring, 452
in linked workbooks, 476–477
macros and, 832
in names, 448
relative values in conditional formatting, 285
remainders from MOD function, 499
remote computers, 789–790. See also collaboration
removed commands in Excel 2007, 907–925
removing. See also clearing; deleting
array assignments, 469
AutoFilter menus, 273
automatic table features, 273
buttons from toolbars, 85
cell names, 444
chart gridlines, 628
chart titles, 621–622
conditions in conditional sums, 480
data labels, 652
duplicate filtered records, 698–699
error flags in cells, 582
filters, 686, 762
formatting, 273
hyperlinks, 192, 876, 880
keyboard shortcuts, 936, 941
links to objects, 888–889
links to workbooks, 476
page break settings, 420–421
print area definitions, 413–414
print title definitions, 414
query criteria, 773
query fields, 767
scenarios, 593
SharePoint tasks, 813
subtotals, 725
table formatting, 273, 706
tables from queries, 766
undoing deletions, 200
workbooks from sharing status, 797, 798
rendering data, 881–882
renumbering objects in collections, 838
repairing corrupted files, 65, 66–67
repeating rows or columns on printouts, 414
REPLACE function, 506–507, 980
REPLACEB function, 981
replacing
cell references with names, 451–452
formatting, 223–224
formula elements with meaningful names, 699
text, 228, 506–507
replicating formulas in tables, 667, 672
reports
best uses of, 598
PivotTable fields and, 717, 722
scenarios, 589, 595–599
REPT function, 981
"reputable developers," 103
requesting permission to open IRM documents, 806
research resources, 18, 234–236
resetting
chart elements to original position, 635
object formatting adjustments, 385
original chart appearance, 631
original page breaks, 420
picture adjustments, 369
SmartArt options, 360
window positions, 171
residual sum of squares, 561
resizing
chart text, 629, 641–642
charts, 617
pages for printing, 405
shapes, 346–347, 354
shapes proportionally, 390
SmartArt, 360
text boxes, 352–353
text in shapes, 383
workbook windows, 29–30
worksheets with shapes, 390
resolution
pictures, 373
printing, 404
resolving conflicts in shared workbooks, 791–792, 794
restoring
chart elements to original position, 635
object formatting adjustments, 385
original chart appearance, 631
original page breaks, 420
pictures, 369
SmartArt options, 360
window positions, 171
restricting permissions. See permissions
result sets
fields not in, 774
filtering, 769–770
Query, 764, 766
results ranges, 585
returning to Excel, 778–779
sorting, 768–769
results-oriented user interface, 4–5
results ranges, 585
resuming
after error handlers, 868
iterations, 600
retired features, summary of, 16–18
retrieving files from remote computers, 789–790. See also collaboration
Revenue Scenarios.xlsm file, 589
Review tab commands and options, 907, 908, 911, 912, 914, 916, 922, 923
reviewing
changes, 794, 797
distributing files by e-mail, 800–802
highlighting changes, 795–796
Send For Review command, 802
Ribbon. See also toolbars
commands and options, 907–925
contextual tool sets, 36–37
customizing, 88, 95
Dialog Box Launchers, 32–34
drop-down lists, 32–34
editing VBA code and, 95
File menu and, 37–38
formatting graphics, 368–371
formula bar, 42–43
graphic tabs, 347
hiding, 31
hiding formula bar, 42
illustrated, 31
keyboard command mode, 39–40
keyboard shortcuts, 942
live preview, enabling, 95
macros and, 95
Microsoft Office Button and, 37–38
Mini toolbar, 42
mini version, 88
ScreenTips, 32
self-documenting features, 31–32
shortcut menus, 41–42
status bar, 44–45
RibbonX model, 92
rich text formatting (RTF), 783, 893, 894, 895
RIGHT function, 506, 981
RIGHTB function, 981
Rights Management Services (RMS), 803
ROMAN function, 981
rotating
3-D, 380
chart text elements, 627–628
pictures, 370
shapes, 354, 371
ROUND function, 500–501, 851, 981
ROUNDDOWN function, 500–501, 981
rounded values
compared to rounding functions, 501
Solver add-in, 606
troubleshooting, 467
ROUNDUP function, 500–501, 981
row differences, selecting, 135–136
ROW function, 519, 982
rows (array), 473
rows (chart), 618–619
ROWS function, 520, 982
rows (table)
adding to PivotTable data, 715
hiding PivotTable labels, 724
implicit intersection, 700–701
inserting, 667, 671–672
new and changed features, 9
number of, 9
organizing, 669
selecting, 673
totals, 673–675, 701–702, 704
rows (worksheet)
AutoFill feature, 216
AutoFit feature, 335
banding, 271, 706, 708
cell references and, 431–432
charting hidden, 658
current, 702–703
deleting, 198–202, 272
design guidelines, 117–118
displaying or hiding, 944
duplicated, 698–699
extracting with filters, 689, 697–698
filtering, 684, 689–699
header, 269–271, 676–677, 704
headings, 96, 98, 414–415
height, 334–335, 336
hidden, 337, 658, 692
inserting, 194–196, 272
keyboard shortcuts, 940, 944
letters, 25
in mail merge data, 901
printing on each page, 414
resizing in Page Layout view, 406
returning identifiers, 519
returning numbers of, 520
selecting, 944
sorting, 675–677, 679–680
special item specifiers, 458
starting rows for imports, 751
summary, 270–271
using in names, 452
VLOOKUP and HLOOKUP functions, 513
RSQ function, 982
RTD function, 982
RTF (rich text formatting), 783, 893, 894, 895
rulers, 406
rules in conditional formatting, 290–294
run-time errors, 866–869
running
choosing applications to open files, 887
code step-by-step, 862–863
code to cursor points, 862
macro subroutines, 844–845
macros, 832
running heads or footers, 408–412
running totals, 733