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 rig...
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.Hi JimGleason
maybe you could upload a sample file with non-sensitive data, so we can investigate easier.
