Again another thing that has been niggling at my mind. I recall when a range is selected you can move the cursor to the various corners of the selected range. Today I found the answer:
- After selecting the range, press [Ctrl + .] this will move you around the 4 corners of the selected range
NB: This does not work in a formula which is what I was wanting, but hey I have had a small win.