specific cell

[aynrand1964]

Hi,

In my worksheet, can I make a set-up that I can only go from 1 cell to
another specific cell by just pressing the tab or enter key?
like, in a spreadsheet, there's a lot of cell, so what I did was, I
locked & protect some cells but I have to run through every cell, it
doesn't skip.
Please help.
thanks

aynrand1964

 

[Paul B]

aynrand1964, here are two ways,

Click on each cell in the tab order you would like while
holding down the Ctrl key. Now press Ctrl+F3 and give it
a defined name. Select that name from the namebox and tab
through the cells.
There is a limit of about 25-40 cells you can put into a Named Range due to
a
255 character limit in the Named range.

Or with a macro, have a look here

http://www.dicks-blog.com/archives/2004/07/06/tab-order-of-cells/

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"aynrand1964" <[email protected]>
wrote in message
news:[email protected]...