UNC paths, 874
unconditional breakpoints, 863
underlining, 303, 875, 940
underlying values
searching and replacing, 222
vs. displayed, 139–140
underscore characters (_), 840
undoing actions
data entry, 145–147
formatting, 375
keyboard shortcuts, 936
overview, 205–206
redoing undo actions, 206
worksheet insertion, 148
Unformatted Text objects, 894, 895
Unformatted Unicode Text objects, 894, 895
ungrouping
columns and rows, 257–258
objects, 387, 931, 944
unhiding. See displaying
Unicode text, 683–684, 894, 895
Uniform distribution, 575, 576–577
union operators (,), 458
unique records, 698–699, 774
unique views in conditional formatting, 287
unmerging cells, 337–339
unqualified structured references, 459
up and down bars, 662–663
updating
charts in Word, 900–901
dynamic links to Web sites, 109
Euro Currency Tools add-in, 551
Excel 2007, 22–23
HYPERLINK formulas, 880
linked objects, 888–889
linked workbooks, 474–475
multiuser workbooks, 793
PivotTables, 721
query result sets, 772
tables in Word, 896–897
tables with external data, 747–748
upgrading
earlier versions of files, 456
menu and command locations in Excel 2007, 907–925
uploading documents to SharePoint sites, 807–809
UPPER function, 503, 505, 987
URLs (Uniform Resource Locators)
automatic correction, 228
converting to hyperlinks, 228
document workspaces, 817
overview, 107
U.S. Treasury bills, 547
usability testing, 109–110
user-defined distribution, 575
user-defined functions. See custom functions
user interface. See also workbooks; worksheets; specific features
customizing. See customizing
illustrated, 5
results-oriented, 4–5
UserForms, 851
users
access to documents with IRM protection, 805
adding to IRM permissions, 806
adding to SharePoint workspaces, 818
advanced workbook sharing and, 793–794
checked-out documents and, 811
multiple in same workbook, 790–798
names, 791