Datasheet

233
formula, 4, 112–113
numbers, 28–29
text, 26–27
time of day, 30–31
filling series, 5, 44–45
formatting, 76–109
inserting special symbol, 32–33
locking, 214–215
merging, 60–61
multiple, calculating SUM, 120–121
new, inserting one or more into existing range, 50–51
nonadjacent
selecting cells, 40
totaling values, 121
protecting data, 214–215
range
adding up row or column using SUM function, 121
aligning text within cells, 84–85
applying style, 100–101
background color, adding, 90–91
border, adding, 108–109
column width, 102–103
converting to table, 178–179
copying, 46, 47
data and formatting from range, 52, 53
data in range but not formatting, 52–53
defined, 24, 38
deleting, 54–55
existing, inserting new cell into, 50–51
filling, 5, 42–45
filtering, 174–175
font and font characteristics, 78–83
formatting, 76–109
locking and unlocking, 214–215
moving, 46, 47
name, changing, 72–73
naming, 64–69
protecting data, 214–215
range name, 74–75
rectangular, 40
referencing in another workbook, 127
referencing in another worksheet, 126–127
row height, 104–105
saving data as Web page, 226–227
selecting, 40–41
sorting, 172–173
tracking changes, 221
transposing rows and columns, 63
rotating text within, 88–89
row
adding up numbers using SUM function, 120–121
changing height, 104–105
defined, 24
deleting, 55
as element of row-and-column spreadsheet format, 5
freezing and unfreezing, 58–59
hiding and unhiding, 56–57
merging cells to create title row, 60–61
bold, applying font effect, 80–81
border
adding to cells and ranges, 108–109
custom, creating, 109
selecting line style, 109
bubble chart
description, 187
horizontal gridlines for, 193
building formulas, 114–115
C
Cascade workbook view mode, 154, 155
category axis, 186, 193
cell
absolute or relative compared to mixed reference formats,
129
active or current, 26
adding
background color, 90–91
border, 108–109
comment, 212–213
data to, 4, 26–27
formula, 4, 114–115
aligning text within, 84–85
applying style, 100–101
AutoComplete feature, 27
changing
column width, 102–103
font and font characteristics, 78–83
row height, 104–105
columns
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
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
width, changing, 102–103
copying and pasting using smart tags, 16–17
data validation rules for, 176–177
defined, 24
deleting
comment, 213
data and formatting, 37, 52, 53
data but not formatting, 36–37
formatting but not data, 37, 53
editing
comment in, 213
data, 4, 34–35
entering
data, 4, 26–31
date, 30–31
16_577639-bindex.indd 23316_577639-bindex.indd 233 3/15/10 2:49 PM3/15/10 2:49 PM