R

RAND function, 464

RANDBETWEEN function, 464

Range object, 1102–1103

ranges. See cell ranges

reading

encrypted messages, 718

VBA code, 1079–1080

XML, 1145–1146

Reading Pane

encrypted messages unavailable in, 719

IRM messages on InfoBar, 723, 724

viewing external content for messages in, 686, 687

recalculations, 427

record indicators for subdatasheets, 946

Record Macro dialog box, 1078

Record Number box, 940–941, 942

record source, 976

recording macros

in VBA, 1077–1079

writing vs., 1081–1082, 1085

records

adding subdatasheet, 947

finding and replacing subdatasheet data, 950

limiting number of returned query, 966

maximum disk space for, 901

viewing relative number of current, 940

recordsets

about, 903

defined, 970

selecting query fields in, 907–909

sorting query output data in, 934–936

specifying query selection criteria, 911–912

recovering

data in PowerPoint, 543

from Office startup errors, 663–665

Redo button, 361

Redo command (Access), 769, 770

references. See cell references; relative references; structured references

referential integrity, 884, 885, 886

refreshing PivotTables, 495

regions

defined, 341

illustrated, 342

selecting, 347

rehearsing slide shows, 613–614

relationships among tables, 881–888

creating on multiple fields, 886–888

defining

first relationship, 883–886

in Relationships window, 882–883

dragging links to define, 883–884

enforcing referential integrity in, 886

setting up for primary keys, 882

Relationships window

creating relationships among multiple fields, 886–888

defining relationships in, 882–883

dragging links to define table relationships, 883–884

opening tables in Design view from, 888

Show Table dialog box displays first time, 883–884

relative references

copying, 398, 399

defined, 395

R1C1 reference style, 397–398

using in named formulas, 414

.rels files

about, 1151

content of, 1154–1156

creating, 1160–1161

opening in Internet Explorer, 1155

_rels folders

about, 1151, 1152

Open XML document requirement for, 1156

removing

backgrounds, 261–262

borders, 277, 281

comments from ZIP packages, 1173–1175

control layouts, 1059

document backgrounds, 261–262

hidden data, 62–64, 613

highlighting, 306

members from workspace, 172

Office from computer, 1196–1197

outline formatting, 245–246

page breaks in outline, 251

passwords, 71

personal information from files, 60, 61–65, 623

Quick Access Toolbar commands, 770, 771–772, 776

SharePoint files and folders, 756–757

text box in series of text boxes, 273

tracked changes, 62, 64–65

trusted locations, 53, 607–608

watermarks, 261–262

renaming

files with .zip extension, 1149

hidden object shortcuts, 811–814

notebook sections, 97

PivotTable fields, 498

table template fields, 854

VBA projects, 1128

worksheets, 364

reordering animations, 578

REPLACE function, 470

replacing. See finding, and replacing

Report command, 1037–1039

Report Wizard, 1039–1052

about, 1039

adding report title, 1044–1045

built-in styles for, 1044

choosing fields from multiple tables or queries, 1040

illustrated, 1040

layout styles and report orientation, 1043–1044

modifying reports from, 1046–1052

previewing report in, 1045–1046

selecting report fields, 1040

setting report grouping intervals, 1041–1042

specifying field sorting criteria, 1042, 1043

summary options for, 1042, 1043

verifying primary grouping criteria, 1041

reports, 1019–1071.

See also formatting, reports; Group, Sort, And Total pane

Design view, 1021–1023

adjusting footers, 1034

building report queries, 1020–1021

column labels in, 1032–1033

configuring totals in, 1028

defining grouping specifications, 1023–1025

finishing, 1031–1036

footers, 1029–1030

inserting controls in, 1033–1034

modifying Report Wizard reports, 1045

printing options for groupings, 1030

setting group intervals, 1027–1028

specifying line spacing in, 1034

titles in, 1028–1029

forms vs., 1023

layout options for PivotTables, 496

Layout view, 1052–1071

adding record totals, 1066–1069

AutoFormats in, 1069–1071

control layouts in, 1059–1066

grouping and sorting in, 1054–1058

previewing reports, 1070

starting with blank report, 1052–1054

usefulness of, 1059

page numbers for, 1035–1036, 1068

previewing, 1036, 1045–1046, 1070

quick, 1037–1039

Report Wizard, 1039–1052

about, 1039

adding report title, 1044–1045

alternating background colors, 1050–1051

built-in styles for, 1044

changing properties in, 1049–1050

choosing fields from multiple tables or queries, 1040

editing labels on, 1047–1049

illustrated, 1040

modifying reports created in, 1046–1052

previewing report in, 1045–1046

report layout and orientation, 1043–1044

selecting fields, 1040

