+ Reply to Thread
Results 1 to 5 of 5

How to insert a row down?

  1. #1
    Registered User
    Join Date
    12-02-2019
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    2

    How to insert a row down?

    Hi!

    I know this sounds ridiculously simple, but how can I insert an entire row UNDER a selected row? No matter what I try, Excel always insert the row above the selected row.

    Thanks!

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,831

    Re: How to insert a row down?

    If you want to insert a row between rows 10 and 11, select row 11 and "Insert Row".

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: How to insert a row down?

    excel will always insert the row above the row you select.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Re: How to insert a row down?

    If you are in a TABLE, you have the option of Inserting new Rows either ABOVE or BELOW

  5. #5
    Registered User
    Join Date
    12-02-2019
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    2

    Re: How to insert a row down?

    Quote Originally Posted by FDibbins View Post
    excel will always insert the row above the row you select.
    Ok, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Vba that moves cells with text, (up and to left, insert row/ insert copied cell)
    By sergi117 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2018, 03:12 PM
  2. Macro insert multiple sheet and insert age band based on numbers
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-01-2017, 01:47 PM
  3. [SOLVED] Enable the Insert icon in Developer tab > Controls > Insert in Excel 2010
    By pedapudipradeep in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2014, 12:41 PM
  4. Replies: 6
    Last Post: 10-02-2014, 06:31 AM
  5. [SOLVED] VBA codes to insert the rows and copy the first entire row text and insert sheet
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2013, 05:05 AM
  6. Insert header , hide rows and insert page breaks
    By dwx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2013, 03:28 AM
  7. Help - Insert method of Range class failed - Selection.Insert Shift:=xlToRight
    By sandy@excelforum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2012, 11:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1