Index
default tools, 17, 196
displaying below the Ribbon, 17
full-screen mode, 195
macros, adding, 935, 979
moving, 196
Redo button, 17
tools included, 196
Undo command, 17, 18
Quick Access Toolbar tab, Excel Options dialog box,
198–200
Quick Print, 173
R
radar charts, 478–479
RAND function, 601
Random Number Generation dialog box, 763–765
random number generation tool, Analysis ToolPak,
763–765
Range object, 940–941
ranges. See also cells
copying, 81–82, 1012–1013
to adjacent cells, 86
to the Office Clipboard, 87–89
to other worksheets, 87
paste options, 89–93
using drag-and-drop, 85–86
using Paste Options buttons, 84–85
using Ribbon commands, 82
using shortcut keys, 83–84
using shortcut menu commands, 83
using the Paste Special dialog box, 90–93
using VBA, 1012–1014
counting
characters in, 416–417
selected cells, 1019–1020
text cells in, 418–419
values in, 250–251
defined, 71
determining type of selection, 1018–1019
icon sets, assigning, 135–136
looping through, 1015–1016
moving, 81–82, 1015
named styles, 143–146
names, 93
advantages, 93
creating, 94–97
deleting, problems with, 428
managing, 97–98
pasting into formulas, 216
non-intersecting, 428–429
prompting for cell values, 1016–1017
range intersections, 234–236
reference operators, 234–236
selecting, 72
complete rows and columns, 73
multisheet ranges, 74–77
noncontiguous ranges, 73–74
by searching, 79–81
special types of cells, 77–79
selecting row/column, 1014
selecting to end of row/column, 1014
summing three smallest values, 417–418
rank and percentile tool, Analysis ToolPak, 765
RANK function, 374–375
rate argument
PMT function, 345
PV function, 355
rearranging
columns, 600–601
Ribbon tabs, 203
Recent command, 154, 155
Recommended Charts command, 467
Recommended PivotTables command, 662–663
recording macros, 924–935
absolute vs. relative recording, 929
adding macros to Quick Access toolbar, 935
assigning macros to buttons, 934–935
assigning macros to shortcut keys, 933–934
editing macros, 928–929, 931–932
example, 926, 929–930
recording actions, 925
running macros, 930
storing macros in Personal Macro Workbook, 933
testing macros, 928, 932
viewing code, 926–928, 930–931, 933
Redo button, 17
#REF! errors, 230, 429
reference argument, OFFSET function, 369
refresh schedules, of dashboards, 570
refreshing
Power Pivot data, 805–806
Power Query data, 844
worksheets, 653–654
regional settings, 34
Regression dialog box, 765–766
regression tool, Analysis ToolPak, 765–766Quick Access toolbar (cont inued)