Selecting rows with keyboard

[Guest]

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.

 

[JW]

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

 

[Guest]

PERFECT!

Thankyou

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

 

[Rick Rothstein \(MVP - VB\)]

To my knowledge, there isn't a way to delete an entire row

and cause the following rows to shift up using the keyboard.

To select the entire row, hit the Home key, then press and hold the Shift
key while you press End Key, Shift+<RightArrow>, End Key, Shift+<RightArrow>
(yes, you appear to need to do it twice). Now that the row is selected,
press and hold the Alt Key while you press the 'E' Key followed by the 'D'
Key.

Rick

 

[Earl Kiosterud]

Scott,

Shift - Spacebar will select the row. Shift - Down will select additional rows. Ctrl -
minus will delete the row(s). That's a true delete, which will shift rows up. Or use
Delete to clear the row.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[Guest]

tnx earl...vry hlpful indeed..

Scott,

Shift - Spacebar will select the row. Shift - Down will select additional rows. Ctrl -
minus will delete the row(s). That's a true delete, which will shift rows up. Or use
Delete to clear the row.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[David Biddulph]

Try looking up "keyboard shortcuts" in Excel's help.

 

[JW]

Scott,

Shift - Spacebar will select the row. Shift - Down will select additional rows. Ctrl -
minus will delete the row(s). That's a true delete, which will shift rows up. Or use
Delete to clear the row.

--
Regards from Virginia Beach,

Earl Kiosterudwww.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

Thanks for that Earl. I didn't know about the Ctrl + - shortcut.

 

[Dave Peterson]

Just to add to Earl's shortcut...
ctrl-spacebar will select the entire column.