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

774 Excel 2013 All-In-One For Dummies
WEEKDAY function, 366–367 WEEKNUM function, 370–371 Welcome to Excel
workbook, 15 what-if analysis. See also
Solver add-in
data tables, 645, 646–651 goal seeking, 645, 657–659 overview, 645
scenarios, 645, 652–657
When Calculating This Workbook section, Excel Options dialog box, 59–60
whiting-out errors with Conditional Formatting, 346–347
Whole Number option, Data Validation dialog box, 112
Wide margins, 279 width of columns
AutoFit feature, 135–136 default settings for, 137 hiding columns, 137–138 manually adjusting, 136 overflow indicators, 135
wildcards
asterisk (*), 217, 263,
406, 614
question mark (?), 217,
263, 406, 614 Window Color and
Appearance dialog box,
Windows 7, 164 windows, comparing
worksheets in separate. See View Side by Side feature
Windows, Microsoft automatic color, changing, 164
launching Excel from, 36–39
opening workbooks in, 184 pinning Excel to Start
menu, 38
pinning Excel to taskbar,
38–39
Regional date settings,
changing, 362–363 Windows 8 Touch
keyboard, 94–95 Windows 8 user
experience, 14 Windows Azure
Marketplace, importing
data from, 632, 698 win/loss charts, 542 Within drop-down list box,
Find and Replace dialog
box, 217
Word, Microsoft, sharing
workbooks with,
501–506
WordArt, 564, 567–568 WordArt Styles option,
530, 564
Workbook Connections
dialog box, 626 workbooks. See also
passwords; sharing workbooks; View Side by Side feature
adding worksheets to, 32, 33, 251–252
authors, adding to, 19 background images,
adding, 250–251 color coding tabs,
249–250
default settings for, 47 deleting sheets, 251–252 design of, 82–85
finding misplaced, 189 group editing, 253
hiding worksheets in, 254 merging cell styles into
other, 173
moving between sheets
in, 247
opening, 84–85, 184–189,
190
protecting, 452–454 rearranging order of
sheets, 251–252 renaming sheets,
248–249
templates, creating from,
77, 81–82 WORKDAY function, 371 Working with Formulas
section, Excel Options
dialog box, 50 Worksheet area
navigating, 28–32 overview, 16, 28 sheets, viewing, 33
worksheet editing options, Excel Options dialog box, 56–57
worksheets. See also
data entry; editing; protecting data; saving; templates
adding to workbooks, 32, 33
AutoRecover feature, 122–123
default view settings for, 47
designing, 75–76 importing Access data
to, 625
number of in workbooks,
setting, 47
scrolling through, 33 selecting all cells in, 128