Microsoft Office Tutorials and References
In Depth Information
Editing cell contents
Editing cell contents
You’re not stuck with the first data you enter in a cell. In fact,
you can change the value completely, delete it, or update it
to reflect a supplier’s new business name or a customer’s new
address. You also are not stuck with only one way to edit the
data; you can edit the data either in the formula bar or directly
in the cell.
Edit cell contents in the formula bar
1 Click the cell that you want to edit.
2 Select the text that you want to edit in the formula bar.
3 Type the new text, and press Enter.
2
1
Edit cell contents directly in the cell
1 Double-click the cell that you want to edit.
2 Select the text that you want to edit.
3 Type the new text, and press Enter.
2
1
TIP If you double-click a cell but cannot edit its contents,
another user might have turned off this option. To turn on
in-cell editing, click the File tab, and click Options. In the Excel Options
dialog box, click Advanced to display the Advanced page of the dialog
box. In the Editing Options group, select the Allow Editing Directly In
Cells check box, and click OK.
TIP If you’re editing a cell and decide you don’t want to keep
your edits, press the Esc key to return the cell to its previous
state.
Search JabSto ::




Custom Search