Datasheet
383383
Index
#NULL! error value, 67
#NUM! error value, 67
Num Lock indicator (Status bar), 28
number
date formats, 59–62
decimal place, 56–58
of degrees, 133
dollar amount, 56
fractional, 57
negative value, 56
percentage, 57
positive value, 56
time formats, 59–60
number lter, 335–336
number format
Accounting, 115–116, 119
assigning after entered, 113–114
Comma Style, 116
Currency, 115, 121
Date, 120–121
Fraction, 121
General, 114
Number, 121
over ow, 116
Percent, 117
Percent Style, 117
Phone Number, 121
Social Security Number, 121
Special, 121
Time, 121
types of, 113
Zip Code, 121
Zip Code + 4, 121
Number Format button, 43, 111
Number group (Home tab), 109, 111
Number of Pages button, 192
number sign (#), 66
Number tab (Format Cells dialog box), 113
• O •
one-variable data table, 256–258
online search, 223
Open command
Customize Quick Access Toolbar, 19
File menu, 146
Open dialog box
Favorite Links section, 147
Navigation pane, 146
for Windows 7 and Windows Vista, 149
for Windows XP, 149
opening
AutoFilter feature, 334
Backstage View, 12, 40
Clipboard, 164
Format Cells dialog box, 113
Go To dialog box, 23
Goal Seek dialog box, 261
help window, 32
Open and Repair command, 151
Open as Copy command, 151
Open in Browser command, 151
Open in Protected View command, 151
Open Read-Only command, 151
Protect Sheet dialog box, 225
Research task pane, 222
Table gallery, 105
windows on worksheet, 238–242
workbook, in Open dialog box, 146–148
workbook, multiple, 148–149
workbook, recently edited, 149–150
Options command (File menu), 68, 72, 76
Options dialog box, 76–77
orientation
Landscape, 180, 182, 184
Portrait, 180, 182, 184
text, 132–134
Orientation button, 42, 110, 182
overlapped window, 241
• P •
page break
bad vertical break example, 196
xing, 195–198
inserting/removing, 182
print preview, 178
Page Layout tab, 15
Page Layout View, 11, 176–177, 366
Page Number button, 192
Page Setup group, 181–182
parentheses ( ), 65–66
password protection, 225–226, 372
Paste All button (Clipboard), 165
Paste command, 161
25_489536-bindex.indd 38325_489536-bindex.indd 383 3/23/10 7:56 PM3/23/10 7:56 PM