Help with Editing and Reviewing Fomulars

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
 
D

Duke Carey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top