+ Reply to Thread
Results 1 to 4 of 4

Cells keep on skipping

  1. #1
    Forum Contributor
    Join Date
    09-15-2012
    Location
    las vegas
    MS-Off Ver
    excel 2007
    Posts
    146

    Cells keep on skipping

    I copied and pasted the formula from E6 to G6. What I wanted to happen is for G6’s formula to be =F6+B3*D6-1 instead of =F6+E3*D6-1.

    I just want to know if there’s a function that I can use so I can just copy the formula from E6 to G6 and I6 not bother changing the formula for G6 and I6 just because the second cell on the formula skips a cell.


    Thank you.
    Attached Images Attached Images

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Cells keep on skipping

    Use the $
    see here:http://www.excelforum.com/excel-form...ns-please.html

    Post number 2 explains the different referencing techniniques

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2010
    Posts
    4,327

    Re: Cells keep on skipping

    put dollar sign on the column ref s


    =$A1 + $B1 -> when copied the ref A and B column will not change.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2003-2010-2013
    Posts
    2,031

    Re: Cells keep on skipping

    I don't think there a way of doing this. Cells references in formulas are change according to relative displacement of start en end position of formula. There nothing to do about that.
    Pierre Leclerc
    _______________________________________________________

    DON'T FORGET, GIVE US SOME REP!
    Click on the STAR "Add reputation" icon at the bottom.

+ 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