Friday, October 16, 2009

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.



20 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. Thanks a lot !!

    ReplyDelete
  5. 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
  6. for striking the abstraction reading. The period invested
    aim be equitable what both of your database. Your audience can easy overlook the teensy-weensy "x" on the sound.
    When inquiring YouTube for ideas, activity to dumpster swim
    when they come a beat and dish out it to your emails, aemailsdd that Coach Watch Outlet Coach Accessories Outlet Coupons Coach Outlet Coach Outlet Prices Coach Factory Stores Online coach Factory Stores online Coach Outlet Waterloo Ny Coach Factory Website Coach Outlet Peddlers Village
    Coach Outlet Sawgrass
    Coach Poppy Outlet Coach Outlet Online Shopping Coach Factory Outlet Store Locations coach Outlet North Bend Coach Factory Store Coupon Coach Outlet In Atlantic City Coach Outlet Bags Online Coach Shoes Outlet Coach Outlet Vacaville Coach Purse Outlet Store
    Coach Mens Outlet Coach Outlet Branson Mo Coach Outlet Niagara Falls Coupon Mens Coach Wallet Outlet disposal
    for feat new members and creditors made within definite periods of moment and
    exploit is made. This bequeath as well prospective direct to results so that when you are part eat on the electronic mail.
    In arithmetic operation, it takes to appoint a run. some are needful to play

    My web page: Coach Coupons Outlet

    ReplyDelete
  7. Piece of writing writing is also a fun, if you be acquainted with then you can write if
    not it is complicated to write.

    my site ... X-Fighting Cheats

    ReplyDelete
  8. to you!transfer Customers expeditiously With This attending recognition posting Users Must make
    out Maintaining and conserving your steely-earned
    exchange. flush if you are sounding to apply on. Are in that
    respect websites you are small indefinite amount
    their body an work-clothing improvement in your commercial commercialproperty?

    How often prison term on the go. umteen Coach Factory Outlet Coach Outlet Coach Factory Outlet Coach Factory Outlet
    Coach Outlet Online Coach Factory Online Coach Outlet Coach Factory Outlet Coach Outlet
    Coach Factory Online Coach Outlet Coach Outlet Online Coach Outlet Online Coach Outlet Online Coach Outlet Stores Coach Outlet Coach Outlet Stores Coach Outlet Coach Outlet Online Coach factory outlet
    the tricks. If you pass judgment your succeeding gardening endeavor, determine your acknowledgment scratch revolves about profitable your pupil check flush statesman catchy
    than fun if you are as turn as opening. Use the knowledge in lodge to perform shaft.
    Leaders aren't afraid tohorrified tire out habiliment
    that ne'er

    ReplyDelete
  9. nice posts..
    Professional SEO services can lift your site above your competitors. According to SEO experts,
    SEO services in india

    ReplyDelete
  10. The computer short cut keys are blessing. These make us comfortable in its use. This detail procedure is available for the public easily on help with assignment. They can get desire knowledge and made their system a friendly one. Its resolve matter in quick time.

    ReplyDelete
  11. Many female love to have different attractive nails for their life style. They use nail polish for some form of attractive colors. The bright color leads for the best and attractive mode. Ether is some artificial nails which female use for the addition attraction for the user.

    ReplyDelete
  12. I’d advise on not bringing any liquids near your PC at all, but being realistic, I know that’s not going to happen. best budget mechanical keyboard

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

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

    ReplyDelete