setting group intervals, 1041–1042

specifying sorting criteria, 1042, 1043

summary options for, 1042, 1043

total options in, 1042–1043

verifying primary grouping criteria, 1041

sample files for, 1019

using in presentation, 604

Reset button (PowerPoint Options dialog box), 525

Reset Customization dialog box, 775

Reset Window Position button, 385

resizing

Function Arguments dialog box, 455

lines, 293

report columns, 1046–1047, 1049

report fields, 1046–1047, 1059–1062

slide images, 566, 626

text box controls, 1059

text boxes and AutoShapes, 269–270

Resolve Name Conflict dialog box, 191

resolving proposed edits, 330–334

accepting or rejecting all, 332–333

combining multiple revisions, 336–338

comparing document versions with proposed edits, 334–336

saving document before, 331

setting viewing properties for, 331–332

Resources category (Access), 838–839

Response form (Groove), 159, 160

restoring

cell content, 361

deleted datasheet rows, 952

split worksheet to one, 368

workspace from archive, 204

Restrict Formatting And Editing task pane, 311–312

resuming workspace communications, 180

reverse book fold page settings, 222

Review tab (Word), 302, 303–304

reviewers

allowing comments without editing, 311–312

combining revisions from, 336–338

comment color for, 310–311

configuring names of, 309–310

ScreenTips revealing name of, 319

Reviewers menu, 331

reviewing comments, 318–319

Reviewing pane

changing font styles for, 315

deleting text in, 314

illustrated, 308

tracking changes in, 326

using, 307

revising documents, 301–338.

See also comment balloons;

resolving proposed edits

comments, 307–323

allowing without editing, 311–312

applying text highlighting, 305

finding highlighted items, 306

inserting, 313–314

printing, 321–322

removing highlighting, 306

revealing information in ScreenTip, 319

reviewing, 318–319

saving in documents as Web page, 322–323

voice and handwritten, 314

comparing and combining documents, 334–338

markup tools for, 302–304

tracking changes, 323–334

accepting and rejecting edits, 330–334

configuring appearance of changes, 327

customizing changed line appearance, 329–330

display for insertions and formatting, 328

limiting editing to only tracked changes, 327

moved text and inline shapes, 329

options for display, 323–324

printing marked-up documents, 333–334

saving before resolving edits, 331

showing revisions in tables, 329

viewing properties for resolving edits, 331–332

while editing, 325–327

using Highlight tool, 304

viewing revision history, 338

Revision Marks feature. See tracking, changes

Ribbon, 28–31.

See also Quick Access Toolbar

about, 6–9, 22

Access, 763, 766, 783–787

Controls group buttons, 978–982

Create tab, 784–785

Database Tools tab, 786–787

External Data tab, 785–786

Form Design Tools contextual tabs, 977–978

Home tab, 784

accessing Quick Access Toolbar from, 33

adding group to built-in tab, 1180–1182

command tabs on, 28–30

contextual tabs on, 7, 25, 36–37

customizing, 1175–1182

Function Library group on Formulas tab, 460

illustrated, 7, 23

innovations of, 630

menus and toolbars replaced by, 27

minimizing, 31, 787

Outlook’s use of, 630–631

PowerPoint

locations for commands, 521–523

two Design tabs, 539

Primary Key button on, 874–875

quick create form commands on, 1000–1003

screen resolution and size, 30

variations in, 384

RIGHT function, 470

Rights Management Add-On for Internet Explorer, 720

rights-managed content. See IRM (Information Rights Management) service

RMS (Rights Management Service), 720

roaming profile, 652

roles

changing permissions for Groove, 88, 147, 176

Groove member, 140–141, 146–147

Manager, Participant, and Guest, 173

rotating text in text box, 548

ROUND function, 464

ROUNDDOWN function, 464

rounding

formats vs. functions for, 465

functions for, 464–465

rounded value miscalculations, 433

ROUNDUP function, 464

ROW function, 483

row selector (Datasheet view), 941

row-column reference style, 397–398

rows

changing sequence in database, 952

database limitations for, 901

Datasheet view of, 941

deleting subdatasheet, 952

finding cells by Row Differences options, 351–352

inserting in Indexes window, 890

lookup functions for, 483–484

selecting Excel, 345–347

specifying sort criteria for query, 936

working with data in, 849–851

ROWS function, 484

RSS downloads, 688–689

rulers

displaying Word, 220

dragging margin indicators on, 210

selecting controls with, 998

rules.

See also validation rules

based on alerts, 747–749

formula-naming, 411

managing e-mail with, 684

Rules And Alerts dialog box, 744

Run Compatibility Checker command, 34

RUNAS command, 669–670

running custom slide shows, 617

Running Total custom calculation, 507