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
  9. Simplenote permits you to work just with texts - there is no help for delineations, connected records, and information in different configurations. An optimal choice for fast notes - indeed, for the people who are not used to being occupied by pictures and other sparkle while offering viewpoints.

    ReplyDelete
  10. Brave browser on Chromium, in the same way as other different programs. It upholds expansions like the Chrome program and is not difficult to download on Windows and Macintosh. Even though it's somewhat more confounded, you can likewise introduce Courageous on Linux

    ReplyDelete
  11. Midjourney pursued nevertheless requests to me principally in light of the fact that finding great references for textures is normally truly challenging. Obviously you can return to different themes, nature offers a ton of motivation in tree husk, dead wood, rock developments or you search for motivation yourself in pictures by notable craftsmen who have managed the actual subject.

    ReplyDelete
  12. Sniffies is a really blended swarm. DL, bi, wedded, and inquisitive folks are attracted to Sniffies since it's not difficult to be pretty much as unknown as they'd like. It's likewise simple to find brilliance openings and cruising regions for a fast connect. Kinksters and horndogs are on Sniffies since they know it's the fastest no bologna method for attaching.

    ReplyDelete
  13. The functions included in the program provide basic management needs. Not only record and playback buttons are available, but also positioning on the track.

    ReplyDelete
  14. GoodNotes is one of the most famous note-taking applications on the Application Store and right now costs $7.99 to download. Beginning around 2011, GoodNotes has been the most loved computerized notebook for a great many clients who utilize the application consistently to record, compose, share notes and sort out their viewpoints.

    ReplyDelete
  15. I for one had loads of fun with GeoGuessr and truly partake in its drenching. It's a cool game and a pleasant program insight, so to look at it and are charmed by the possibility of a geology game in view of Google Guides, visit them or download the application.

    ReplyDelete
  16. Midjourney can make cutting edge private engineering including plants. The program works like Dall-E. The calculation utilizes text guidelines to make relating pictures. The apparatus is at present in open beta. Midjourney utilizes a freemium plan of action with a restricted complementary plan and a paid variation that offers quicker access, bigger limit, and extra elements.

    ReplyDelete
  17. Snapseed can measure up to proficient realistic editors with one significant benefit. This is all there is to its convenience. Beforehand, great photograph altering was conceivable just on a PC. Presently it's not difficult to get by with a tablet and, surprisingly, a cell phone. It will be dominated by the powers of every individual who wishes, notwithstanding the power and strength. Crude amendment in programmed mode will actually want to feature and tone the light and dull sides of the picture, making it more clear.

    ReplyDelete
  18. GoodNotes likes to assume of itself less as a solitary scratch pad or fastener for numerous thoughts and more as a shelf for coordinating various note pads that perform various errands -, for example, a day to day organizer, a conventional journal, a sketchbook or a cover loaded with increased PDFs on a particular point.

    ReplyDelete
  19. If you are someone that is about to take the Texas driver’s license test, you are in the right place. In order to make a clean sweep through the test, you’ll need to have sufficient information regarding the Texas rules of the road. As the wise say, practice makes perfect, taking practice tests like the ones below will give you a higher chance at passing the actual test.

    ReplyDelete
  20. However, I can offer general guidance on how to use CapCut to create a video combining Pokémon footage with the song "Bad Liar" by Imagine Dragons. Please note that you should ensure you have the necessary rights to use the Pokémon footage and the song before proceeding with any video project. Here are the steps:

    ReplyDelete
  21. Logic Pro is a professional music production software developed by Apple Inc. It is a powerful digital audio workstation (DAW) that is exclusive to macOS, and it offers a wide range of tools and features for music composition, recording, editing, mixing, and mastering. Logic Pro is widely used by musicians, producers, and audio engineers across various genres of music production.

    ReplyDelete
  22. Notability In addition to there is the likelihood that you say, I have more exceptional capabilities here, that implies, investigate them, what's the distinction, that implies, there's only more here, again from formats, over everything that you can take there once more . Yet, you don't be guaranteed to require it. In view of that, you can examine it and search in the display

    ReplyDelete
  23. Procreate était une application exclusive pour les appareils Apple tels que l'iPad et l'iPhone, et elle n'était pas disponible pour les ordinateurs PC. Cependant, il existe plusieurs alternatives disponibles pour les utilisateurs de PC qui souhaitent créer des œuvres artistiques numériques similaires à ce que Procreate offre.

    ReplyDelete
  24. As you venture deeper into the abyss of Tag After School, mastering gameplay is key to surviving the horrors that await.

    ReplyDelete
  25. Rick Ness’s journey to stardom began in the heart of the Alaskan wilderness, where he worked as a dedicated gold miner for many years. His life took a dramatic turn when he joined the cast of “Gold Rush,” a show that follows miners’ lives in their quest for gold.

    ReplyDelete
  26. The accuracy of the results produced by DeepNude in generating nude images from clothed images can vary.

    ReplyDelete
  27. SmartNews This application will allow you to read only the most important and popular news from around the world from sources such as NBC News, TechCrunch, The Huffington Post, Bleacher Report, Quartz, The Verge, Vox.com, Reuters, AP, Perez Hilton and more. The SmartNews app allows you to download news to your device for offline reading. In addition, the application allows you to determine your location to provide accurate weather forecasts and provide news relevant to your region.

    ReplyDelete
  28. Nudifying is a remarkable AI tool that offers a unique creative and entertainment experience. Remembering the importance of responsible use and respect for privacy when using this tool is crucial.

    ReplyDelete
  29. A big thank you for your outstanding blog post! The way you explore different facets of [subject] and provide practical takeaways is commendable. Your dedication to delivering high-quality content is truly appreciated.

    ReplyDelete
  30. OhSo Hero presents challenges that test a player's skill and wit. Learn effective strategies for navigating through levels and overcoming the obstacles that await.

    ReplyDelete
  31. Craiyon AI serves as a catalyst for transformative design experiences, offering a blend of AI-powered assistance, intuitive tools, and collaborative capabilities.

    ReplyDelete
  32. Unleash the magic of artificial intelligence and transform your words into captivating visual masterpieces with SoulGen AI, the ultimate online AI art creation tool. Our platform merges cutting-edge technology with the boundless creativity of the human mind, allowing you to bring your imagination to life in ways you’ve never experienced before.

    ReplyDelete

Post a Comment

Popular posts from this blog

Excel Keyboard Shortcuts - Handy during day to day work

Alternative for SUMIF and SUMIFS - Part 2 (SUMPRODUCT)