Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I limit cursor movement within specified range in excel?
I am building a worksheet to enter data and calculate results. I want cursor to move to next line in col 1 after entering data in col 2 in 1 keystroke. Lotus lets one protect are to right and limits cursor movement to that unprotected area. How do I do this in Excel? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I limit cursor movement within specified range in excel?
slk0217
Not real sure of just what you are looking for but here is a shot: Goto Formatcellsprotection tab, remove the check mark from "Locked". Ok out and then protect the worksheet. Now the curser will only go through the unlocked cells column to column stepping down to each row. There is no way to control this movement. Mike Rogers "slk0217" wrote: I am building a worksheet to enter data and calculate results. I want cursor to move to next line in col 1 after entering data in col 2 in 1 keystroke. Lotus lets one protect are to right and limits cursor movement to that unprotected area. How do I do this in Excel? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I limit cursor movement within specified range in excel?
Enter your data in A1 then Tab to B1.
Type your data in B1 then hit ENTER key to go to A2 Your ToolsOptionsEditMove selection after Enter must be set to "Down" OR Unlock columns A and B then protect the worksheet to restrict travel to columns A and B. Gord Dibben MS Excel MVP On Fri, 4 Jan 2008 19:19:01 -0800, slk0217 wrote: I am building a worksheet to enter data and calculate results. I want cursor to move to next line in col 1 after entering data in col 2 in 1 keystroke. Lotus lets one protect are to right and limits cursor movement to that unprotected area. How do I do this in Excel? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cursor movement | Excel Discussion (Misc queries) | |||
Cursor Movement in Excel 2000 V9.0.3821 SR-1 | Excel Discussion (Misc queries) | |||
Cursor movement in Excel 2007 | Excel Discussion (Misc queries) | |||
Cursor movement | Excel Worksheet Functions | |||
Limit cursor range | Excel Worksheet Functions |