Datasheet

236
Index
Excel Options dialog box
changing Excel user name, 213
customizing
Excel, 20–21
Quick Access Toolbar, 12–13
Ribbon, 14–15
ways to open, 21
exiting Microsoft Excel, 7
exponentiation operator (^), 113
F
File tab, 8
Fill Effects dialog box, 91
filling of range
AutoFill feature, 44
by creating custom AutoFill list, 45
customized series of values, 45
same data, 42–43
standard series of values, 5, 44–45
without copying original cell’s formatting, 43
fills
adding background color to worksheet range, 90–91
customizing chart element background, 202–203
filtering data, 174–175
financial function, 117
financial symbol, inserting, 32–33
Find and Replace dialog box
finding text, 156–157
replacing text, 158–159
finding text in workbook, 156–157
font
applying effect, 80–81
changing
color, 82–83
default, 79
size, 78–79
typeface, 78–79
workbook scheme, 164–165
creating new workbook scheme, 165
font scheme, defined, 164
foreign character, inserting, 32–33
formatting. See also customizing
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
default buttons, Quick Access Toolbar, 12
default configuration, Ribbon, restoring, 15
default font, changing, 79
Degrees spin box, 88, 89
deleting
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 in cell, 213
conditional format, 99
range, 54–55
range name, 74–75
row, 55
style effect from chart, 209
displaying
data table in chart, 194
decimal places, 94–95
gridlines
on chart, 193
on worksheet, 144
row and column headings, 145
division operator (/), 113
doughnut chart, defined, 187
drop-down galleries, 11
E
editing. See also changing
cell data, 4, 34–35
comment in cell, 213
formula, 115
effect scheme, choosing, 166–167
e-mail attachment, sending workbooks as, 224–225
entering into cell
data, 4, 26–31
date, 30–31
formula, 4, 112–113
numbers, 28–29
text, 26–27
time of day, 30–31
equal sign (=) in formula, 4, 112, 114
equal-to operator (=), 113
error message alert, 177
Excel. See also specific topics
adding icon to Windows 7 taskbar, 7
commands, 12–13, 15
description, 4–5
quitting, 7
starting, 6–7
version file format compatibility, 228–229
window, 7, 8–9
16_577639-bindex.indd 23616_577639-bindex.indd 236 3/15/10 2:49 PM3/15/10 2:49 PM