Справочник Пользователя для For Dummies Excel 2010 978-0-470-48953-6
Модели
978-0-470-48953-6
375
375
Index
cell
active, 98
adding comment to, 210–211
beginner basics, 370
column letter, 23
current cell indication, 23
cursor, 23–25, 103
moving between, 52
name, 213–217
relative cell reference, 158
adding comment to, 210–211
beginner basics, 370
column letter, 23
current cell indication, 23
cursor, 23–25, 103
moving between, 52
name, 213–217
relative cell reference, 158
cell content section (Formula bar), 22
cell formatting
cell formatting
Highlight Cells Rules option, 142–143
from Home tab, 107–111
Top/Bottom Rules option, 143
from Home tab, 107–111
Top/Bottom Rules option, 143
cell pointer
moving, 51–52
preventing from moving, 53
preventing from moving, 53
cell selection
active cell, 98
Add to Selection mode, 104
AutoSelect feature, 100–102
clicking-and-dragging technique, 100
description, 97
every cell in particular column, 100
every cell in particular row, 100
every cell in worksheet, 100
Extend Selection indicator, 103
extending column to right, 99
extending row to bottom, 99
Go To feature, 104
keyboard, 102–104
more than entire columns or rows, 100
nonadjacent, 98, 100, 103–104
noncontiguous, 98
point-and-click, 99–102
range of columns or rows, 100
with Shift key, 99
Shift+click method, 102
single cell, 98
in table of data, 100–103
Add to Selection mode, 104
AutoSelect feature, 100–102
clicking-and-dragging technique, 100
description, 97
every cell in particular column, 100
every cell in particular row, 100
every cell in worksheet, 100
Extend Selection indicator, 103
extending column to right, 99
extending row to bottom, 99
Go To feature, 104
keyboard, 102–104
more than entire columns or rows, 100
nonadjacent, 98, 100, 103–104
noncontiguous, 98
point-and-click, 99–102
range of columns or rows, 100
with Shift key, 99
Shift+click method, 102
single cell, 98
in table of data, 100–103
cell style
copying, 138–139
creating new, 138
description of, 137
merging, 139
as top ten feature, 366
creating new, 138
description of, 137
merging, 139
as top ten feature, 366
Cell Styles button, 137
cell-coordinate system, 201
cell-coordinate system, 201
center alignment, 42, 127, 129, 131
Center button, 110, 127
character, 79
chart
Center button, 110, 127
character, 79
chart
about this book, 4
adding data table to, 292
area, 286
bar, 286
clustered column, 290
column, 286, 298
creating new, 286–287
custom element, 291–293
data, 289
Draft mode, 290
embedded, 286–289
formatting, 294–297
instant, 287
layout, 290
legend, 289
line, 286, 298
location, 290
moving, 288–289
Normal mode, 290
pie, 286
pivot, 280–282
preview, 290
printing, 317
scatter, 286
selection handle, 288
text box, 299–302
title, 291, 293–295
as top ten feature, 366
type, 289
win/loss, 298
x-axis, 296–297
y-axis, 296–297
adding data table to, 292
area, 286
bar, 286
clustered column, 290
column, 286, 298
creating new, 286–287
custom element, 291–293
data, 289
Draft mode, 290
embedded, 286–289
formatting, 294–297
instant, 287
layout, 290
legend, 289
line, 286, 298
location, 290
moving, 288–289
Normal mode, 290
pie, 286
pivot, 280–282
preview, 290
printing, 317
scatter, 286
selection handle, 288
text box, 299–302
title, 291, 293–295
as top ten feature, 366
type, 289
win/loss, 298
x-axis, 296–297
y-axis, 296–297
Class mode, 34
Clear All button (Clipboard), 165
Clear Comments button, 168
Clear Contents button, 168
Clear Formats button, 167
Clear Hyperlinks button, 168
Clip art, 302–304
Clipboard
Clear All button (Clipboard), 165
Clear Comments button, 168
Clear Contents button, 168
Clear Formats button, 167
Clear Hyperlinks button, 168
Clip art, 302–304
Clipboard
Clear All button, 165
closing, 165
opening, 164
Paste All button, 165
pasting from, 164–165
closing, 165
opening, 164
Paste All button, 165
pasting from, 164–165
25_489536-bindex.indd 375
25_489536-bindex.indd 375
3/23/10 7:56 PM
3/23/10 7:56 PM