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
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.