Datasheet

243
inserting
new cell into existing range, 50–51
new row or column, 48–49
moving
range between, 47
within a workbook, 136, 137
between workbooks, 137
navigating
within same sheet by using range name, 70–71
between sheets, 135
new, creating, 134–135
overview, 2, 4–5
page break, 19
protecting data, 214–215
referencing range between, 126–127
renaming, 133
replacing text, 158–159
rotating text within cell, 88–89
saving data as Web page, 226–227
searching for text, 156–157
selecting
all cells, 41
range of cells, 40–41
sorting range, 172–173
tabs
defined, 24
renaming, 133
toggling headings A–Z and 1, 2, etc., on and off, 145
transposing rows and columns, 62–63
wrapping text within cell, 106–107
X
XY charts, defined, 187
searching for text, 157
sending as e-mail attachment, 224–225
tracking changes, 220–223
viewing second section in separate window, 155
window elements, 8, 24
worksheet tabs, 24, 133
worksheet. See also workbook
adding
background color, 90–91
chart to, 5, 188–189
row or column to, 48–49
to workbook, 134–135
aligning text within cells, 84–85
applying style, 100–101
centering text across multiple columns, 61, 86–87
changing
column width, 102–103
font and font characteristics, 78–83
row height, 104–105
collaborating on, 212–231
copying
range between, 47
within a workbook, 138, 139
between workbooks, 139
defined, 2, 8, 24
deleting from workbook, 140–141
editing cell data, 4, 34–35
entering data into cell, 4, 26–31
filtering data, 174–175
formatting overview, 160–169
freezing row or column, 58–59
gridlines on, 142–143, 144
hiding row or column, 56–57
16_577639-bindex.indd 24316_577639-bindex.indd 243 3/15/10 2:49 PM3/15/10 2:49 PM