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" <aynrand1964.2bs9aj_1154304310.8182[ at ]excelforum-nospam.com>
wrote in message
news:aynrand1964.2bs9aj_1154304310.8182[ at ]excelforum-nospam.com...
[Quoted Text] >
> 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
>
>
> --
> aynrand1964
> ------------------------------------------------------------------------
> aynrand1964's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=36933
> View this thread: http://www.excelforum.com/showthread.php?threadid=566473
>
|