Show All

Allow editing directly in a cell or restrict editing to the formula bar

1. On the Tools menu, click Options, and then click the Edit tab.
2. 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.