Selecting rows with keyboard
 

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.

Selecting rows with keyboard
 

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

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

Selecting rows with keyboard
 

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

Selecting rows with keyboard
 

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...
-----------------------------------------------------------------------
"Scott R" wrote in message
...
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.

Selecting rows with keyboard
 

tnx earl...vry hlpful indeed..

"Earl Kiosterud" wrote:

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...
-----------------------------------------------------------------------
"Scott R" wrote in message
...
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.

Selecting rows with keyboard
 

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

"Scott R" wrote in message
...
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.

Selecting rows with keyboard
 

On Sep 20, 2:23 am, "Earl Kiosterud" wrote:
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...
-----------------------------------------------------------------------"Scott R" wrote in message

...

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.

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

Selecting rows with keyboard
 

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



Earl Kiosterud wrote:

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...
-----------------------------------------------------------------------
"Scott R" wrote in message
...
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.

--

Dave Peterson