after hitting enter

[Guest]

When you hit the ENTER button.. the cursor will move either right,left,up or down... Is there a way to have it move to specific cell for example if your add data in A1 then hit enter the cusor will move diractly to say E13.. then to say G6 and so on? Please help

 

[AlfD]

Hi!

If you select a number of cells using ctrl-<click>
and unlock them (Format>cells> protection) then protect the workshee
(Tools>Protection>Protect sheet), the tab key will move the cursor fro
one unlocked cell to the next.

The order of moving from cell to cell seems more problematic. May nee
a bit of experimentation or more knowledge than I have, but Exce
appears to deal with the cells on a row-wise basis.

Maybe this could help you?

Al

 

[Ragdyer]

One way to explicitly control the exact "next cell of focus" selection, is
to select the cells in the desired order of travel, and then preserve this
ordered movement by creating a named range.

This old post describes the steps that can be taken to create such a "named
range".

http://tinyurl.com/39vzv


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

When you hit the ENTER button.. the cursor will move either right,left,up

or down... Is there a way to have it move to specific cell for example if
your add data in A1 then hit enter the cusor will move diractly to say E13..
then to say G6 and so on? Please help