remove line

[OlgaBorodneva]

How can I make Excel to remember the choice of removing the lines - i want to make it go up every time (ctrl+ "-")

[#2 · Accepted solution]

@OlgaBorodneva 

Select (ctrl+ "-")

after that F4  is for repeat last action.

Keyboard shortcut to delete a row in Excel

Excel 2013

Shift+Spacebar to select the row.

Ctrl+-(minus sign) to delete the row.

Excel 2016

Shift+Spacebar to select the row.

Ctrl+-(minus sign) to delete the row.

Undo, redo, or repeat an action

To repeat something simple, such as a paste operation, press Ctrl+Y or F4 (If F4 doesn't seem to work, you may need to press the F-Lock key or Fn Key, then F4).

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

Thank you so much! F4 works!!!

[#4]

Thank you for your feedback.
I am glad that I could help you.
I wish you continued success with Excel

* Kindly Mark and Vote any reply if it helps please (Click Like and Mark it as Best Answer), as it will be beneficial to more Community members reading here.


Nikolino