| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select which cell enter will place the cursor
Is there a way to select which cell the cursor will highlight when you hit
enter? I have only a few cells in a worksheet which get data, the rest are just placeholders. Can you select that when you hit enter it will go to the next available input cell? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select which cell enter will place the cursor
You could:
1) use Format Cells and Unlock the required cells then 2) Protect the sheet specifying that only unlocked cells can be 'visited (only in XL 2003 and 2007 I believe) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mbing916" wrote in message ... Is there a way to select which cell the cursor will highlight when you hit enter? I have only a few cells in a worksheet which get data, the rest are just placeholders. Can you select that when you hit enter it will go to the next available input cell? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select which cell enter will place the cursor
You can select the cells that you want to use, then do
formatcellsprotection and deselect locked, then protect the sheet and make sure that select locked cells is not checked and select unlocked cells is checked. -- Regards, Peo Sjoblom "mbing916" wrote in message ... Is there a way to select which cell the cursor will highlight when you hit enter? I have only a few cells in a worksheet which get data, the rest are just placeholders. Can you select that when you hit enter it will go to the next available input cell? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select which cell enter will place the cursor
Thanks to Peo and Bernard! This worked!
"Peo Sjoblom" wrote: You can select the cells that you want to use, then do formatcellsprotection and deselect locked, then protect the sheet and make sure that select locked cells is not checked and select unlocked cells is checked. -- Regards, Peo Sjoblom "mbing916" wrote in message ... Is there a way to select which cell the cursor will highlight when you hit enter? I have only a few cells in a worksheet which get data, the rest are just placeholders. Can you select that when you hit enter it will go to the next available input cell? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in excel - arrow keys won't work & cursor will not select a cell | Excel Discussion (Misc queries) | |||
| Hitting Enter to Move Cursor to the Next Entry Cell | Excel Worksheet Functions | |||
| How do I convince the cursor to select a given cell when in a macr | Excel Discussion (Misc queries) | |||
| How do you select a cell with an "absolute" address with a cursor? | New Users to Excel | |||
| Cursor keys move active cell or scroll screen, how do I select whi | Excel Discussion (Misc queries) | |||
Linear Mode
