worksheets. See also workbooks
activating 100
adding 99
attaching comments to 110
AutoCalculate area 99, 119
autoformats , applying 114
averages, calculating 126
borders, applying 124
calculation areas 123
calculation areas, setting up 123
cells . See cells, worksheet
centering entries 124
centering headings 113
centering on page 131
clearing cells 110
columns . See columns, worksheet
comments, displaying 110
comments, editing 110
conditional formatting 128
consolidating data from multiple 145
copying 136
copying between 109
copying entries 107, 109
copying entries, by dragging 109
copying in, finalizing 135
correcting mistakes 101
cutting entries 123
dates, arithmetic with 104
dates, entering 104
dates, formatting 105, 113
deleting 137
displaying formulas in 118
editing 105
editing multiple 113
Enter key, changing action 102
entering data 100
entering text 101
entering values in 102
entries, aligning 101
entries, changing 107
entries, completing 100, 101
formatting 112
formatting cells in 113
formatting, clearing 146
formatting, with autoformats 114
formula bars 99
formulas. See formulas
grouping 113
headers/footers, adding 130
headings. See headings, worksheet
hidden, activating 100
linking 145, 146
linking, during data consolidation 144
linking to graphs 148, 152
margins, changing 130
moving 136
moving between 99, 109
moving between workbooks 136
moving entries 107
moving to cell A1 135
name boxes 99
numbers , entering as text 103
organizing 123
outlines, collapsing/expanding 144
outlines, turning off 144
outlining 144
outlining, turning off 144
page orientation, changing 131
pasting entries 107
pasting links in 146
patterns, applying 124
previewing 129
printing 129
range references. See range references
ranges. See ranges
renaming 136
rows. See rows, worksheet
scrolling 100
status bars 99
times, entering 104
values 100
values, default alignment 102
values, totaling with SUM function 119
values, displaying long 103