Page 370 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 353
Index 353
• U • creating with an interactive data list, 266–267
creating with an interactive data table, 265–266
unattached text, 173 creating with interactive pivot tables, 267–268
underline button, 26 creating a static, 262–263
Undo button, 57 exporting to Excel, 269–270
undocking a floating toolbar, 65 saving a spreadsheet as a static, 262–263
union operator (,), 75 saving worksheets as a, 261
unmerge a super-cell, 31 Web query
UPPER function, 164–167 capturing URL address for a, 270
URL address importing web data into Excel with a, 271–272
capturing for a Web query, 270 overview, 270
as a destination for a hyperlink, 274 Web toolbar, 275
user-defined function, creating a, 300–305. WEEKNUM function, 110
See also custom function white-cross mouse pointer
editing with the, 57
• V • moving the cell cursor with the, 12
Width display indicator, 43
#VALUE! error value, 73 Wiley Product Technical Support contact
values information, 328
alternate, 151–153 Windows 98 For Dummies (Rathbone), 325
replacing in a cell, 53 Windows 2000 Professional For Dummies
rounding off, 125–126 (Rathbone), 325
VAR function, 253 Windows taskbar
VARP function, 253 launching Excel from the, 9
VBA (Visual Basic for Applications), 293 switching between books from the, 11
VBE (Visual Basic Editor) windows (vertical), 314
constructing a custom function in the, 301–302 WordArt, 198–200
editing a recorded macro in the, 296–297 WordArt Gallery dialog box, 198
overview, 293–295 workbook. See also workbook file
Standard toolbar in the, 295 adding hyperlinks to other sheets in a, 274–275
vertical lookup. See also VLOOKUP function adding summary information to a, 49–51
(vertical lookup) adding worksheets to a, 310
building formulas that perform a, 145–146 assigning a password for opening and editing a,
performing a, 144–146 222–223
vertical scroll bar, 12–13 blank, 10
Visual Basic Editor. See VBE (Visual Basic Editor) Close Window button on the, 11
Visual Basic toolbar, 294 customizing templates in a, 309
VLOOKUP function (vertical lookup). See also generating new from templates, 309
vertical lookup making active, 11, 315
arguments of the, 142 moving between sheets in a, 14
overview, 141–142 moving in the, 12–14
voice text entry, 16 multi-sheet layout of a, 310
opening a new, 10–11
opening options of a, 53–54
• W • password-protecting the, 221–223
printing entire, 45–46
WARNING icon, 6 protecting entire, 228–230
Web data imported into Excel with a Web query, working with two, 314–315
271–272 workbook file. See also workbook
Web page filename extensions of the, 11
adding hyperlinks to a, 277–278 opening/closing the, 11
creating an interactive, 263–264 saving a spreadsheet in a, 20–21
creating with an interactive chart, 268–269 searching for a, 51–53