Shortcut key to remove a Full Row in excel?

[Abbas999]

Hi Experts,

I am looking for a shortcut key (if possible) to remove full row in excel. Basically I have a huge list with:
Company Name - First Name - Last Name - Email Address

What I am doing is Going through each row and when there is a Email which match company name instead of first and last name I have to remove the full row. This will be a very bore task if i each time select the full row by mouse and delete it. I would rather like to press a single button from keyboard to remove the current row and move on to next.


Please tell me if there is a way to do this?

Thanks in advance

 

[Caribeiro77]

VBA would do this..
Can you post 4 or 5 examples of data and what rows to be deleted?

 

[Abbas999]

VBA would do this..
Can you post 4 or 5 examples of data and what rows to be deleted?

Would VBA be working instead? Like Pressing a shortcut will remove the whole row?

 

[Caribeiro77]

Yes...we could use a shortcut to activate the code and delete the desired rows...

 

[Abbas999]

Unknown
	A	B	C	D	E
1	Company Name	First Name	Last Name	Email address	Contact Job Title
2	Company 1	Jack	Smith	Email1@example.com	Title 1
3	Company 2	Jack	Smith	Email1@example.com	Title 2
4	Company 3	Jack	Smith	Email1@example.com	Title 3
5	Company 4	Jack	Smith	Email1@example.com	Title 4
6	Company 5	Jack	Smith	Email1@example.com	Title 5
7	Company 6	Jack	Smith	Email1@example.com	Title 6
Sheet1

 

[Caribeiro77]

Ok, and on this example what rows would you want to delete?

 

[SpillerBD]

CTRL +"-"
Deletes the current selection; Cell, Range, Row(s) or Column(s)
Will still prompt for Cells or Range on how to shift remaining cells.

 

[Abbas999]

Not sure it is a huge list. I just need a shortcut button. because i have manually review each row and when i found it needs to be remove want to press a shortcut key to remove the whole row.

 

[Abbas999]

Not Quick @spillerBD It will ask each time and also the the tick is not every time on "entrie row"

 

[Caribeiro77]

Sorry but i think that the shortcut spillerBD gave you is the onlu«y one to delete entire rows..
Other than that..don't know...like i told you..only with VBA...