Index
changing shape, 100–101
deleting, 35, 102
editing, 101
formatting, 99–100
hiding, 101
inserting, 98–99
reading, 101
selecting cells containing, 78
showing, 101
copying, 81–82
to adjacent cells, 86
containing conditional formatting, 142
to other worksheets, 87
paste options, 89–93
using drag-and-drop, 85–86
using Office Clipboard, 87–89
using Ribbon commands, 82
using shortcut keys, 83
using shortcut menu commands, 83, 84
data types, 29–31
defined, 71
deleting contents, 34–35
editing
color-codes, 430
contents, 35–37
filled with hash (#) marks, 425
filling gaps, 606–607
finding, 432–433
gridlines, printing, 185
highlighting
based on value of another cell, 387–389
with values lower than hard-coded value,
385–387
input messages, displaying, 625
inserting, 66
merging, 125–126
named styles, 143–146
navigating, 179–182
preventing from printing, 191–192
removing text, 607–608
replacing contents, 35
replacing text, 609–610
selected cell indicator, 6
tracing relationships, 433–435
unique address, 7
unlocking, 770–772
center text alignment, 123, 125
certificate authority, 780
certificates, obtaining, 780
Change Chart Type dialog box, 456
Change worksheet event, 1003–1004
changing cells, Scenario Manager, 725
entering in Add Scenario dialog box, 727
maximum number per scenario, 730
modifying scenarios, 729
naming, 726
CHAR() function, 264–265
chart area, 450, 451, 495–496
Chart Elements button, 494
chart titles, adding, 498
gridlines, adding/removing, 500
Chart Elements control, 490, 491–492
Chart Filters button, 494
chart sheets
converting chart on to embedded chart, 460–461
converting embedded chart to chart sheet, 460–461
copying charts on, 461
deleting, 461
overview, 449
Chart Styles button, 494
chart templates, creating, 522
Chart Tools
Format
Insert Shapes, 499–500
Shape Styles, 495, 501
Chart Tools Design
Chart Layouts
Add Chart Element, 461
Quick Layout, 454
Chart Styles, 456
Data
Switch Row/Column, 454
Location
Move Chart, 460
Type
Change Chart Type, 456
Chart Tools Format, 459
Shape Styles
Shape Effects, 459
Shape Fill, 459
Shape Outline, 459
Size, 460
Charts
Insert Statistic Chart, 483
charts
activating, 448
adding elements, 457–458, 461cells. See also ranges (cont inued)