Microsoft Office Tutorials and References
In Depth Information
Additional Microsoft Office Programs
• Brain Buster Book
Rentals in cell A1 (Figure 71).
Why did the appearance of the
formula bar change?
Excel displays the title in the
formula bar and in cell A1. When
you begin typing a cell entry, Excel
displays two additional boxes in the
formula bar: the Cancel box and
the Enter box. Clicking the Enter
box completes an entry. Clicking the
Cancel box cancels an entry.
in formula bar
text in active cell
overl ows into
adjacent cells to right
Click the Enter box to complete the
Enter box and
Cancel box no
entry and enter the worksheet title
in cell A1 (Figure 72).
text entered into cell A1
1. To complete entry, click
any cell other than
2. To complete entry,
press ENTER , HOME ,
PAGE UP , PAGE DOWN , END ,
UP , DOWN , LEFT ARROW , or
To Save an Existing Ofi ce Document with the Same File Name
Saving frequently cannot be overemphasized. You have made modii cations to the i le (spreadsheet) since you
created it. Thus, you should save again. Similarly, you should continue saving i les frequently so that you do not lose
your changes since the time you last saved the i le. You can use the same i le name, such as Brain Busters, to save the
changes made to the document. The following step saves a i le again.
Excel saved workbook
with same i le name,
Click the Save button on the Quick
Access Toolbar to overwrite the
previously saved i le (Brain Busters,
in this case) on the USB l ash drive
Why did the Save As dialog
box not appear?
Ofi ce programs, including Excel,
overwrite the document using the
setting specii ed the i rst time you
saved the document.
1. Press CTRL + S or press
SHIFT + F12