Selecting rows with keyboard
PERFECT!
Thankyou :)
"JW" wrote:
On Sep 20, 12:06 am, Scott R wrote:
I do most my excel work without my mouse however I cannot seem to find a way
to select rows and delete them without using it. I can select the contents of
the entire row but cannot delete the row itself. I know it sounds lazy but it
would save time. Any suggestions would be appreciated.
To my knowledge, there isn't a way to delete an entire row and cause
the following rows to shift up using the keyboard. But, you could
create your own macro and assign it to a shortcut key.
Sub this()
' Keyboard Shortcut: Ctrl+y
'
Selection.EntireRow.Delete Shift:=xlUp
End Sub
|