##
A Aa Ab Ac Ad Ae Af Ag Ah Ai Aj Ak Al Am An Ao Ap Aq Ar As At Au Av Aw Ax Ay Az
B Ba Bb Bc Bd Be Bf Bg Bh Bi Bj Bk Bl Bm Bn Bo Bp Bq Br Bs Bt Bu Bv Bw Bx By Bz
C Ca Cb Cc Cd Ce Cf Cg Ch Ci Cj Ck Cl Cm Cn Co Cp Cq Cr Cs Ct Cu Cv Cw Cx Cy Cz
D Da Db Dc Dd De Df Dg Dh Di Dj Dk Dl Dm Dn Do Dp Dq Dr Ds Dt Du Dv Dw Dx Dy Dz
E Ea Eb Ec Ed Ee Ef Eg Eh Ei Ej Ek El Em En Eo Ep Eq Er Es Et Eu Ev Ew Ex Ey Ez
F Fa Fb Fc Fd Fe Ff Fg Fh Fi Fj Fk Fl Fm Fn Fo Fp Fq Fr Fs Ft Fu Fv Fw Fx Fy Fz
G Ga Gb Gc Gd Ge Gf Gg Gh Gi Gj Gk Gl Gm Gn Go Gp Gq Gr Gs Gt Gu Gv Gw Gx Gy Gz
H Ha Hb Hc Hd He Hf Hg Hh Hi Hj Hk Hl Hm Hn Ho Hp Hq Hr Hs Ht Hu Hv Hw Hx Hy Hz
I Ia Ib Ic Id Ie If Ig Ih Ii Ij Ik Il Im In Io Ip Iq Ir Is It Iu Iv Iw Ix Iy Iz
J Ja Jb Jc Jd Je Jf Jg Jh Ji Jj Jk Jl Jm Jn Jo Jp Jq Jr Js Jt Ju Jv Jw Jx Jy Jz
K Ka Kb Kc Kd Ke Kf Kg Kh Ki Kj Kk Kl Km Kn Ko Kp Kq Kr Ks Kt Ku Kv Kw Kx Ky Kz
L La Lb Lc Ld Le Lf Lg Lh Li Lj Lk Ll Lm Ln Lo Lp Lq Lr Ls Lt Lu Lv Lw Lx Ly Lz
M Ma Mb Mc Md Me Mf Mg Mh Mi Mj Mk Ml Mm Mn Mo Mp Mq Mr Ms Mt Mu Mv Mw Mx My Mz
N Na Nb Nc Nd Ne Nf Ng Nh Ni Nj Nk Nl Nm Nn No Np Nq Nr Ns Nt Nu Nv Nw Nx Ny Nz
O Oa Ob Oc Od Oe Of Og Oh Oi Oj Ok Ol Om On Oo Op Oq Or Os Ot Ou Ov Ow Ox Oy Oz
P Pa Pb Pc Pd Pe Pf Pg Ph Pi Pj Pk Pl Pm Pn Po Pp Pq Pr Ps Pt Pu Pv Pw Px Py Pz
Q Qa Qb Qc Qd Qe Qf Qg Qh Qi Qj Qk Ql Qm Qn Qo Qp Qq Qr Qs Qt Qu Qv Qw Qx Qy Qz
R Ra Rb Rc Rd Re Rf Rg Rh Ri Rj Rk Rl Rm Rn Ro Rp Rq Rr Rs Rt Ru Rv Rw Rx Ry Rz
S Sa Sb Sc Sd Se Sf Sg Sh Si Sj Sk Sl Sm Sn So Sp Sq Sr Ss St Su Sv Sw Sx Sy Sz
T Ta Tb Tc Td Te Tf Tg Th Ti Tj Tk Tl Tm Tn To Tp Tq Tr Ts Tt Tu Tv Tw Tx Ty Tz
U Ua Ub Uc Ud Ue Uf Ug Uh Ui Uj Uk Ul Um Un Uo Up Uq Ur Us Ut Uu Uv Uw Ux Uy Uz
V Va Vb Vc Vd Ve Vf Vg Vh Vi Vj Vk Vl Vm Vn Vo Vp Vq Vr Vs Vt Vu Vv Vw Vx Vy Vz
W Wa Wb Wc Wd We Wf Wg Wh Wi Wj Wk Wl Wm Wn Wo Wp Wq Wr Ws Wt Wu Wv Ww Wx Wy Wz
X Xa Xb Xc Xd Xe Xf Xg Xh Xi Xj Xk Xl Xm Xn Xo Xp Xq Xr Xs Xt Xu Xv Xw Xx Xy Xz
Y Ya Yb Yc Yd Ye Yf Yg Yh Yi Yj Yk Yl Ym Yn Yo Yp Yq Yr Ys Yt Yu Yv Yw Yx Yy Yz
Z Za Zb Zc Zd Ze Zf Zg Zh Zi Zj Zk Zl Zm Zn Zo Zp Zq Zr Zs Zt Zu Zv Zw Zx Zy Zz

