Microsoft Office Tutorials and References
In Depth Information
Selecting a Cell
3
Click the Enter box to complete the
entry and enter a worksheet title
(Figure 1– 7).
Why does the entered text appear
in three cells?
When the text is longer than the
width of a column, Excel displays
the overl ow characters in adjacent
cells to the right as long as those
adjacent cells contain no data. If the
adjacent cells contain data, Excel
would hide the overl ow charac-
ters. Excel displays the overl ow
characters in the formula bar
whenever that cell is the active cell.
Enter box and
Cancel box no
longer displayed
text entered
into cell A1
Figure 1– 7
4
Click cell A2 to select it.
Type
Lifetime Fundraising
Summary as the cell entry.
Click the Enter box to complete the
entry and enter a worksheet subtitle
(Figure 1– 8).
What happens when I click the Enter
box?
When you complete an entry by
clicking the Enter box, the insertion
point disappears and the cell in
which the text is entered remains
the active cell.
worksheet subtitle
entered into cell A2
Figure 1– 8
Other Ways
1. To complete entry, click
any cell other than active
cell
2. To complete entry, press
ENTER
3. To complete entry, press
HOME , PAGE UP , PAGE
DOWN , or END
4. To complete entry, press
UP ARROW , DOWN ARROW ,
LEFT ARROW , or RIGHT
ARROW .
AutoCorrect
The AutoCorrect feature of Excel works behind the scenes, correcting common
mistakes when you complete a text entry in a cell. AutoCorrect makes three types of
corrections for you:
1. Corrects two initial capital letters by changing the second letter to lowercase.
2. Capitalizes the i rst letter in the names of days.
3. Replaces commonly misspelled words with their correct spelling. For example,
it will change the misspelled word recieve to receive when you complete the entry.
AutoCorrect will correct the spelling of hundreds of commonly misspelled words
automatically.
Q&As
For a complete list of the
Q&As found in many of
the step-by-step sequences
in this topic, visit the
Excel 2010 Q&A Web page
(scsite.com/ex2010/qa).
Search JabSto ::




Custom Search