Editing directly in a cell

Excel Tech Tip – Editing directly in a cell

 

If you’re like me, you enjoy being able to double click a cell within excel and edit directly there rather than having to edit in the formula bar. See simple instructions below to turn on editing directly in cells.

 

Step 1: click File and Options

 

Step 2:          Click ‘Advanced’, and check the box next to ‘Allow editing directly in cells’

 

 

Step 3: Enjoy!

 

Note: a shortcut to edit the cell is key ‘F2’