+ Reply to Thread
Results 1 to 9 of 9

How to make a cell's formula automatically fill into other cells in column of table?

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    301

    How to make a cell's formula automatically fill into other cells in column of table?

    It usually does this on it's own, but sometimes like now it doesn't, but it gives me options one of which to revert the formula to what the other cells have, but in this case I want to do the inverse and change the other cells to what I've changed in this particular cell. Thanks
    Excel 2010

  2. #2
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: How to make a cell's formula automatically fill into other cells in column of table?

    hi juntjoo, try drag the formula from the first row of the column and copy down, then see if subsequent formula change will automatically update rest of rows..
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

  3. #3
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    301

    Re: How to make a cell's formula automatically fill into other cells in column of table?

    thx, yeah, tried that first thing as I usually do and that usually does it, but not this time.

  4. #4
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    301

    Re: How to make a cell's formula automatically fill into other cells in column of table?

    thx, yeah, tried that first thing as I usually do and that usually does it, but not this time.

  5. #5
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    301

    Re: How to make a cell's formula automatically fill into other cells in column of table?

    actually, after messing with it, now instead of displaying the results of the formula, it's displaying the formula itself! Is this a separate issue or related and will be solved once solving the original issue? Hopefully...

  6. #6
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: How to make a cell's formula automatically fill into other cells in column of table?

    make sure cell format is "general"?

  7. #7
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    301

    Re: How to make a cell's formula automatically fill into other cells in column of table?

    didn't help

  8. #8
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: How to make a cell's formula automatically fill into other cells in column of table?

    probably it's time to upload a sample of your file

  9. #9
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    301

    Re: How to make a cell's formula automatically fill into other cells in column of table?

    okay, apparently, you gotta remove the = first, complete changes, then go back in and re-add the =. As far as cell becoming default formula, I tried again, but this time pasting ONLY the formula. Though I don't remember ever having to do that before. Thanks for your help.

+ 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