Click the Office Ribbon Button (colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing OptionsCheck the Allow Editing
Directly In Cells

If the above doesn't rectify your problem, then try the below one.

Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsAdvancedEditing Options Uncheck the "Zoom on roll
with IntelliMouse"

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"kirsty" wrote:

In my old version of office, I could start writing a basic formula and
mid-way scroll to another location on the worksheet to select a cell for the
formula. I cannot find any way to do this in 2007 and have to use the scroll
bar at the side of the worksheet - am I missing something (apart from the
tooks menu!!)

(Has anyone retroengineered a way to get rid of these thrice damned ribbons
and get the old office back?)

Any help appreciated!
Thanks