How can I EDIT a Range?

[Fred]

I have a range named "SalPacRange" which comprises several, non sequential rows (i.e. rows 12, 27, 32, etc.). When I go into the dialogue box to edit a range name (using Insert, Name, Define on the menu bars), the cell references, being quite long in total, extend well beyond the end of the very small text editing box.

Here's my problem

Everytime I attempt to move my cursor within that text editing box using the arrow keys , the cellpointer starts moving around the spreadsheet to collect new cell references rather than moving around the text box allowing me to edit my ranges

What's the secret

Thanks
Fre

 

[Norman Harker]

Hi Fred!

Now this is really complex!

Press F2


<vbg>
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

I have a range named "SalPacRange" which comprises several, non

sequential rows (i.e. rows 12, 27, 32, etc.). When I go into the
dialogue box to edit a range name (using Insert, Name, Define on the
menu bars), the cell references, being quite long in total, extend
well beyond the end of the very small text editing box.

Here's my problem:

Everytime I attempt to move my cursor within that text editing box

using the arrow keys , the cellpointer starts moving around the
spreadsheet to collect new cell references rather than moving around
the text box allowing me to edit my ranges.

 

[Bob Phillips]

Is this an Oz artform?

Bob

Hi Fred!

Now this is really complex!

Press F2


<vbg>
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

sequential rows (i.e. rows 12, 27, 32, etc.). When I go into the
dialogue box to edit a range name (using Insert, Name, Define on the
menu bars), the cell references, being quite long in total, extend
well beyond the end of the very small text editing box.
using the arrow keys , the cellpointer starts moving around the
spreadsheet to collect new cell references rather than moving around
the text box allowing me to edit my ranges.

 

[Fred]

Thank you very much for this secret!!!!

 

[Norman Harker]

Hi Bob!

Just couldn't resist!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi Fred!

It's a pleasure. I know that the editing behaviour is a real pain and
I'm always forgetting to press that F2 button first.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Phillips]

Being serious for a moment, Norman is right about how handy it is. It's even
better to know that it also works in the RefersTo box of workbook names, in
the formula box of Conditional Formatting, and in the Data Validation
formula box. Truly useful!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Fred

A hint to know which mode you are currently in.

If you look down on the Status bar when in the Refersto box and see Point" or
"Enter" change it "Edit" by hitting F2 as Norman says.

Gord Dibben Excel MVP

 

[Norman Harker]

Hi Bob!

Not forgetting that F2 is a general toggle switch when entering
formulas.

If you start by pressing = then at any time you can switch to being
able to navigation within the formula by pressing F2. Second F2 and
you are back into the Point mode. But ain't it annoying when you
forget and press Home etc.!

With editing formulas you are in edit mode to start. F2 gives you
point mode and F2 again gets you back to edit.

Gord has covered the importance of looking at the status bar.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.