##

1 Useful Links
2 Useful Links
2003, MS Excel 2003 Quick Reference MS Excel 2003 Quick Reference
3 Useful Links
3D-reference Cell References
4 Useful Links
5 Useful Links

A

A Useful Links
A1 reference style Cell References

AB

absolute cell reference Cell References
Absolute reference Editing Formulas

AC

active, directly refer to the active cell Excel Keyboard Shortcuts
active, F2 Edits the active cell Excel Keyboard Shortcuts

AD

add a new worksheet Managing Workbooks
adjacent Range

AL

Alignment tab Data Alignment
Alignment, Data Alignment Data Alignment
Alignment, Vertical Alignment Vertical Alignment
alphabetical, display named ranges in alphabetical order Useful Links

AP

Applies the Comma separated format Excel Keyboard Shortcuts
Applies the Currency format Excel Keyboard Shortcuts
Applies the Date format Excel Keyboard Shortcuts
Applies the Exponential format Excel Keyboard Shortcuts
Applies the General number format Excel Keyboard Shortcuts
Applies the outline border Excel Keyboard Shortcuts
Applies the Percentage format Excel Keyboard Shortcuts
Applies the Time format Excel Keyboard Shortcuts

AR

area, Page area Excel Keyboard Shortcuts
area, Row area Excel Keyboard Shortcuts
arguments dialog Functions
Array Formula Excel Keyboard Shortcuts
Arrays:, Excel Arrays: Getting Started Useful Links
Arrows, Tracer Arrows Useful Links

AT

attributes Header and Footer

AU

Auto Format Formatting the worksheet cells
AutoFormat, Format menu then AutoFormat Formatting the worksheet cells
AutoSum Excel Keyboard Shortcuts

B

B Useful Links

BA

Background Color
background color Removing Cell Formatting
Basic, Visual Basic Editor window Excel Keyboard Shortcuts

BL

black cross Editing a Worksheet

BO

Bold Underline or Italics style Formatting Fonts
bold, Toggles bold Excel Keyboard Shortcuts
bold, Toggles bold Excel Keyboard Shortcuts
Border tab Borders
border, Applies the outline border Excel Keyboard Shortcuts
border, Removes an outline border Excel Keyboard Shortcuts
Borders Borders
borders, Removes all the borders Excel Keyboard Shortcuts
bottom center Vertical Alignment

BR

brackets Linking Workbooks

BU

button, toolbar button Color

C

C Useful Links

CA

carriage return Excel Keyboard Shortcuts
category Formatting Numbers
category Functions

CE

Cell References Cell References
cell, absolute cell reference Cell References
cell, directly refer to the active cell Excel Keyboard Shortcuts
cell, F2 Edits the active cell Excel Keyboard Shortcuts
cell, relative cell reference Cell References
Cell, Removing Cell Formatting Removing Cell Formatting
cell, replace existing cell references Useful Links
Cell, Tracing Cell References Useful Links
cells, contiguous group of cells Range names
cells, create name ranges for individual cells or ranges of cells Useful Links
cells, create name ranges for individual cells or ranges of cells Useful Links
Cells, Deleting Individual Cells Editing a Worksheet
Cells, Format Cells dialog box Data Alignment
Cells, Format menu Format Cells Headings
Cells, Format menu Format Cells Borders
cells, Formatting the worksheet cells Formatting the worksheet cells
Cells, Insert Shift Cells Right or Down Editing a Worksheet
Cells, Inserting Individual Cells Editing a Worksheet
Cells, Precedent Cells Useful Links
cells, range of cells Cell References
Cells, Shift Cells Left or Up Editing a Worksheet
Cells, Tracing Dependent Cells Useful Links
cent symbol Excel Keyboard Shortcuts
center the heading Headings
center, bottom center Vertical Alignment

CH

chart sheet Excel Keyboard Shortcuts
chart, Creates a chart Excel Keyboard Shortcuts
check, R1C1 reference style check box Cell References
checkmark, Formulas checkmark Viewing Formulas

