Forum Discussion
Why formula autofills in some columns, but not others?
I have a financial spreadsheet that performs calcs on multiple accounts based on daily entries in the first few columns. When I fill in the source data, the calcs autofill (auto-populate?) to the right for most, but not all columns. They are (nearly) identical calculations (differing only in which columns to source the data). They worked on last year's spreadsheet, but when I cleared the data for this year's spreadsheet, this problem emerged. Usually after the first few rows, autofill(/auto-populate) kicks in, but not this time for ALL columns, just most of them. What changed?
There is obviously SOMETHING preventing those few columns from auto-populating when all the other columns populate just fine. What should I look for?
THOUGH I *could* start over again (make a new copy of last year's spreadsheet, strip it down and hope that auto-populate remains), I'd rather understand *WHY* it's not working and actually fix it.
8 Replies
Hi JimGleason
usually, you just need to re-enter the formulas in the very first row of the respective columns. Just select the first formula, press F2 for edit-mode and then just enter.
This usually triggers the autofill function for the whole column again.
- Thanks, Martin_Weiss, I'll give it a whirl. Let you know how it pans out.
- Hi Martin_Weiss. No joy. I tried rekeying the formula into the top row - next day, that column still didn't copy the row into the new row. Yesterday, I rekeyed the formula up top, and cut and paste it individually into every cell below in the column ... and today, that column did not replicate the formula when the source data columns were filled. Other columns populated, but not this one.
Hmm.
