| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the enter key to move every 2 rows instead of one row
Would appreciate if someone can help. I want to have the cursor skip one row
after hitting the enter key. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to set the enter key to move every 2 rows instead of one row
Phyllis,
Try this event code. Copy the code, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Private Sub Worksheet_Change(ByVal Target As Range) Target(3).Select End Sub I've assumed that when you are 'hitting the enter key' you are entering a value into a cell. HTH, Bernie MS Excel MVP "PhyllisTheCat" wrote in message ... Would appreciate if someone can help. I want to have the cursor skip one row after hitting the enter key. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need enter key to move to the next column beginning | Excel Worksheet Functions | |||
| Move Selection after Enter | Excel Discussion (Misc queries) | |||
| In Excel enter key doesn't move to next row | Excel Discussion (Misc queries) | |||
| Cursor not to move when hitting the enter key | Excel Worksheet Functions | |||
| Tab and Enter key to move in spreadsheet? | Setting up and Configuration of Excel | |||
Linear Mode