CL

Clear, Edit menu Clear Formats Removing Cell Formatting
clipboard, data from the clipboard Excel Keyboard Shortcuts

CO

colon sign Range
color-code Managing Workbooks
Color Color
color, background color Removing Cell Formatting
Color, Format menu Sheet Tab Color Managing Workbooks
color, typeface size style and color Formatting Fonts
column headings Freeze
column number Cell References
Column, Format menu then Row or Column Hide
column, How to manually resize a row or column How to manually resize a row or column
column, row and column headings Cell References
columns Range names
columns Freeze
Columns, Deleting Rows or Columns Editing a Worksheet
columns, display the hidden rows or columns Hide
columns, hidden columns Excel Keyboard Shortcuts
Columns, Insert menu Columns Editing a Worksheet
Columns, Inserting Columns Editing a Worksheet
columns, Unhides the columns in the current selection Excel Keyboard Shortcuts
Comma, Applies the Comma separated format Excel Keyboard Shortcuts
Constants, Named Ranges - Naming Constants and Formulas Useful Links
contiguous group of cells Range names
copy and paste Editing a Worksheet
copy formulas Editing Formulas

CR

Creates a chart Excel Keyboard Shortcuts
Creates a new workbook Excel Keyboard Shortcuts
Creating a Worksheet Creating a Worksheet
cross, black cross Editing a Worksheet

CU

currency percentages fractions dates Formatting Numbers
Currency, Applies the Currency format Excel Keyboard Shortcuts
current, Hides the rows in the current selection Excel Keyboard Shortcuts
current, Unhides the columns in the current selection Excel Keyboard Shortcuts
current, Unhides the rows in the current selection Excel Keyboard Shortcuts
Custom Header and Footer
Cut Editing a Worksheet
Cutting and Pasting Editing a Worksheet

DA

dashes, Moving dashes or marquee Editing a Worksheet
Data Alignment Data Alignment
data from the clipboard Excel Keyboard Shortcuts
Date, Applies the Date format Excel Keyboard Shortcuts
Dates Creating a Worksheet
dates, currency percentages fractions dates Formatting Numbers

DE

default font Formatting Fonts
define a named range Useful Links
Define, Insert menu Name Define Range names
Del key Removing Cell Formatting
Delete, Edit Delete Editing a Worksheet
Delete, Edit menu Delete Editing a Worksheet
Delete, Edit menu Delete Sheet Deleting a Worksheet
deleted permanently Deleting a Worksheet
Deleting a Worksheet Deleting a Worksheet
Deleting Individual Cells Editing a Worksheet
Deleting Rows or Columns Editing a Worksheet
deletion, undo the deletion Deleting a Worksheet
Dependent, Tracing Dependent Cells Useful Links
dependents Excel Keyboard Shortcuts
description Functions
description, item description Excel Basics
descriptive names Managing Workbooks

DI

dialog box Viewing Formulas
dialog box Functions
dialog, arguments dialog Functions
dialog, File menu and open Page Setup dialog box Header and Footer
dialog, Format Cells dialog box Data Alignment
dialog, Pivot Table Field dialog box Excel Keyboard Shortcuts
directly refer to the active cell Excel Keyboard Shortcuts
directly referred to by the formula Excel Keyboard Shortcuts
directly, enter names directly into the formula bar Useful Links
display named ranges in alphabetical order Useful Links
display of Outline symbols Excel Keyboard Shortcuts
display of the Standard toolbar Excel Keyboard Shortcuts
display the hidden rows or columns Hide
displaying, Toggles between hiding displaying Excel Keyboard Shortcuts
divided Split

DO

dollar sign Editing Formulas
Down, Insert Shift Cells Right or Down Editing a Worksheet

DR

Drawing toolbar Excel Keyboard Shortcuts
drop-down, Font Name drop-down list Excel Keyboard Shortcuts

DY

Dynamic Named Ranges Useful Links

ED

Edit Delete Editing a Worksheet
Edit menu Clear Formats Removing Cell Formatting
Edit menu Delete Editing a Worksheet
Edit menu Delete Sheet Deleting a Worksheet
Edit menu GoTo Useful Links
edit the heading Headings
edit, Enter to exit the edit mode Editing Formulas
Editing a Worksheet Editing a Worksheet
Editing Formulas Editing Formulas
Editor, Microsoft Script Editor Excel Keyboard Shortcuts
Editor, Visual Basic Editor window Excel Keyboard Shortcuts
Edits, F2 Edits the active cell Excel Keyboard Shortcuts

