Short cut for deleting rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I am trying to make my work a little faster and see if there is a shorter way to delete a row besides the right click>
 
----- Leeza wrote: ----

Hello I am trying to make my work a little faster and see if there is a shorter way to delete a row besides the right click

I am working in xp
 
I guess you could create a macro
activecell.entirerow.delete
and assign to a shortcut
or an worksheet change event macro that said if "d" in col a then delete the
row

--
Don Guillett
SalesAid Software
(e-mail address removed)
Leeza said:
Hello I am trying to make my work a little faster and see if there is a
Click to expand...
shorter way to delete a row besides the right click>
 
Leeza, Here is two way with the key board, don't know if its faster, control
key and minus then r and enter, or Alt, e, d, r, enter. Or you could use a
macro and assign it to a keyboard shortcut

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

Leeza said:
Hello I am trying to make my work a little faster and see if there is a
Click to expand...
shorter way to delete a row besides the right click>
 
Leeza

Tools>Customize>Commands. The Edit category has two buttons for deleting rows
and columns.

Move either or both of them to your Toolbar.

One click and delete row.

Can't get much quicker than that.

Note also, the Insert Category has buttons for inserting rows and columns.

Gord Dibben XL2002
 
Back
Top