Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet that I will use to enter data for scores at a
competition. The range of cells I'll enter the data in is C3-L3 x 30 rows (C3-C32 - L3-L33) It doesn't matter if I enter the data by column or row. I would like the worksheet to behave as follows: Ex: Entering data in columns, when I get to the bottom of a column (C32), I like the cursor to go to the top of the next column (D2). Ex: Entering data in rows, when I get to the end of a row (L3), I like the cursor to go to the start of the next row (C4). I know I can do this by selecting the range of cells, but this method is somewhat troublesome when a mistake is made entering data: there's no way to restart entering the data from the point the mistake was made except reselecting the entire range again. So my question is this: Is there a way to lock or protect the entire sheet and unlock just the cells for the data thet will work in the way described above? I know I can lock cells to prevent data entry or change, but this does not prevent or control cursor movement. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |