Datasheet

235
Excel options, 20–21
formatting
adding to new row or column, 48, 49
by applying AutoFormat feature, 96–97
chart element, 200–209
clearing from cell, 37, 52, 53
conditional, 98–99
date and time, 30, 31
deleting along with data, 37, 52, 53
filling range without copying, 43
keeping when deleting cell data, 37, 52–53
number, 92–95
predefined, 96–97
workbook, 160–169
worksheet range, 76–109
wrapping text within cell, 106–107
Quick Access Toolbar, 12–13
Ribbon, 14–15
worksheet style, 101
D
data analysis
converting range to table for, 178–179
creating data table for, 180–181
defined, 170
filtering data for, 174–175
rules for data validation, 176–177
sorting data for, 172–173
summarizing data, 182–183
data label
adding to chart, 191
defined, 191
data marker
defined, 186
label for, 191
data point
in chart data table, 194
defined, 186
labeling, 191
data series
in chart data table, 194
defined, 186
formatting, 200–203
data table
comparison with Excel table, 180
creating for use with formula, 180–181
defined, 180
displaying in chart, 194
data type, 25
data validation rules, 176–177
data value, defined, 186
database, spreadsheet as, 5
date
description of data type, 25
entering into cell, 30–31
filtering, 175
formatting options, 30, 31
decimal place, controlling display, 94–95
multiple, centering text across, 61, 86–87
new, inserting one or more in worksheet, 49
selecting, 41
toggling A–Z headings on and off, 145
transposing with rows, 62–63
column chart
description, 187
horizontal gridlines for, 193
comma (,), 29, 93
command, Excel
adding
to Quick Access Toolbar, 12–13
to Ribbon, 15
removing
from Quick Access Toolbar, 13
from Ribbon, 15
comment
adding to cell, 212–213
editing in cell, 213
removing from cell, 213
comparison formula, 113
conditional format
applying, 98–99
defined, 98
multiple, specifying, 99
removing, 99
copying
cell, using smart tag, 16–17
formula, 128, 129
range, 46, 47
worksheet, 138–139
COUNT function, 117
Create Names from Selection dialog box, 69
Create Table dialog box, 179
creating
chart
as part of worksheet, 188–189
on separate sheet, 189
data table, 180–181
PDF file from workbook, 225
range name
automatically, 68–69
manually in New Name dialog box, 66–67
template, 151
title row for worksheet, 60–61
workbook
based on existing workbook, 151
new, blank, 148–149
from template, 150–151
worksheet
based on existing worksheet, 138–139
new, blank, 134–135
from template, 135
Currency format, 92
customizing
AutoFill feature, 45
chart element
background, 202–203
outline, 204–205
16_577639-bindex.indd 23516_577639-bindex.indd 235 3/15/10 2:49 PM3/15/10 2:49 PM