Results 1 to 3 of 3

Thread: How to insert multiple rows from one sheet into another

  1. #1
    Board Regular JenniferMurphy's Avatar
    Join Date
    Jul 2011
    Location
    Silicon Valley, CA, USA
    Posts
    1,122
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default How to insert multiple rows from one sheet into another

    Is there a way that I can insert a range of rows (18:35) from Sheet1 in between rows 17 & 18 in sheet2?

    Everything I have tried ends up replacing at least one row in the target sheet. I suppose I could insert the right number of rows and then overwrite them, but that's a double pain.

    I hope someone can show me a way to insert the rows between two existing rows and preserve all of the formatting and formulas.
    Using Office 2007 Pro on Win XP Pro

  2. #2
    New Member
    Join Date
    Sep 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to insert multiple rows from one sheet into another

    Jennifer firstly select the cells you want to copy from the row, so don't select a range of columns, just select the rows. Copy.

    Now right click in the other sheet 'insert copied cells'. Note that it won't trigger 'insert copied cells' if you have hidden rows. All your rows must be unhidden.

    Hope that helps.

  3. #3
    Board Regular JenniferMurphy's Avatar
    Join Date
    Jul 2011
    Location
    Silicon Valley, CA, USA
    Posts
    1,122
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to insert multiple rows from one sheet into another

    Quote Originally Posted by Lebene View Post
    Jennifer firstly select the cells you want to copy from the row, so don't select a range of columns, just select the rows. Copy.

    Now right click in the other sheet 'insert copied cells'. Note that it won't trigger 'insert copied cells' if you have hidden rows. All your rows must be unhidden.

    Hope that helps.
    Thank you. That works perfectly.

    I would update your instructions a bit to this:

    To copy or move a range of rows or columns and insert them between two existing rows or columns, use the Insert Copied/Cut Cells right-click function:

    • Go to the source sheet.
      • Select the range of rows or columns to be copied or moved.
      • Copy (Ctrl+C) or cut (Ctrl+X) them to the clipboard.

    • Go to the target sheet
      • Make sure that only a single cell is selected by clicking on any single cell. If a range is selected, the insertion point will be before the range, regardless of the location of the right-click.
      • Right-click anywhere in the row or column where the rows or columns are to be inserted before.
      • Select Insert Copied/Cut Cells.


    The source and target cannot overlap. To insert a range inside that same range, first copy it to a place outside that range, then move the copy to inside the range.
    Using Office 2007 Pro on Win XP Pro

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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