NameBar shortcutkey..

[sasi]

I like the shortcut keys, since it reduce my work time.
Repeated focus of name box using mouse produce some struggle to me..
It has any shortcut key to focus name box..
I'm waiting for your's nice reply..


Thx,

[oldchippy]

This isn't a short-key, but is a quick way of naming a range

http://www.contextures.com/xlNames01.html

[sasi]

Thx oldchippy..
I'm having a large accounts data sheet . For easy reference i made some names to cell like Granttotal,Tax2007,etc in different place & sheet. I'm using name box to focus (goto) my cell.
In every time, I did... clicking the name box,typing my cell name and got my process. 'focus of name box' having any shortcut-key implementation then i will use that. Do you understand my requirement.?

[All of them like the easiest way to getting their goals.me too...]

[oldchippy]

Not quite sure I understand, but if you use the drop-down arrow on the names box, that lists all the names in the workbook, so you can click on one of those and quickly get to that range.

[sasi]

More Thx to U.
I know that ..
I want to move my focus using keyboard [shortcut-key].(without mouse)
It's possible?

[oldchippy]

Here's a whole list of short-cut key stokes here

http://office.microsoft.com/en-us/ex...116591033.aspx

[sasi]

I searched on the link.
But i didn't got....
Any way ..
Thx once again chippy ,
I like your forums because of Ur's fast reply.

If u got that shortcut-key then send to me..
It will help to me..

[sasi]

Hi Friend,

How will i create a new thread(post) ?
Plz, help me ..
I wish to make some discussion ..
(or) i will continue in this ?

Regards,
Sasi.

[oldchippy]

Hi Sasi,

Please read the rules here

http://www.excelforum.com/showthread.php?t=613916

Start a new thread and if necessary refer back to this one if you think it's relevent