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