Turn Option To Edit Directly In Cells. You can do this by selecting the cell and pressing F2 or simply clicking inside the cell. This option in excel is called Allow editing directly in cells.
Under Editing options do one of the following. For Excel 9720002002 aka XP2003 select Tools Options from the pulldown menus and select the Edit tab. By default you can directly edit the contents in the cell.
Press question mark to learn the rest of the keyboard shortcuts.
But you might find that double-clicking a cell to edit the data is no longer working and that you can only delete the existing data and enter it again if you need to edit it. Extend data range formats and formulasSelect to automatically format new items added to the. On a Mac go to preferences by using Command comma then click Edit and uncheck checkbox called Double clicking allows editing directly in a cell. You can enable or disable editing directly in cells by changing an Excel option.
