Index_R

R

range references 106

ranges

active cell , identifying 106

cell formatting in 125

cutting and pasting 135

deselecting 106

inserting in formulas 122

named, in calculations 128

naming 120, 121

naming conventions 122

references. See range references

selecting 105 “6

ranges, worksheet, naming 120

reading e-mail messages 288

reassigning tasks 342

record selector 218, 224

records 212

creating 218

deleting 224

entering in tables 218

finding 236

selecting 224

selector. See record selector

sorting 239

records, form, entering 249

records, table

copying, between tables 243

finding 260, 264

moving 266, 268

saving changes to 263

selecting fields from specific 260

updating 266, 267

recurring

appointments, canceling 322

appointments, converting from regular appointments 316

appointments, converting to regular appointments 322

appointments, creating 316

appointments, editing 321

appointments, scheduling 315

events, editing 321

events, editing single

occurrence of 321

events, scheduling 318

meetings, scheduling 328

tasks, creating 333

recycling Office information 350

Redo button (Standard toolbar) 23

redoing 23

multiple actions 32

references, range. See range references

references, absolute. See absolute references

references, relative. See relative references

referencing formula cells in other formulas 120

referential integrity

enforcing 252

in table relationships 249

testing 253

refining searches 57

relative references 142

reminders

setting, for appointments 314

setting, for events 318

setting, for tasks 333

removing. See deleting

renaming worksheets 136

reordering slides 178

repeating styles 88

repeating the Find command 56

replacing

editing document during 56

formatting 56

text 21, 42, 43, 53, 56

text, automatically. See AutoCorrect

words 22

replying to e-mail messages 291 “92

Report Wizard 272

reports 270

creating 270 “72

customizing 274

layout, selecting 274

mailing labels, creating with 274

opening 275

print preview and 272

zooming 271

repositioning

text areas 166

title area 166

Required Entry property 229

rescheduling appointments 320

resizing. See also sizing

columns 194

text areas 166

worksheet columns 114

worksheet rows 115

resources scheduling 327

responding

to e-mail messages 291 “92

to meeting requests 327 “28

to task requests 342

restoring

deleted appointments 322

menus / toolbars , to original settings 32

restricting searches 54

restructuring tables 227

retrieving e-mail messages 289

revising. See editing

Rich Text format 286

RIGHT functions 139

right-aligning text 25

right-clicking 2

toolbars 12

rotating axis titles 197

rows

height, changing 223

sizing 223

rows, table

deleting 92

inserting 95, 254

moving 92

selecting 93

width, changing 90

rows, worksheet 99

deleting 112

height, adjusting 115

inserting 111

selecting all cells in 106

Ruler command 200

rulers

displaying temporarily 10

turning on/off 9, 10, 200

running

queries 259, 262 “63, 265

wizards 67