EN

Enter key Editing a Worksheet
enter names directly into the formula bar Useful Links
Enter to exit the edit mode Editing Formulas

EQ

equal sign Formulas
equal sign Functions
equal sign Worksheet Reference

ER

Error, Formula Error Messages Formula Error Messages

ES

Esc Excel Basics

EU

euro symbol Excel Keyboard Shortcuts

EX

Excel 3D reference Worksheet Reference
Excel Arrays: Getting Started Useful Links
Excel Basics Excel Basics
Excel Keyboard Shortcuts Excel Keyboard Shortcuts
Excel references Formulas
Excel, MS Excel 2003 Quick Reference MS Excel 2003 Quick Reference
Excel, Tutorials - Microsoft Excel Useful Links
exclamation mark Worksheet Reference
exclamation mark Linking Workbooks
existing, replace existing cell references Useful Links
exit, Enter to exit the edit mode Editing Formulas
Exponential, Applies the Exponential format Excel Keyboard Shortcuts

F

F2 Edits the active cell Excel Keyboard Shortcuts
F4 key Cell References
F5 key Useful Links

FI

Field, Pivot Table Field dialog box Excel Keyboard Shortcuts
File menu and open Page Setup dialog box Header and Footer
Fill Editing a Worksheet
Fill Color
Find Excel Keyboard Shortcuts
Find Excel Keyboard Shortcuts
Find Next Excel Keyboard Shortcuts
Find, last Find Excel Keyboard Shortcuts

FO

Font Name drop-down list Excel Keyboard Shortcuts
font, default font Formatting Fonts
Fonts, Formatting Fonts Formatting Fonts
Footer, Header and Footer Header and Footer
Footer, Header or Footer tab Header and Footer
format Header and Footer
Format Cells dialog box Data Alignment
Format menu Formatting Numbers
Format menu How to manually resize a row or column
Format menu Format Cells Headings
Format menu Format Cells Borders
Format menu Sheet Hide Hiding a Worksheet
Format menu Sheet Tab Color Managing Workbooks
Format menu Sheet Unhide Hiding a Worksheet
Format menu then AutoFormat Formatting the worksheet cells
Format menu then Row or Column Hide
format, Applies the Comma separated format Excel Keyboard Shortcuts
format, Applies the Currency format Excel Keyboard Shortcuts
format, Applies the Date format Excel Keyboard Shortcuts
format, Applies the Exponential format Excel Keyboard Shortcuts
format, Applies the General number format Excel Keyboard Shortcuts
format, Applies the Percentage format Excel Keyboard Shortcuts
format, Applies the Time format Excel Keyboard Shortcuts
Format, Auto Format Formatting the worksheet cells
Format, Format menu Format Cells Headings
Format, Format menu Format Cells Borders
Formats, Edit menu Clear Formats Removing Cell Formatting
Formatting Fonts Formatting Fonts
Formatting Numbers Formatting Numbers
Formatting the worksheet cells Formatting the worksheet cells
Formatting, Removing Cell Formatting Removing Cell Formatting
Formula Error Messages Formula Error Messages
Formula, Array Formula Excel Keyboard Shortcuts
formula, directly referred to by the formula Excel Keyboard Shortcuts
formula, enter names directly into the formula bar Useful Links
formula, link between worksheets in a formula Worksheet Reference
formula, print worksheet in formula view mode Viewing Formulas
formula, reference type in a formula Cell References
formula, referred to by the formula Excel Keyboard Shortcuts
Formulas Formulas
Formulas checkmark Viewing Formulas
formulas, copy formulas Editing Formulas
Formulas, Editing Formulas Editing Formulas
Formulas, Named Ranges - Naming Constants and Formulas Useful Links
formulas, natural language formulas Useful Links
Formulas, Viewing Formulas Viewing Formulas

FR

fractions, currency percentages fractions dates Formatting Numbers
Freeze Freeze
freeze, remove the freeze Freeze
Freeze, Window menu Freeze Panes Freeze
Freeze, Worksheet Navigation Hide Split and Freeze Worksheet Navigation Hide Split and Freeze

FU

function, SUM() function Excel Keyboard Shortcuts
Functions - Lookup and Reference Useful Links
Functions Functions

GE

General, Applies the General number format Excel Keyboard Shortcuts
Getting, Excel Arrays: Getting Started Useful Links

GO

GoTo Excel Keyboard Shortcuts
GoTo, Edit menu GoTo Useful Links

GR

group, contiguous group of cells Range names

