Forum Discussion

OlgaBorodneva's avatar
OlgaBorodneva
Copper Contributor
Jun 02, 2021
Solved

remove line

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

  • 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 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.

      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        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

Resources