Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
specific cell
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...o&userid=36933 View this thread: http://www.excelforum.com/showthread...hreadid=566473 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
specific cell
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/2...rder-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" wrote in message ... 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...o&userid=36933 View this thread: http://www.excelforum.com/showthread...hreadid=566473 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Select cell containing specific text &return value from another ce | Excel Worksheet Functions | |||
Specific cell values | Excel Discussion (Misc queries) | |||
how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) |