HE

Header and Footer Header and Footer
Header or Footer tab Header and Footer
heading placeholder Headings
heading, center the heading Headings
heading, edit the heading Headings
Headings Headings
headings, column headings Freeze
headings, row and column headings Cell References
Height or Width How to manually resize a row or column

HI

hidden columns Excel Keyboard Shortcuts
hidden rows Excel Keyboard Shortcuts
hidden worksheets Hiding a Worksheet
hidden, display the hidden rows or columns Hide
Hide Hide
Hide, Format menu Sheet Hide Hiding a Worksheet
Hide, Worksheet Navigation Hide Split and Freeze Worksheet Navigation Hide Split and Freeze
Hides the rows in the current selection Excel Keyboard Shortcuts
Hiding a Worksheet Hiding a Worksheet
hiding, Toggles between hiding displaying Excel Keyboard Shortcuts

HO

How to manually resize a row or column How to manually resize a row or column

HY

Hyperlink Excel Keyboard Shortcuts
hyperlinks Excel Keyboard Shortcuts

IN

Insert menu Functions
Insert menu Columns Editing a Worksheet
Insert menu Name Useful Links
Insert menu Name Define Range names
Insert menu Rows Editing a Worksheet
Insert menu Worksheet Managing Workbooks
Insert Shift Cells Right or Down Editing a Worksheet
Inserting Columns Editing a Worksheet
Inserting Individual Cells Editing a Worksheet
Inserting Rows Editing a Worksheet
Inserts a new worksheet Excel Keyboard Shortcuts
Introduction Introduction

IT

Italics, Bold Underline or Italics style Formatting Fonts
italics, Toggles italics Excel Keyboard Shortcuts
italics, Toggles italics Excel Keyboard Shortcuts
item description Excel Basics

KE

key, Del key Removing Cell Formatting
key, Enter key Editing a Worksheet
key, F4 key Cell References
key, F5 key Useful Links
Keyboard, Excel Keyboard Shortcuts Excel Keyboard Shortcuts
Keys, Shortcut Keys Useful Links

LA

Label Useful Links
label Creating a Worksheet
labels, row labels Freeze
language, natural language formulas Useful Links
last Find Excel Keyboard Shortcuts

LE

Left, Shift Cells Left or Up Editing a Worksheet

LI

line, new line Excel Keyboard Shortcuts
link between worksheets in a formula Worksheet Reference
Linking Workbooks Linking Workbooks
Links, Useful Links Useful Links
list Functions
list Hiding a Worksheet
list, Font Name drop-down list Excel Keyboard Shortcuts

LO

Lookup, Functions - Lookup and Reference Useful Links

MA

Managing Workbooks Managing Workbooks
mark, exclamation mark Worksheet Reference
mark, exclamation mark Linking Workbooks
marquee, Moving dashes or marquee Editing a Worksheet

ME

menu, Edit menu Clear Formats Removing Cell Formatting
menu, Edit menu Delete Editing a Worksheet
menu, Edit menu Delete Sheet Deleting a Worksheet
menu, Edit menu GoTo Useful Links
menu, File menu and open Page Setup dialog box Header and Footer
menu, Format menu Formatting Numbers
menu, Format menu How to manually resize a row or column
menu, Format menu Format Cells Headings
menu, Format menu Format Cells Borders
menu, Format menu Sheet Hide Hiding a Worksheet
menu, Format menu Sheet Tab Color Managing Workbooks
menu, Format menu Sheet Unhide Hiding a Worksheet
menu, Format menu then AutoFormat Formatting the worksheet cells
menu, Format menu then Row or Column Hide
menu, Insert menu Functions
menu, Insert menu Columns Editing a Worksheet
menu, Insert menu Name Useful Links
menu, Insert menu Name Define Range names
menu, Insert menu Rows Editing a Worksheet
menu, Insert menu Worksheet Managing Workbooks
menu, Shortcut menu Excel Basics
menu, Tools menu then Options Viewing Formulas
menu, Window menu Freeze Panes Freeze
menu, Window menu Remove Split Split
menu, Window menu Split Split
menu, Window menu Unfreeze Panes Freeze
Merge option Headings
Messages, Formula Error Messages Formula Error Messages

MI

Microsoft Script Editor Excel Keyboard Shortcuts
Microsoft, Tutorials - Microsoft Excel Useful Links

MO

mode, Enter to exit the edit mode Editing Formulas
mode, print worksheet in formula view mode Viewing Formulas
mouse, Pausing the mouse pointer Excel Basics
Moving dashes or marquee Editing a Worksheet

