Help with Editing and Reviewing Fomulars

  • Thread starter Thread starter Nicko
  • Start date Start date
N

Nicko

I'm a new 2007 user and in the previous version I used to be able to double
click on a cell and it would automatically take me and highlight the cells
that comprise the formula. eg,

=Sum(tabA!A1:tabA!A5)

If i were double click on the cell above it would take me and highlight tabA
A1 to A5.

Can someone please tell me how I do this in 2007 PLEASE!!!!!

Thanks
 
Click on the big Office button at the top left
Select Excel Options from the bottom of the dialog box
Select Advanced in the left column
Uncheck "Allow Editing Directly in Cells"
Click On OK
 
Back
Top