Page 791 - Excel 2013 All-in-One For Dummies

Index 773
Use Table Names in Formulas check box, 50
user information, checking on Account screen, 20
user interface, 14
User Interface Options, 46 User Name text box, 47 user-defined functions
(UDFs)
creating, 735–737 descriptions, adding to,
737–738
inserting in spreadsheets,
738–740 overview, 721
saving in add-in files,
741–744
users, removing from
shared workbooks, 483
V
Validation option, Paste Special dialog box, 213
Value Field Settings dialog box, 689
values
Conditional Formatting
feature, 176–180 dates and times, 89–91 Fixed Decimal Places
feature, 99–100 inputting numbers, 88–89 numeric formulas, 91–92 overview, 85, 88
Values and Number Formats option, Paste Special dialog box, 214
Values in Reverse Order option for chart
axes, 539
Values option, Paste Special
dialog box, 213 variable cells, 660
VBA (Visual Basic for Applications), 709, 721, 728–729. See also macros; Visual Basic Editor
VBAProject — Project Properties dialog box, 742
versions, options for, 464–465
Versions button, Info screen, 19
vertical axis, formatting options, 538–539 Vertical Axis Crosses
option for chart
axes, 540
vertical scroll bar, 31 vertical text alignment
options, 158–159 Vertical Text orientation
option, 160 Vertical window
arrangements, 257 View Macros option, 711 View Side by Side feature
comparing workbooks with, 258
comparing worksheets with, 254–257
saving workspaces, 260–262
transferring data between open windows, 258–259
transferring sheets from one workbook to another, 259–260
window arrangements, 257–258
View tab, Ribbon, 23
views, 47, 204–205
Visual Basic Editor. See also
user-defined functions editing macros in, 724–726 finding and replacing code
in macros, 726–728
general discussion, 722–724
InputBox function, 729–733 overview, 721
VBA properties, changing
settings for, 728–729 writing macros in,
733–735
Visual Basic for Applications
(VBA), 709, 721. See also macros; Visual Basic Editor
visual reports, creating with Power View add-in, 703–705
VLOOKUP function, 410–413
W
Warning icon, 9
Watch Window dialog box,
348, 359 watermark graphics, as
background images,
250–251
web app, editing in, 492,
496–499 web browsers
editing in, 492, 496–499 HTML files, creating for,
510–512
opening external data as
tables in, 642 opening files in, 190
web images, inserting, 554–556
Web Options dialog box, 60 Web Page file format, 119 web pages
publishing files as, 510–512
queries, 623, 626–628 web servers, saving files
on, 54