Page 766 - Excel 2013 All-in-One For Dummies

748 Excel 2013 All-In-One For Dummies
cell editing
clearing cells, 194–196 editing in cells versus on
Formula bar, 193 inserting cells, 196–198 overview, 190–191
Redo command, 191–193 Undo command, 191–193
cell entries numeric, 88–92 overview, 85 text, 86–87
Cell Errors As drop-down list box, 360
CELL function, 420 cell icons
filtering data lists by, 609
sorting on, 596–597
cell ranges. See also range
names
array ranges, 319 Conditional Formatting
feature, 176–180 constraining data entry
to, 98–99
converting formulas into
calculated values, 216 editing, enabling in
protected files, 445–450 formatting with Mini-
Toolbar, 148–149 in formulas, 126 functions returning
number of columns and
rows in, 417–418 Locked protection format,
441–442
naming, 133–134 orientation, changing with
TRANSPOSE function,
418–419 overview, 126 Print Areas, 278
cell references
absolute, 315–318 hyperlinks for, 456, 458
mixed, 318–319 R1C1 cell reference
system, 50, 314–315 relative, 314–315
cell selections AutoSelect feature,
130–132
Go To feature, 132–133 with keyboard, 129–130 keystrokes for moving
within, 99
with mouse, 127–128 naming cell ranges,
133–134 overview, 126–127 by touch, 129
cell styles
creating, 171–172 merging into other
workbooks, 173 Number Format, 170–171 overview, 169
Cell Styles gallery, 169–171 cells. See also cell editing;
cell ranges; cell
selections absolute references,
315–318
changing, 652 constraint, 660 counting formulas for,
401–407
deleting, 194–195 editing formulas in, 301 formatting from Ribbon,
143–147
hyperlinks for references,
456, 458
locating in worksheets, 29 Locked protection format,
440–442
mixed references, 318–319 objective, 660
R1C1 cell reference
system, 50, 314–315 relative references, 314–315
set, 658
styles, 169–173 variable, 660 whiting-out errors with
Conditional Formatting,
346–347
Cells Containing Formulas
That Result in an Error
check box, 355 Cells Containing Years
Represented as 2 Digits
check box, 355 Center Across Selection
alignment option, 158 Center alignment option,
146, 157, 158 centered headers or footers, 286
Change Chart Type option, 524
Change History log, 474 Change Picture option, 559 change tracking, 475–479,
481
changing cells, 652 chart area, 516
chart data series, 516 Chart Elements option,
529, 532
Chart Layouts option, 523 chart sheets, 82
Chart Styles gallery,
523, 524 chart text, 517
chart titles, 532, 534–535, 536–538
charts
creating on separate
sheets, 522 customizing elements of,
532–535
data labels, adding,
533–534
data tables, adding, 534 default settings for, 55