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

"Nicko" wrote:

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