| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move only around selected cells??
I wish to create various excel sheets where the user can only move between
various cells ignoring all the others using the tab key. for instance the first cell is A2 then when you tab it moves to C5 and all inbetween are all locked. Is this only done by making some form (which looks complex to me atm) or is there a very simple way of doing this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move only around selected cells??
have the cells you wnat the users to use as unlocked, lock all the other
cells and then use tools/protection and protect the locked cells -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "CP" wrote: I wish to create various excel sheets where the user can only move between various cells ignoring all the others using the tab key. for instance the first cell is A2 then when you tab it moves to C5 and all inbetween are all locked. Is this only done by making some form (which looks complex to me atm) or is there a very simple way of doing this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move only around selected cells??
CP
Just in case you need it, you lock and unlock cells via format cellsprotection tab. Mike Rogers "john" wrote: have the cells you wnat the users to use as unlocked, lock all the other cells and then use tools/protection and protect the locked cells -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "CP" wrote: I wish to create various excel sheets where the user can only move between various cells ignoring all the others using the tab key. for instance the first cell is A2 then when you tab it moves to C5 and all inbetween are all locked. Is this only done by making some form (which looks complex to me atm) or is there a very simple way of doing this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I just selected Move or Copy from Edit | Excel Discussion (Misc queries) | |||
| Excel sheets should move while selected cell stays in middle | Excel Discussion (Misc queries) | |||
| Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
| highlight selected row permanently until u move out from the row | Excel Discussion (Misc queries) | |||
| The selected area grows when I click a cell or press keys to move. | Excel Discussion (Misc queries) | |||
Linear Mode
