U


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




Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net