Index

Symbols

#### error, fixing, 104

A

adding

cell comments, 48–49

commands to Quick Access Toolbar, 9

data to charts, 124

footers, 161

headers, 161

hidden commands to Quick Access Toolbar, 10–11

legends ot charts, 125

pivot table data, 172

report filters, 170–171

adjusting page margins, 148–149

altering

charts, options, 118–119

data, charts, 123

drawing objects, 129

source data range, charts, 117

applied filters, clearing, 177

assigning names to cells or ranges, 90

Auto-Calculate, 94

AutoShapes, 128, 132

formatting, 132

AutoSum, 82

AVERAGE, 83

axis scale, formatting, 122

B

Backstage view, 12–13

Backstage view, print options, 142

bold, applying, 61

borders, changing, 68

C

calculating loan payments (PMT), 96–97

cell backgrounds, changing,

Get Easy Microsoft® Excel® 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.