Datasheet

381381
Index
• H •
header
alignment, 189, 192
auto, 189–191
centered, 189–190
custom, 191–193
date, 192
even and odd page, 195
 lename, 193
 rst-page, 194
font, 193
page number, 192
picture, 192
print title versus, 185
text, 193
uses for, 189
worksheet, 193
Header & Footer Elements group, 191–193
help window, 32
hiding
column, 124–125
graphic object, 316–317
pivot table, 271
row, 125
Home keystroke, 70
Home menu command
Home tab
Alignment group, 108, 110
cell formatting from, 107–111
contents, 15
Font group, 108, 109.110
Number group, 109, 111
horizontal alignment, 127, 131
horizontal scroll bar, 25
horizontal split bar, 206, 233
hot key
about this book, 5–6
command button selection, 18
dialog box launcher, 18
Ribbon interface tab, 17
hyperlink
about this book, 4
adding to worksheet, 347–349
removing, 168
hyphen (-), 56
• I •
icon
conventions used in this book, 6
directional, 142
icon set, 141
Import button (Options dialog box), 77
importing
external data, 340
picture, 305
Increase Decimal button, 111
Increase Font Size button, 42, 109
Increase Indent button, 110, 128–129
indentation, 128–129
informational graphic, 298–299
Insert button, 169
Insert Function button
editing function with, 84
inserting function into formula with,
81–83
Insert keystroke, 70
Insert menu command, Excel 2003 and
2010 equivalent, 35–36
Insert tab, 15
insertion point, 52
interest rate, 117
is greater than operator, 337
Italic button, 109
italicized font, 126
• K •
Keep Source Formatting (K) option (Paste
Options palette), 163
keyboard
conventions used in this book, 5–6
hot key combination, 5–6
selecting Ribbon command using, 17
keyboard cell selection, 102–104
• L •
label. See text
LAN (Local Area Network), 347
Landscape orientation, 180, 182, 184
language, 171
25_489536-bindex.indd 38125_489536-bindex.indd 381 3/23/10 7:56 PM3/23/10 7:56 PM