+ Reply to Thread
Results 1 to 3 of 3

Cut and paste rows with formulas

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    2

    Cut and paste rows with formulas

    I am new to Excel and have inherited a spreadsheet that has 2 seperate sections that need to stay seperate. Attaching the sheet so you can see what I am talking about. I need to move a row from dedicated line 2 (which is Column H) to dedicated line 1 and have the start time (which is column M) formula continue to be sequential. Any way to accomplish that without having to correct the formula in the start time column?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-17-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    82

    Re: Cut and paste rows with formulas

    If I did fully understand your question, I have the opinion that you always have to correct the formula.

    If you do copy paste values, you will lose the formulas (which I believe it's not what you desire since the start time will not be sequential and not according with your calcs).
    However if you do cut/move that line from dedicated line 2 to dedicated line 1 it will consider the previous formula, which means it will consider the previous line start time from dedicated line 2 and not from the previous line from dedicated line 1 as it should.

    But this looks really simple to solve (correcting the formula of course):

    1. Select the mentioned entire row through a Shift+space shortcut
    2. Cut it throught Ctrl+X
    3. Select the destination row, again through Shift+space
    4. Paste it using Ctrl+"+(add button)" (in order to add a row there)
    5. At column "Start time" position yourself on the cell before(top) of the newly moved row, copy
    6. Alt+E+S (Paster Special) , and select Formulas
    7. That's it


    Kind Regards,
    FCarv

  3. #3
    Registered User
    Join Date
    09-05-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Cut and paste rows with formulas

    Is there any way to cut and paste without having to correct the formula?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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