Keyboard Shortcut to add/delete rows or columns in Excel

"Ctrl + +" (add rows or columns) and "Ctrl + -" (delete rows or columns) are the easy shortcuts one may remember while adding and deleting rows/columns in Microsoft Excel.

Adding rows or columns:

If you wish to add rows above the current cell... just press "shift + spacebar" (discussed in my earlier post) to select the current row and then press "Ctrl + +". It will insert a row over the current row. Press "Ctrl + +" repeatedly to insert as many rows.

Similarly, "ctrl + spacebar" and then "Ctrl + +" adds a column before the current column.

You may try pressing "Ctrl + +" without selecting a row or a column. In such a case, you may get a pop-up (as shown in the image) where you can choose an option of adding a row or a column.


Deleting rows or columns:

"shift + spacebar" followed by "Ctrl + -" deletes the selected row & "ctrl + spacebar" followed by "Ctrl + -" deletes the selected column.

In case no row or column is selected, pressing "Ctrl + -" gives another pop-up asking you to choose what you want to perform.



Comments

  1. Some users may have to use "Ctrl+Shift+minus sign" to delete rows.

    ReplyDelete
    Replies
    1. yes specially for laptop users not having exclusive numeric keypad.

      Delete
  2. you suck!!! joke only.. thanks man for the info. keep up the good work..God bless

    ReplyDelete
  3. Thanks, great help!

    ReplyDelete
  4. You have to write this things more.Right now there are a
    wonderful number of individuals who are suffering out of concerns similar to fatness
    and substantial body weight in these days. The biggest reason behind this scenario would be the occupied living and variable agenda because of that they
    are unable to spend adequate recognition on their health and wellbeing.
    A number of them don’t have possibly time for
    it to work out. To them, the simplest way to remain healthy
    will be to begin the appropriate health supplements.
    If you want to toward get an effective and tested natural health
    supplement, Forskolin can easily carry out your preferences to much extent.
    The pure extract of Forskolin have been utilized as an powerful weight
    loss supplement.

    Check out my homepage - forskolin before and after pictures []

    ReplyDelete
  5. It's just wonderful that you shared this information and brought a lot of benefit to all your current readers.

    ReplyDelete
  6. Sometimes the help is needed because there are some questions. Thanks for explanation.

    ReplyDelete
  7. Whatever has been discussed in this article is quite interesting.

    ReplyDelete
  8. Do not contemplate https://thekingofdealer.com/pharaoh-casino/ gambling as a way of earning money and solely play with money that you could afford to lose. Remain in control of|in charge of|in command of} your gameplay by using Mr Green’s Predictive Tool, set yourself gaming limits, take a break or self-exclude yourself. For extra info on our Green Gaming instruments please click on right here. If may be} worried about your gambling or affected by someone else's gambling, please contact GamblingTherapy or GamblersAnonymous for help. This game is an ideal adaption of the TV show hit and allows you to choose a Deal or No Deal. Just like within the TV model, the vendor will current you with a closed case, where you can to|you presumably can} choose to say it or spin the wheel with an opportunity at one other cash prize.

    ReplyDelete

Post a Comment

Popular posts from this blog

"CountIF" or "SumIF" with an extra "S" makes the difference...

Excel Keyboard Shortcuts - Handy during day to day work