Excel (XP) Skip Cells

[TopJack]

Is it possible to get Excel to skip cells as you cursor around the spreadsheet.

For example if I was in cell B3 and cursor down once, I want it to jump over cell B4 and go straight to cell B5. Cell B4 has protected data in it already.

Any ideas ?

 

[xlbo]

If you "lock" a cell and protect the sheet, there are sets of options that disallow the selection of protected cells......so yes....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[TopJack]

Thanks. The stupid questions are always the best.