Datasheet
237
H
heading
font for, 79, 164, 165
row and column
toggling 1, 2, etc., on and off, 145
toggling A–Z on and off, 145
height, changing row, 104–105
hiding
selected row or column, 56–57
unhiding row or column, 57
Highlight Changes dialog box, 220–221
Horizontal workbook view mode, 154, 155
I
image, as chart element background, 203
indenting cell text, 85
inserting
chart into worksheet, 188–189
column into worksheet, 48–49
new cell into existing worksheet range, 50–51
nonkeyboard symbol into cell, 32–33
row into worksheet, 48–49
IPMT function, 117
italic, applying font effect, 80–81
J
justifying cell text, 85
K
keyboard shortcuts and techniques
creating
new workbook, 149
range name, 69
entering symbol, 33
font-related, 81
navigating worksheet, 132
range
deleting, 55
selecting, 41
L
label (title)
chart
adding to axis, 190
adding to chart, 190
defined, 186
formatting, 200–203
column
creating range names based on, 68–69
freezing, 58–59
unfreezing, 59
data label, 191
range name
adding to formula, 64, 124–125
Apply Names feature, 125
basing on text label, 68–69
Formula bar
adding data to cell, 4, 26
defined, 4
editing data in cell, 4, 34–35
formulas
absolute cell reference in, 129
adding
to cell, 4, 114–115
function to, 4, 118–119
range name to, 64, 124–125
array-type, 181
building, 114–115
copying, 128, 129
defined, 4, 112
description, 112–113
editing, 115
entering in cell, 4, 112–113
moving, 128
referencing range
in another workbook, 127
in another worksheet, 126–127
relative cell reference in, 129
viewing
formula in cell, 115
result in cell, 114
freezing worksheet row or column, 58–59
Full Screen view, 19
Function Arguments dialog box, 119
functions
adding to formula, 4, 118–119
advantages of, 116
defined, 4, 116
description of, 116–117
financial, 117
listing of, 4, 118
statistical, 117
structure of, 116
FV function, 117
G
galleries, Ribbon, 10–11
glow effect, adding to chart element, 206
Go To dialog box, 71
gradient effect, 91, 202, 203
greater-than operator (>), 113
greater-than or equal-to operator (>=), 113
gridlines
on chart
defined, 186
displaying, 193
formatting, 200–203
on worksheet
changing color, 142–143
toggling on and off, 144
16_577639-bindex.indd 23716_577639-bindex.indd 237 3/15/10 2:49 PM3/15/10 2:49 PM