Deleting a row in Excel is possible in several ways:

-A "Ctrl" "-"

-A right-click "Delete Rows"

-A right mouse button after selecting the entire row in the left-field line numbering "

I found another kind of removal, all known, but few probably used (not me of course, I use it often oooochen) - through the Customize Quick Access Toolbar.

So, in this example, we see that we must remove the green line. How do you usually do manually?
Like this?

Or like this?

I found, though I certainly was not the first it has made a very quick decision that all this can be done very simply, using the buttons Alt.

Well, we are investigated.
Example: The green line with the twos, we need them and just delete it.

In the top pane click the right mouse button and choose "Customize Quick Access Toolbar"

In the drop down menu tab "Home" Looking for the hidden button-click "Delete rows from a worksheet(1)"

• Click add (2)
• Move our added command button in the top (the top Why write below)(3)

 

Now we have a new button on the toolbar, click "Delete row"

Now the most important:

• Hold the Ctrl key and click your mouse on those lines that you want to delete
• Let go of the Ctrl key and press Alt.
• When clamped Alt, press the number 1

Voila, there were only non painted lines - Units

 

Why I wrote above should move the team? Yes to make things easier to press a combination, because it would be better to press a combination of Alt-1 than Alt-2009

Watch the video