Datasheet

242
Index
viewing
multiple workbooks within, 154–155
two sections of single workbook within, 155
worksheet elements, 24
Windows Live
collaborating on workbooks online, 230–231
saving Excel workbooks to SkyDrive, 227
Windows 7
adding Excel icon to taskbar, 7
starting Microsoft Excel, 6–7
Wingdings font, 33
workbook. See also worksheet
adding
blank worksheet to, 134–135
worksheet template to, 135
applying theme to, 79, 168–169
changing
color scheme, 162–163
font scheme, 164–165
choosing effect scheme, 166–167
collaborating on
accommodating earlier Excel version format, 228–229
cell comments, 212–213
online collaboration, 230–231
protecting cell data, 214–215
protecting structure, 216–217
saving data as Web page, 226–227
sending as e-mail attachment, 224–225
setup for, 218–219
tracking changes, 220–223
copying worksheet within, 138, 139
creating
based on existing workbook, 151
from template, 150–151
defined, 24, 146
deleting worksheet, 140–141
formatting, 160–169
moving worksheet within, 136, 137
multiple
arranging windows for viewing, 154–155
copying range between, 47
copying worksheet between, 139
moving range between, 47
moving worksheet between, 137
navigating between by using range name, 71
navigating between worksheets in, 135
new, blank, creating, 148–149
online collaboration using Windows Live SkyDrive,
230–231
opening, 153
protecting structure and windows, 216–217
referencing range between, 127
replacing worksheet text, 158–159
saving
data as Web page, 226–227
in Excel 2010 format, 152
in format compatible with earlier Excel version, 228–229
text label
adding to chart, 191
creating range name based on, 68–69
worksheet, merging cells to create, 60–61
title bar, 8
toggling
row and column headings on and off, 145
worksheet gridlines on and off, 144
tool tab, 15
total, with Sum button, 5, 122–123
Track Changes feature
accepting or rejecting change, 222–223
Everyone but Me option, 221
limiting task to specific range, 221
resolving change conflict, 223
tracking workbook changes, 220–221
turning off, 223
turning on, 220
transposing rows and columns, 62–63
U
underline, applying font effect, 80–81
undoing
cell edit, 35
data deletion, 37, 53
worksheet deletion, 140
unfreezing row or column, 59
unhiding hidden row or column, 57
unlocking cells, 214–215
user name, in Excel, changing, 213
V
validation rules for data, 176–177
value axis, 186
Vertical workbook view mode, 154, 155
view options, Excel window, 18–19
viewing
formula
in cell, 115
result of, in cell, 114
preview
Live Preview feature, 11
page break, 18, 19
workbooks
multiple, arranging windows for viewing, 154–155
single, separate sections in separate windows, 155
W
Web page, saving Excel data as, 226–227
Webdings font, 33
what-if analysis, 181
width, changing cell, 102–103
window, Excel
basic elements, 8
Full Screen view compared to, 19
view options, 18–19
16_577639-bindex.indd 24216_577639-bindex.indd 242 3/15/10 2:49 PM3/15/10 2:49 PM