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

Index 767
managing, 329–330 row headings, creating
from, 328–329
range operator, 306 read-only files, 190 Read-Only Recommended
check box, 436 rearranging order of
worksheets, 251–252 Recalculate Workbook
before Saving
calculation option, 336 recalculation of formulas,
48, 334–336
RECEIVED function, 387 Recent Places button, Open
dialog box, 188 Recent Workbooks list,
Open screen, 184 recommended charts, inserting, 518–519
Recommended PivotTables button, 668, 670–672
Recommended PivotTables dialog box, 671
Record Macro button, Status bar, 34
Record Macro dialog box, 711, 712–714
recording macros, 710–715 records in data lists
adding new, 581–586 with duplicate fields,
eliminating, 586–587 editing in data forms, 584 finding with data forms,
584
overview, 577–578 sorting records on fields,
588–592
Redo command, 26,
191–193
reduced gradient, 666
reference functions COLUMNS, 417–418 list of, 417
overview, 409
ROWS, 417–418 TRANSPOSE, 418–419
reference operators, 306 Reference text box, Go To
dialog box, 132, 133 references, circular, 336–338 Refresh option, 642 regional date settings, in
Windows, 362–363 regrouping graphics, 552 Related Dates area, Info
screen, 19
Related People area, Info
screen, 19 relationships between
tables in data
models, 623 relative cell addresses,
312–313
relative cell references
changing to mixed, 318 converting to absolute,
314–315
for macros, 711
Remember icon, 9 Remove Arrows option,
347–348 Remove Background
option, 559, 560 Remove Duplicates
option, 641 renaming
modules, 724
worksheets, 248–249 repairing corrupted files, 190 Replace feature, 219–221,
727–728
replacing cell contents, 191 Report Filter fields,
filtering, 681–682
Report Layout option, 677 reports
previewing, 274–276 Solver add-in, 665–666 summary, for scenarios,
656–657
visual, creating with
Power View add-in,
703–705 repositioning buttons
on Quick Access
toolbar, 42 Research Options dialog
box, 226
Research pane, 225, 226 Reset Ignored Errors
button, 355
Reset Picture option, 559 Reset to Match Style
option, 529
Reset Window Position
button, 256
Resize the Table option, 641 Resolve Conflicts dialog
box, 480
Review tab, Ribbon, 23 reviewing workbooks
online, 499 Ribbon
cells, formatting from, 143–147
commands from, adding to Quick Access Toolbar, 42–43
components of, 21–22 custom tabs for macros,
718–719 customization of, 61–66 Developer tab, adding,
24, 711
font options, 162–163 inserting charts from,
519–520