Allow editing directly in a cell or restrict editing to the formula bar
- On the Tools menu, click Options, and then click the Edit tab.
- To allow editing and typing data in cells, select the Edit directly in cell check box.
To allow editing and typing data only in the formula bar, clear the check box.