Page 371 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 354
354 Excel Workbook For Dummies
workbook protection (enabling/disabling), 229 • X •
WORKDAY function, 111
worksheet. See also spreadsheet .xls, extension, 11
adding a, 14 .xlt, extension, 11
alignment in a, 16 .xml extension (Extensible Markup Language),
color-coding tabs on a, 310 269
custom view of a, 312 Xpos optional argument (InputBox), 297
data entry in a protected, 227–228
default alignment of a, 16
editing multiples as a group, 69 • Y •
hiding columns and rows in a, 35
manually modifying row height in a, 25 YEARFRAC function, 111
moving to a new area of a, 12–13 ypos optional argument (InputBox), 297
protecting a, 224–226
saving as Web pages overview, 261
scrolling through a, 12–13 • Z •
selecting a, 14
using to organize spreadsheet data, 310 zoom
worksheet protection, 224–226 default for Page Break Preview, 38
Wrap Cell control, 30 editing worksheets and, 54–55
increasing the, 38
in print preview window, 38
range of settings of, 54