Datasheet

234
Index
formatting, 200–209
gridlines on, 186, 193, 200–203
inserting into worksheet, 188–189
list of types, 187
removing style effect, 209
saving as template, 197
selecting
chart type, 188–189
data for, 188
chart area
customizing background, 202–203
defined, 200
formatting, 200–201
chart categories, in chart data table, 194
chart legend
defined, 186
formatting, 200–203
positioning, 192
chart (data) series
in chart data table, 194
defined, 186
formatting, 200–203
chart sheet, defined, 189
chart title
adding
to axis, 190
to chart, 190
defined, 186
formatting, 200–203
closing Microsoft Excel, 7
collaborating on a workbook
accommodating earlier Excel version format, 228–229
cell comments, 212–213
online, 230–231
protecting
cell data, 214–215
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
color
adding to background, 90–91
changing
workbook scheme, 162–163
for worksheet font, 82–83
for worksheet gridlines, 142–143
color scheme, 162–163
Colors dialog box, 91
column
adding up numbers using SUM function, 120–121
changing width, 102–103
defined, 24
deleting, 55
as element of row-and-column spreadsheet format, 5
freezing and unfreezing, 58–59
hiding and unhiding, 56–57
new, inserting one or more in worksheet, 48, 49
selecting, 41
toggling 1, 2, etc., headings on and off, 145
transposing with columns, 62–63
selecting
all cells, 41
range of cells, 40–41
unlocking, 214–215
viewing formula in, 115
wrapping text within, 106–107
cell address
absolute reference format, 129
defined, 24
relative reference format, 129
centering text across columns, 61, 86–87
changing
chart
layout, 195
type of, 196–197
color in worksheet, 82–83, 142–143, 162–163
column width, 102–103
editing
cell data, 4, 34–35
comment in cell, 213
formula, 115
Excel user name, 213
font
characteristics of, 78–83
scheme for, 164–165
range name, 72–73
row height, 104–105
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
width, column, 102–103
chart
adding
special effect to element, 206–207
title, 186, 190
applying style, 195, 208–209
changing
layout, 195
type, 196–197
clicking on element to select, 201
creating
as part of worksheet, 188–189
on separate sheet, 189
customizing
element background, 202–203
element outline, 204–205
defined, 5, 186
element, defined, 186
16_577639-bindex.indd 23416_577639-bindex.indd 234 3/15/10 2:49 PM3/15/10 2:49 PM