Datasheet

389389
Index
Values and Number Formats option (Paste
Special dialog box), 166
Values button (Paste Special dialog
box), 166
Values (V) option (Paste Options
palette), 163
Var function, 279
VARP function, 279
VBA (Visual Basic for Applications), 351
vertical alignment, 42, 129, 131
vertical split bar, 232
vertical text, 134
View menu command, Excel 2003 and 2010
equivalent, 36
View Side by Side button, 243–244
View tab, 16
Visual Basic for Applications (VBA), 351
• W •
Web page query, 342–344
Web site
Adobe, 91
SharePoint, 359–360
What-If Analysis feature
about this book, 4
data table, 255–258, 260–261
Goal Seek dialog box, 261–262
Scenario Manager dialog box, 263–266
wide margin, 182
wildcard, 219
window
cascade arrangement, 241–242
closing, 243
 lling gap by closing, 243
horizontal placement, 239
maximizing, 242
next to each other, 239
one above the other, 239
opening, 238–242
overlapped, 241
restoring arrangement of, 244
size, 239
splitting, 204–206
synchronous scrolling, 244
tiled, 239–240
vertical placement, 239
Window menu command, Excel 2003 and
2010 equivalent, 38–39
Windows 7
Open dialog box for, 149
Save As dialog box in, 88–89
starting Excel from, 369
Windows Vista
Open dialog box for, 149
Save As dialog box in, 88–89
starting Excel from, 369
Windows XP
Open dialog box for, 149
Save As dialog box in, 89
Start menu, 29
win/loss chart, 298
WordArt, 308–310
workbook
activating, 369
activating worksheet in, 27
adding worksheet to, 26–27
copying worksheet to, 245–248
missing, 150–151
name, 371
opening, 147–150
saving copy of, 370
searching, 150–151
selecting last sheet, 27
selecting next sheet, 27
selecting worksheet in, 27
sending via e-mail, 358–359
shared, 359–360
starting new, 369
uploading, 360–362
worksheet versus, 229
worksheet
activating, 27
adding hyperlink to, 347–349
adding to workbook, 26–27
basic description of, 13
beginner basics, 370
cell cursor, 23
cell cursor movement, 23–25
copying, 238
copying to other workbook, 245–248
current cell indication, 23
25_489536-bindex.indd 38925_489536-bindex.indd 389 3/23/10 7:56 PM3/23/10 7:56 PM