MS

MS Excel 2003 Quick Reference MS Excel 2003 Quick Reference

MU

multiple worksheets Managing Workbooks

NA

Name box Useful Links
name of the worksheet Worksheet Reference
name, create name ranges for individual cells or ranges of cells Useful Links
Name, Font Name drop-down list Excel Keyboard Shortcuts
Name, Insert menu Name Useful Links
Name, Insert menu Name Define Range names
Named Ranges - Naming Constants and Formulas Useful Links
Named Ranges Useful Links
named, define a named range Useful Links
named, display named ranges in alphabetical order Useful Links
Named, Dynamic Named Ranges Useful Links
names, descriptive names Managing Workbooks
names, enter names directly into the formula bar Useful Links
names, Range names Range names
Naming, Named Ranges - Naming Constants and Formulas Useful Links
natural language formulas Useful Links
navigate Managing Workbooks
navigation, quick navigation Range names
Navigation, Worksheet Navigation Hide Split and Freeze Worksheet Navigation Hide Split and Freeze

NE

new line Excel Keyboard Shortcuts
new worksheet Excel Keyboard Shortcuts
new, add a new worksheet Managing Workbooks
new, Creates a new workbook Excel Keyboard Shortcuts
new, Inserts a new worksheet Excel Keyboard Shortcuts
next pane in a workbook Excel Keyboard Shortcuts
Next, Find Next Excel Keyboard Shortcuts

NO

Non-adjacent Range

NU

number, Applies the General number format Excel Keyboard Shortcuts
number, column number Cell References
number, row number Cell References
Numbers, Formatting Numbers Formatting Numbers

OF

OFFSET Useful Links
OFFSET Useful Links
OFFSET Useful Links
OFFSET Useful Links
OFFSET Useful Links

OP

open, File menu and open Page Setup dialog box Header and Footer
open, previous open workbook Excel Keyboard Shortcuts
option, Merge option Headings
options Data Alignment
options Borders
Options, Tools menu then Options Viewing Formulas

OR

Order of the worksheets Managing Workbooks
order, display named ranges in alphabetical order Useful Links

OU

outline, Applies the outline border Excel Keyboard Shortcuts
Outline, display of Outline symbols Excel Keyboard Shortcuts
outline, Removes an outline border Excel Keyboard Shortcuts

PA

Page area Excel Keyboard Shortcuts
Page Setup Printing
Page, File menu and open Page Setup dialog box Header and Footer
PageDown Managing Workbooks
PageUp Managing Workbooks
pane, next pane in a workbook Excel Keyboard Shortcuts
panes Split
Panes, Window menu Freeze Panes Freeze
Panes, Window menu Unfreeze Panes Freeze
Paste Useful Links
paste, copy and paste Editing a Worksheet
Pasting, Cutting and Pasting Editing a Worksheet
Pausing the mouse pointer Excel Basics

PE

Percentage, Applies the Percentage format Excel Keyboard Shortcuts
percentages, currency percentages fractions dates Formatting Numbers
permanently, deleted permanently Deleting a Worksheet

PI

Pivot Table Excel Keyboard Shortcuts
Pivot Table Excel Keyboard Shortcuts
Pivot Table Field dialog box Excel Keyboard Shortcuts

PL

placeholder, heading placeholder Headings

PO

pointer, Pausing the mouse pointer Excel Basics
points How to manually resize a row or column
pound sign symbol Excel Keyboard Shortcuts

PR

Precedent Cells Useful Links
Preview, Print Preview Printing
previous open workbook Excel Keyboard Shortcuts
Print Preview Printing
print worksheet in formula view mode Viewing Formulas
Printing Printing

QU

quick navigation Range names
quotes, single quotes Worksheet Reference

R

R1C1 reference style Cell References
R1C1 reference style check box Cell References

RA

Range Range
Range names Range names
range of cells Cell References
range, define a named range Useful Links
ranges of worksheets Worksheet Reference
ranges, create name ranges for individual cells or ranges of cells Useful Links
ranges, create name ranges for individual cells or ranges of cells Useful Links
ranges, display named ranges in alphabetical order Useful Links
Ranges, Dynamic Named Ranges Useful Links
Ranges, Named Ranges - Naming Constants and Formulas Useful Links
Ranges, Named Ranges Useful Links

RE

