Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is the only way to copy and paste a row in excel to create a new row, cut the old row, paste the old row into the space just created for the new row, adn then go back to the now blank old row, select it, and delete it? Is there a way to cut a row and make it disappear and make everything shift upward and then paste a row and make everything shift downward without having to create a new row and then delete the old row after cutting it?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Put your cursor anywhere in the row, press & hold Shift down. Then drag the row (up or down) so it ends in the new location. HTH
    Gre

  3. #3
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If you don't want to use the keyboard, you can also right-click the row, then select "Cut", then right-click the destination row (this row and the ones below will move down) and select "Insert cut cells".
    This eco-post is made of recycled electrons

  4. #4
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Malcolm: that doesn't work for me in Excel 2003. It just highlights all of the rows up to the row that I want as a destination row.

    Stephane: that causes the row that I cut to be cut, leaving a row of empty cells, and then replaces the contents of the row above which I want to paste, causing that row to lose its data, rather than shifting everythign down one row.

    Regards,

    JMT

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In order to use Malcolm's method, you need to click on the border of the selected cells in order to drag them to the new location.

  6. #6
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by jmt356 View Post
    Stephane: that causes the row that I cut to be cut, leaving a row of empty cells, and then replaces the contents of the row above which I want to paste, causing that row to lose its data, rather than shifting everythign down one row.
    It seems that you have used the plain "Paste" menu option instead of "Insert cut cells".
    This eco-post is made of recycled electrons

  7. #7
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Mbarron: it worked!

Posting Permissions

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