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. AnonymousMay 9, 2012 at 1:29 PM

    thanks

    ReplyDelete
  2. AnonymousJune 5, 2012 at 1:56 PM

    thanks

    ReplyDelete
  3. AnonymousNovember 17, 2012 at 2:01 AM

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

    ReplyDelete
    Replies
    1. UnknownJuly 23, 2013 at 3:39 PM

      yes specially for laptop users not having exclusive numeric keypad.

      Delete
  4. AnonymousJanuary 14, 2013 at 6:41 PM

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

    ReplyDelete
  5. UnknownJuly 23, 2013 at 3:38 PM

    Thanks Arvind.

    ReplyDelete
  6. AnonymousDecember 17, 2013 at 12:47 PM

    Thanks, great help!

    ReplyDelete
  7. UnknownFebruary 8, 2014 at 1:20 PM

    Thanks, very useful.

    ReplyDelete
  8. AnonymousApril 24, 2014 at 9:12 PM

    Thanks a lot !!

    ReplyDelete
  9. AnonymousAugust 1, 2014 at 9:00 AM

    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
  10. sky custom - writing customerMay 17, 2017 at 1:39 PM

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

    ReplyDelete
  11. http://resume-writer.net/blog/page/7May 25, 2017 at 8:55 PM

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

    ReplyDelete
  12. how search for a word in MS WordJanuary 17, 2018 at 3:38 PM

    Whatever has been discussed in this article is quite interesting.

    ReplyDelete

Post a Comment

Popular posts from this blog

Alternative for SUMIF and SUMIFS

Image
Ever wondered while using "SUMIF" function, the sum range cannot be more than one column!!  This indeed is a big drawback while using a large data set where you need to sum matching certain conditions. I often end up using multiple sumif with "+" which makes the formula very long. So was thinking of some alternative that can make life easier. Thanks to the search engines these days, I did come across a workaround. Refer to the above image: In the above example, I have a table with 4 columns where H1 and H2 are identifiers. H3 and H4 is the data which needs to be summed up. Condition 1 (alternative for SUMIF): I need to sum values of H3 and H4 where the identifier H2 is "Y". The formula will be =SUM(IF(B2:B5=B9,C2:D5)) followed by Ctrl + Shift + Enter which will make it a array formula. The final formula will look like this:  {=SUM(IF(B2:B5=B9,C2:D5))} Condition 2  (alternative for SUMIFS) : I need to sum values of H3 and H4 where the
Read more

Solving issues with "VLOOKUP"

Image
VLOOKUP syntax We often encounter "#N/A" while using VLOOKUP function to compare two lists. One of the most common problems that give rise to this error is extra spaces either to the end or to the beginning of the string. What's the way out? The simplest way out is to use "TRIM" function as a sub function. Example While trying to use VLOOKUP in the normal course, the result will be "#N/A", whereas with TRIM nested in the VLOOKUP function will give the positive result. (TRIM function removes the unwanted spaces in the beginning and end of a string.)
Read more

Excel Keyboard Shortcuts - Handy during day to day work

I've had few posts earlier on few excel shortcuts. Navigation powered by "Ctrl" in Excel Shortcut to insert current date in a cell Shortcut to AutoFilter So, here I am, back with some more interesting shortcuts which will make your excel spreadsheet experience simpler. Let me start with some "CTRL" combinations which will be very handy for formating cells to match your requirements: CTRL + 1 : Opens the "Format Cells" dialog box CTRL + 2 : is to make the contents of the cell BOLD (this is a toggle key, to unbold use same CTRL + 2) CTRL + 3 : is to make the contents of the cell ITALICS (this is a toggle key) CTRL + 4 : is to underline the contents of the cell (this is a toggle key) CTRL + 5 : is to strike through the contents of the cell (this is a toggle key) CTRL + 9 : is to hide the entire row (to unhide use SHIFT + CTRL + 9) CTRL + 0 : is the hide the entire column (to unhide use SHIFT + CTRL + 0) CTRL + ~ : is to show or
Read more