refer, directly refer to the active cell Excel Keyboard Shortcuts
reference type in a formula Cell References
reference, A1 reference style Cell References
reference, absolute cell reference Cell References
reference, Absolute reference Editing Formulas
reference, Excel 3D reference Worksheet Reference
Reference, Functions - Lookup and Reference Useful Links
Reference, MS Excel 2003 Quick Reference MS Excel 2003 Quick Reference
reference, R1C1 reference style Cell References
reference, R1C1 reference style check box Cell References
reference, relative cell reference Cell References
reference, row-column relative reference Cell References
Reference, Worksheet Reference Worksheet Reference
References, Cell References Cell References
references, Excel references Formulas
references, replace existing cell references Useful Links
References, Tracing Cell References Useful Links
References, Tracing References Useful Links
referred to by the formula Excel Keyboard Shortcuts
referred, directly referred to by the formula Excel Keyboard Shortcuts
relative cell reference Cell References
relative, row-column relative reference Cell References
remove the freeze Freeze
Remove, Window menu Remove Split Split
Removes all the borders Excel Keyboard Shortcuts
Removes an outline border Excel Keyboard Shortcuts
Removing Cell Formatting Removing Cell Formatting
rename a worksheet Managing Workbooks
Replace Excel Keyboard Shortcuts
replace existing cell references Useful Links
replicate information Editing a Worksheet
resize, How to manually resize a row or column How to manually resize a row or column
return, carriage return Excel Keyboard Shortcuts

RI

Right, Insert Shift Cells Right or Down Editing a Worksheet

RO

row-column relative reference Cell References
row and column headings Cell References
Row area Excel Keyboard Shortcuts
row labels Freeze
row number Cell References
Row, Format menu then Row or Column Hide
row, How to manually resize a row or column How to manually resize a row or column
rows Range names
rows Freeze
Rows, Deleting Rows or Columns Editing a Worksheet
rows, display the hidden rows or columns Hide
rows, hidden rows Excel Keyboard Shortcuts
rows, Hides the rows in the current selection Excel Keyboard Shortcuts
Rows, Insert menu Rows Editing a Worksheet
Rows, Inserting Rows Editing a Worksheet
rows, Unhides the rows in the current selection Excel Keyboard Shortcuts

SC

Script, Microsoft Script Editor Excel Keyboard Shortcuts

SE

selection, Hides the rows in the current selection Excel Keyboard Shortcuts
selection, Unhides the columns in the current selection Excel Keyboard Shortcuts
selection, Unhides the rows in the current selection Excel Keyboard Shortcuts
separated, Applies the Comma separated format Excel Keyboard Shortcuts
separators, split bar separators Split
Setup, File menu and open Page Setup dialog box Header and Footer
Setup, Page Setup Printing

SH

sheet, chart sheet Excel Keyboard Shortcuts
Sheet, Edit menu Delete Sheet Deleting a Worksheet
Sheet, Format menu Sheet Hide Hiding a Worksheet
Sheet, Format menu Sheet Tab Color Managing Workbooks
Sheet, Format menu Sheet Unhide Hiding a Worksheet
Shift Cells Left or Up Editing a Worksheet
Shift, Insert Shift Cells Right or Down Editing a Worksheet
Shortcut Keys Useful Links
Shortcut menu Excel Basics
Shortcuts, Excel Keyboard Shortcuts Excel Keyboard Shortcuts

SI

sign, colon sign Range
sign, dollar sign Editing Formulas
sign, equal sign Formulas
sign, equal sign Functions
sign, equal sign Worksheet Reference
sign, pound sign symbol Excel Keyboard Shortcuts
size Split
size, typeface size style and color Formatting Fonts

SP

Split Split
split bar separators Split
split view Split
Split, Window menu Remove Split Split
Split, Window menu Split Split
Split, Worksheet Navigation Hide Split and Freeze Worksheet Navigation Hide Split and Freeze

ST

Standard, display of the Standard toolbar Excel Keyboard Shortcuts
Started, Excel Arrays: Getting Started Useful Links
strikethrough, Toggles the strikethrough Excel Keyboard Shortcuts
style, A1 reference style Cell References
style, Bold Underline or Italics style Formatting Fonts
style, R1C1 reference style Cell References
style, R1C1 reference style check box Cell References
style, typeface size style and color Formatting Fonts

SU

SUM() function Excel Keyboard Shortcuts

SY

symbol, cent symbol Excel Keyboard Shortcuts
symbol, euro symbol Excel Keyboard Shortcuts
symbol, pound sign symbol Excel Keyboard Shortcuts
symbol, yen symbol Excel Keyboard Shortcuts
symbols, display of Outline symbols Excel Keyboard Shortcuts
syntax Functions
syntax Worksheet Reference

