I will take this as a "it worked".

Not an undocumented feature.

In Help type "ext" to get some info on "selecting cells on a worksheet" which
mentions the extended mode and F8

OR "keyboard shortcuts" to see what the F8 key provides.

Another shortcut I like is hitting SHIFT + F8 to get into ADD mode.

This allows you to select non-contiguous areas without using CTRL + Click.


Gord



On 16 Sep 2006 00:46:24 -0700, "NickCory" wrote:

Hi

Thanks, Gord.

I searched the Excel Help for items like "F8", "extended mode", cell
selection and so on but could not find any information about this
function. An undocumented feature? But useful, when searching for the
corner cell of a very large range, to be able to hit F8 to toggle the
extended mode.

Good that there are MVPs out there.

I wonder how the application got into extended mode in the first place,
right in the middle of an edit...


kind regards
Nick Cory
14656 Brieselang
nr. Berlin, Germany