Is it possible to have the cursor move to only unlocked cells? We have a spreadsheet with unlocked cells in different columns - not just going straight down, but would for example, start at D1 then move over to A2, B2, C2, D2 then might go to B3 then C4?

thanks for any assistance
JT

The tab key will move you thru the unlocked cells.
Coloring the cell background with a light shade will help identify them.
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Extras for Excel: Date picker, Clean Data, Classic Menu ...)



"JT" <(E-Mail Removed)> wrote in message
news:vh%Zq.15741$(E-Mail Removed)...
Is it possible to have the cursor move to only unlocked cells? We have a spreadsheet with unlocked
cells in different columns - not just going straight down, but would for example, start at D1 then
move over to A2, B2, C2, D2 then might go to B3 then C4?

thanks for any assistance
JT

This works a few times - but for some reason when it gets to a certain point
it only goes back and forward across the same row.


"Jim Cone" <(E-Mail Removed)> wrote in message
news:jhfaia$1lp$(E-Mail Removed)...
> The tab key will move you thru the unlocked cells.
> Coloring the cell background with a light shade will help identify them.
> --
> Jim Cone
> Portland, Oregon USA .
> http://www.mediafire.com/PrimitiveSoftware .
> (Extras for Excel: Date picker, Clean Data, Classic Menu ...)
>
>
>
> "JT" <(E-Mail Removed)> wrote in message
> news:vh%Zq.15741$(E-Mail Removed)...
> Is it possible to have the cursor move to only unlocked cells? We have a
> spreadsheet with unlocked cells in different columns - not just going
> straight down, but would for example, start at D1 then move over to A2,
> B2, C2, D2 then might go to B3 then C4?
>
> thanks for any assistance
> JT
>
>

Some ideas here on excel navigation... http://blog.contextures.com/
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Formats & Styles xl add-in: lists/removes unused styles & number formats) - free




"JT" <(E-Mail Removed)>
wrote in message
newss__q.69$(E-Mail Removed)...
> This works a few times - but for some reason when it gets to a certain point it only goes back and
> forward across the same row.




> "Jim Cone" <(E-Mail Removed)> wrote in message news:jhfaia$1lp$(E-Mail Removed)...
>> The tab key will move you thru the unlocked cells.
>> Coloring the cell background with a light shade will help identify them.
>> --
>> Jim Cone
>> Portland, Oregon USA .
>> http://www.mediafire.com/PrimitiveSoftware .
>> (Extras for Excel: Date picker, Clean Data, Classic Menu ...)



>> "JT" <(E-Mail Removed)> wrote in message
>> news:vh%Zq.15741$(E-Mail Removed)...
>> Is it possible to have the cursor move to only unlocked cells? We have a spreadsheet with
>> unlocked cells in different columns - not just going straight down, but would for example, start
>> at D1 then move over to A2, B2, C2, D2 then might go to B3 then C4?
>>
>> thanks for any assistance
>> JT