W

 Wages.xlsx files, 433

Watch Window, 245, 865

watching formulas, 245

WAV files, 363

Web beacons, 107

Web browsers, 65, 781

Excel Web Access, 820–821

launching, 876

opening files in, 65

specialized Query forms, 781

XPS-enabled, 423–424

Web file formats, 70–71

Web folders, 789

Web sites

accessibility features, 100

alt text graphic tags, 391

automatic address correction, 228

document workspaces, 816–818

Excel Web site, 82

hyperlinks to, 815, 873–877

intranets, 779–785, 815

links to, 815

recovering data and, 82

subwebs, 816

trusted sites, 816

updating Euro Currency Tools add-in, 551

URLs, 874

Web queries, 779–785

WEEKDAY function, 532, 989

weekends, 534

WEEKNUM function, 989

WEIBULL function, 989

what-if analysis

data tables, 583–588

Excel Web Access, 821

Goal Seek command, 599–601

Scenario Manager, 588–599

Solver add-in, 601–611

wheeled mouse, 27

whole numbers. See integers

wide pages, 403

wildcards

filtering, 689

SEARCH function, 505

searching and replacing, 225

Window menu commands and options, 921

windows (Excel)

arranging, 166–168

inconsistencies, 173–175

keyboard shortcuts, 945

maximizing, 168–169

multiple, 171–175

naming, 172

saving as hidden, 178

saving view settings, 174

views, 173–175

Windows (Microsoft)

keyboard shortcuts, 945

Start button commands and options, 907

taskbar, 29, 30

transferring worksheets to Macintosh, 522

Windows Live ID authentication, 803, 806

Windows Live Messenger, 808, 811

Windows Messenger, 811

Windows Messenger icon, 807

Windows Metafile format, 894, 895–896

Windows Packager, 887

Windows Rights Management Services (RMS), 803

Windows Server 2003, 803

Windows SharePoint Services. See SharePoint Services

Windows Trust Center. See Trust Center

winning changes, 794

wireframes, 380

With . . . End With structure, 843

With statements, 843

wizards

Conditional Sum Wizard, 478–483

Lookup Wizard, 478–479, 483–485

Query Wizard, 760–763, 764

Step By Step Mail Merge Wizard, 901–904

Text Import Wizard, 750–755

WMF (Windows Metafile format), 894, 895–896

Word

inserting charts into, 899–901

inserting data into, 897–899

inserting tables in, 891–899

mail-merging data, 901–904

Word 97–2003 format, 900

WordArt

charts and, 629–631, 642

creating, 356–358

examples of, 398–401

workbooks. See also worksheet design; worksheets

as add-ins, 855

combining changes, 798–800

creating, 46–48

dependent, 473–477

disabling editing, 158–159

displaying more of, 29–30

distributing by e-mail, 800–802

embedding in Word, 895

encryption, 177–178

file formats, 56–57

floating, 25

full screen view, 168–169

hiding, 175–176, 178

hiding cells and worksheets, 162–163, 178

Information Rights Management, 803–806

linked with formulas, 473–477

locking windows, 158–159

macro-enabled, 829–830

masters, 799

maximizing view, 168–169

multiple windows, 171–175

naming windows, 172

navigating, 27–29

navigating between, 165–166

panning, 27

passwords, 159–163, 794

permissions, 161–162

Personal Macro Workbook, 845

printing, 418

protecting, 159–163, 176–177, 796, 803–806

publishing to Excel Services, 821–823

recalculating, 463

reference syntax, 435

removing personal information, 110–111

removing sharing from, 797, 798

resizing windows, 29–30

saving, 51

saving characteristics of, 169

saving or retrieving from remote computers, 789–790

saving view settings, 174

scrolling, 27–29

security, 110–111, 474–475, 476

shared documents, 796

sharing, 51, 793–794, 797, 798

size of, 820

title bar, 26

windows in, 25, 166–175

WORKDAY function, 534, 989

workgroups. See collaboration

worksheet design

audience definition, 120–121

imported data, 121–122

long vs. wide, 117–118

modular design, 123

multiple worksheets, 123

print guidelines, 119–120

readability, 117–118

room for expansion, 123

row and column layout, 117–118

worksheet maintenance, 121

Worksheet Objects, 894–895

worksheet-qualified formulas, 622, 623

worksheets. See also cells (worksheets); columns (worksheet); regions; rows (worksheet); workbooks; worksheet design

3-dimensional cell references, 448–449

accessibility and, 100

active areas, 29

auditing. See auditing worksheets

cell names in, 445–446

cell references to, 430–431

changing sheets with shapes and graphics, 388–389

consolidating, 258–264, 799

copying, 149–150

deleting, 147–148

dependents, 135

design guidelines, 117–123

displaying custom views, 156

displaying in panes, 151–152

distributing by e-mail, 800, 802

editing, 236–241

formatting. See formatting

freezing panes, 152–154

group editing, 237–239, 240–241

hidden tabs, 153

hiding, 162–163

history, 796

hyperlinks to, 877, 878

illustrated, 24, 26

inserting, 147–148

jumping to, 28

jumping to specific spots, 132

keyboard modes, 127

keyboard shortcuts, 127, 131, 946

locking and unlocking cells, 156–158

maintenance guidelines, 121

moving, 149–150

names, 148, 410, 411

navigating, 132, 134, 931–932, 942–943

nonadjacent, 129–131

outlining, 255–259

overview, 24–25

passwords, 159–163

permissions, 159–163

precedents, 135

printing, 412–419

publishing to Excel Services, 821–823

rearranging, 149

recalculating, 463

reference syntax, 435

regions, 131, 133

scrolling, 27

selecting, 147, 148

selecting items in, 129–136, 204, 205

side-by-side comparison, 18, 169–171, 790–800

size of, 820

snapping pictures of, 395–398

sorting, 675–684

tabs, 26–28, 101, 148, 149, 153, 237, 240

visible cells, 133

zooming, 129, 154–155

workspaces. See also workbooks; worksheets

creating, 816–818

saving, 60–61

SharePoint services, 801

wrapping text, 319

www prefix, 874