TA

tab, Alignment tab Data Alignment
tab, Border tab Borders
Tab, Format menu Sheet Tab Color Managing Workbooks
tab, Header or Footer tab Header and Footer
tab, View tab Viewing Formulas
tab, worksheet tab Managing Workbooks
Table, Pivot Table Excel Keyboard Shortcuts
Table, Pivot Table Excel Keyboard Shortcuts
Table, Pivot Table Field dialog box Excel Keyboard Shortcuts

TE

text Headings
text Header and Footer
text, Wrap text feature Data Alignment

TI

Time, Applies the Time format Excel Keyboard Shortcuts

TO

Toggles between hiding displaying Excel Keyboard Shortcuts
Toggles bold Excel Keyboard Shortcuts
Toggles bold Excel Keyboard Shortcuts
Toggles italics Excel Keyboard Shortcuts
Toggles italics Excel Keyboard Shortcuts
Toggles the strikethrough Excel Keyboard Shortcuts
Toggles underlining Excel Keyboard Shortcuts
Toggles underlying Excel Keyboard Shortcuts
toolbar button Color
toolbar, display of the Standard toolbar Excel Keyboard Shortcuts
toolbar, Drawing toolbar Excel Keyboard Shortcuts
Tools menu then Options Viewing Formulas
top Vertical Alignment

TR

Tracer Arrows Useful Links
Tracing Cell References Useful Links
Tracing Dependent Cells Useful Links
Tracing References Useful Links
troubleshoot a worksheet Viewing Formulas

TU

Tutorials - Microsoft Excel Useful Links

TY

typeface size style and color Formatting Fonts

UN

Underline, Bold Underline or Italics style Formatting Fonts
underlining, Toggles underlining Excel Keyboard Shortcuts
underlying, Toggles underlying Excel Keyboard Shortcuts
undo the deletion Deleting a Worksheet
Unfreeze, Window menu Unfreeze Panes Freeze
Unhide Hide
Unhide, Format menu Sheet Unhide Hiding a Worksheet
Unhides the columns in the current selection Excel Keyboard Shortcuts
Unhides the rows in the current selection Excel Keyboard Shortcuts

US

Useful Links Useful Links

VE

Vertical Alignment Vertical Alignment

VI

View tab Viewing Formulas
view, print worksheet in formula view mode Viewing Formulas
view, split view Split
Viewing Formulas Viewing Formulas
Visual Basic Editor window Excel Keyboard Shortcuts

WI

Width, Height or Width How to manually resize a row or column
Window menu Freeze Panes Freeze
Window menu Remove Split Split
Window menu Split Split
Window menu Unfreeze Panes Freeze
window, Visual Basic Editor window Excel Keyboard Shortcuts

WO

workbook, Creates a new workbook Excel Keyboard Shortcuts
workbook, next pane in a workbook Excel Keyboard Shortcuts
workbook, previous open workbook Excel Keyboard Shortcuts
Workbooks, Linking Workbooks Linking Workbooks
Workbooks, Managing Workbooks Managing Workbooks
Worksheet Navigation Hide Split and Freeze Worksheet Navigation Hide Split and Freeze
Worksheet Reference Worksheet Reference
worksheet tab Managing Workbooks
worksheet, add a new worksheet Managing Workbooks
Worksheet, Creating a Worksheet Creating a Worksheet
Worksheet, Deleting a Worksheet Deleting a Worksheet
Worksheet, Editing a Worksheet Editing a Worksheet
worksheet, Formatting the worksheet cells Formatting the worksheet cells
Worksheet, Hiding a Worksheet Hiding a Worksheet
Worksheet, Insert menu Worksheet Managing Workbooks
worksheet, Inserts a new worksheet Excel Keyboard Shortcuts
worksheet, name of the worksheet Worksheet Reference
worksheet, new worksheet Excel Keyboard Shortcuts
worksheet, print worksheet in formula view mode Viewing Formulas
worksheet, rename a worksheet Managing Workbooks
worksheet, troubleshoot a worksheet Viewing Formulas
worksheets, hidden worksheets Hiding a Worksheet
worksheets, link between worksheets in a formula Worksheet Reference
worksheets, multiple worksheets Managing Workbooks
worksheets, Order of the worksheets Managing Workbooks
worksheets, ranges of worksheets Worksheet Reference

WR

Wrap text feature Data Alignment

YE

yen symbol Excel Keyboard Shortcuts