Cursor movement

[JT]

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

 

[Jim Cone]

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 ...)



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

 

[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]

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" <[email protected]>
wrote in message