+ Reply to Thread
Results 1 to 4 of 4

Copying excel formulas

  1. #1
    Forum Contributor
    Join Date
    02-15-2006
    Posts
    107

    Copying excel formulas

    When I copy an excel formula down to the cel below, the formula stays the same, for example if I copy the formula c1 + c2 down it should become c2 + c3, but it stays the same c1 + c2. Any help here? Maybe an add it?

  2. #2
    Forum Contributor
    Join Date
    02-15-2006
    Posts
    107
    Also if I hit f2, then enter, the formula is correct.

  3. #3
    Forum Contributor
    Join Date
    02-15-2006
    Posts
    107
    I am a dummy, my auto calc was off, the formula was correct, just not calculating, how do I set to calculate automatically, not just for one spreadsheet, but for all at once, thanks.

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by JR573PUTT
    I am a dummy, my auto calc was off, the formula was correct, just not calculating, how do I set to calculate automatically, not just for one spreadsheet, but for all at once, thanks.
    Hi,

    I believe that the 'Automatic' is for the workbook, and the current setting will become the default for a newly created workbook.

    hth
    ---
    Si fractum non sit, noli id reficere.

+ 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