SOLVED

remove line

%3CLINGO-SUB%20id%3D%22lingo-sub-2408435%22%20slang%3D%22en-US%22%3Eremove%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2408435%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20make%20Excel%20to%20remember%20the%20choice%20of%20removing%20the%20lines%20-%20i%20want%20to%20make%20it%20go%20up%20every%20time%20(ctrl%2B%20%22-%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2408435%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2408899%22%20slang%3D%22de-DE%22%3ESubject%3A%20remove%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2408899%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1069426%22%20target%3D%22_blank%22%3E%40OlgaBorodneva%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20(ctrl%2B%20%22-%22)%3C%2FP%3E%3CP%3Eafter%20that%20F4%20is%20for%20repeat%20last%20action.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2Fkeyboard-shortcut-to-delete-a-row-in-excel-5b26b97c-f506-7773-3caa-d868e850b3fb%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EKeyboard%20shortcut%20to%20delete%20a%20row%20in%20Excel%3C%2FA%3E%3C%2FP%3E%3CP%3EExcel%202013%3C%2FP%3E%3CP%3E%3CSTRONG%3EShift%2BSpacebar%20%3C%2FSTRONG%3Eto%20select%20the%20row.%3C%2FP%3E%3CP%3E%3CSTRONG%3ECtrl%2B-(minus%20sign)%3C%2FSTRONG%3E%20to%20delete%20the%20row.%3C%2FP%3E%3CP%3EExcel%202016%3C%2FP%3E%3CP%3E%3CSTRONG%3EShift%2BSpacebar%3C%2FSTRONG%3E%20to%20select%20the%20row.%3C%2FP%3E%3CP%3E%3CSTRONG%3ECtrl%2B-(minus%20sign)%3C%2FSTRONG%3E%20to%20delete%20the%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2Fundo-redo-or-repeat-an-action-84bdb9bc-4e23-4f06-ba78-f7b893eb2d28%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EUndo%2C%20redo%2C%20or%20repeat%20an%20action%3C%2FA%3E%3C%2FP%3E%3CP%3ETo%20repeat%20something%20simple%2C%20such%20as%20a%20paste%20operation%2C%20press%20Ctrl%2BY%20or%20F4%20(If%20F4%20doesn't%20seem%20to%20work%2C%20you%20may%20need%20to%20press%20the%20F-Lock%20key%20or%20Fn%20Key%2C%20then%20F4).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2411874%22%20slang%3D%22en-US%22%3EBetreff%3A%20remove%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2411874%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much!%20F4%20works!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies
best response confirmed by allyreckerman (Microsoft)
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.

Thank you so much! F4 works!!!

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