+ Reply to Thread
Results 1 to 2 of 2

can't get formulas to fill down. help!!

  1. #1
    Registered User
    Join Date
    03-30-2005
    Posts
    2

    can't get formulas to fill down. help!!

    I recently upgraded to office 2003 and suddenly cannot fill a formula down a column like i used to be able to. any idea why? for example, i have a column A with values 1:5 and column B with values 1:5. in C1 I type =A1+B1 and hit enter. Then, I try to fill this down the rest of the column. However, instead of returning 2,4,6,8,10, i get 2's all the way down the column. Whats even more weird is that the C2 has the formula =A2+B2 and C3 has =A3+C3, but the values are still 2. Whats going on?!? Instead of running the formula, its just copying the cells. If i fill the correct formula in C1:C3 then fill down the remaining couple rows, it'll just copy the above 3 cells, so i end up with 2,4,6,2,4. I just don't get it.

  2. #2
    Registered User
    Join Date
    03-30-2005
    Posts
    2

    bump

    bump________

+ 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