Keyboard Shortcuts

[Guest]

I would like to hit the enter key and have the worksheet insert a blank line
and move to the next line. How do I do that?

 

[JulieD]

Hi Storm2

what every single time you ever press the enter key in excel?!?
do you want the new line insert above or below the current line, so if
you're on row 11 do you want the blank line to push the 11 to row 12 or to
be inserted under the 11 as a new 12 and then where do you want the cursor
to actually end up?

Cheers
JulieD

 

[David McRitchie]

Hi Storm,
As Julie pointed out, kind of ambiguous how you'd be
able to do anything if you got what you actually asked for.

Normally the Enter goes down though you can make it go across.
You can use the TAB key to go across to the right. See if
the following would be what you really wanted.

Worksheet_SelectionChange (#ws_sc)
Worksheet_SelectionChange to prevent entry past a column
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

The purpose of this macro is that the cursor hits a brick wall at
column D (col 4) and returns to the beginning (Col A) of the next row.
Use the TAB key to go to next cell. No cell protection or validation
is required for this macro.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.column < 4 then exit sub
On error resume next 'MUST reenable events...
Application.EnableEvents = False
ActiveCell.Offset(1, 1 - Target.Column).Select
Application.EnableEvents = True
End Sub

To install right click on the worksheet tab, view code,
insert the above macro.



--