Excel 2010: The Missing Manual

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

R1C1 addressing

R1C1 references

radar charts

RADIANS( ) function

RAND( ) function

RANDBETWEEN( ) function

range operator

ranges

        multiplying two

        selecting continuous range of cells

RANK( ) function

RATE( ) function

rates 2nd [See also RATES( function)]

        interest, monthly versus annual

raw data, transferring

recalculation, controlling

RECEIVED( ) function

Record New Macro command

Redo

        using to automate repetitive tasks

reference functions

        defined

Refresh Data command

regedit

regional dates

regional settings and date/time formats

Registry Editor

relative cell references

relative reference mode (recording macros) 2nd

Remove All Arrows command

Repeat command

repetitive tasks, automating

Replace All option

Replace command

Replace option

REPT( ) function

Research task 2nd 3rd 4th

Restrict Permission As command

review chain

        routing slips

        routing workbook to multiple people

                Send it to a specific reviewer

                Send it to everyone

                Send it to the next recipient in the list

        sending workbook by email

        sending workbook for review

        setting up

Reviewing toolbar 2nd

        Hide a comment

        Hide all comments

        Show a comment

        Show all comments

        Step through your comments

Right (Indent) (cell appearance formatting)

RIGHT( ) function 2nd

ROMAN( ) function

rotating content

ROUND( ) function 2nd

        versus Round( ) function

Round( ) function

        versus ROUND( ) function

ROUNDDOWN( ) function

rounding functions

rounding numbers

        downward

ROUNDUP( ) function

routing slip

Routing Slip dialog box 2nd

Row command

ROW( ) function

rows

        changing into columns

        deleting

        formatting in grouped worksheet

        freezing

        grouping

        hiding

        identification

        inserting

        maximum number

Rows command

ROWS( ) function