Datasheet

240
Index
removing command from, 15
restoring default configuration, 15
as source of commands for Quick Access Toolbar, 13
rotation, slanting text within cell, 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
height, changing, 104–105
hiding and unhiding, 56–57
merging cells to create title row, 60–61
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
S
Save button on Quick Access Toolbar, 12
saving
Excel data as Web page, 226–227
workbook
in Excel 2010 format, 152
in format compatible with earlier Excel
version, 228–229
scheme, workbook
color, 162–163
effect, 166–167
font, 164–165
searching for text in workbook, 156–157
securing worksheet data, 214–215
selecting
all cells, 41
chart element, 201
chart type, 188–189
column for displaying sum in status bar, 5, 123
data for chart, 188
keyboard techniques for, 41
nonadjacent cells, 40
range of cells, 40–41
sending workbook as e-mail attachment, 224–225
series
chart (data)
in chart data table, 194
defined, 186
formatting, 200–203
filling automatically, 5, 44–45
shadow effect, adding to chart element, 206, 207
shape style, applying to chart element, 208–209
sharing workbook. See collaborating on a workbook
sheet, chart, 189. See also worksheet
SkyDrive, saving Excel workbook to, 227
smart tag, 16–17
soft edges effect, adding to chart element, 207
sorting worksheet range, 172–173
special symbol, inserting, 32–33
saving data as Web page, 226–227
selecting, 40–41
sorting, 172–173
tracking changes, 221
transposing rows and columns, 63
range name
adding to formula, 64, 124–125
Apply Names feature, 125
basing on text label, 68–69
benefits, 64–65
changing, 72–73
creating
automatically, 68–69
manually in New Name dialog box, 66–67
defined, 64
defining, 66–67
deleting, 74–75
ease of use, 64
navigating
between workbooks, 71
within worksheet, 70–71
RATE function, 117
Redo button, on Quick Access Toolbar, 12
reference format for cell address
absolute or relative, 129
defined, 24
relative cell reference format, 129
removing
cell, 54–55
data from, 36–37
data from range, 52–53
cell formatting
along with data, 37, 52, 53
while keeping data, 37, 53
column, 55
command
from Quick Access Toolbar, 13
from Ribbon, 15
comment from cell, 213
conditional format, 99
range, 54–55
range name, 74–75
row, 55
style effect from chart, 209
renaming
range, 72–73
worksheet, 133
replacing text in workbook, 158–159
Ribbon
adding
command to, 15
new group to existing tab, 14–15
new tab to, 14–15
customizing, 14–15
defined, 8, 9
description, 9
formatting chart element, 200, 201, 202–203
galleries in, 10–11
moving Quick Access Toolbar below, 13
16_577639-bindex.indd 24016_577639-bindex.indd 240 3/15/10 2:49 PM3/15/10 2:49 PM