Excel question for the hivemind: I've got a chart I update daily in which I input a value in a particular cell, and the value is then computed as an average in the next cell. There are a series of columns like this: Value, Average, Value, Average, and so on. (1/2)
Some columns, when I plug in the value on a given day, the next cell automatically fills with the appropriate formula. For others, I need to paste from the day before. The automatic ones just started doing it without me telling them to. How do I tell the others to do it? (2/2)
To clarify: The feature I'm trying to replicate is that sometimes Excel figures out that I'm going to want to put a specific formula in a certain cell, and auto-inserts that formula into a blank cell without me having to paste it in.
It's like Clippy, but actually useful. (And unobtrusive.)
To put it another way, when I fill in a value in (say) B32 I need to copy-and-paste the formula from C31 to plug it into C32, but when I type a number in in D32, E32 will automatically fill itself with the formula from E31. I want all the columns to do what E is doing.
Thanks all for suggestions! Unfortunately, the closest I've gotten to success is a couple of people saying "I've got spreadsheets that do that too, but I've never been able to figure out how to make it happen on purpose." Sigh. At least now I know it's a thing, and a mystery.
Holy crap this worked. It's not quite a way to replicate the behavior, but it's an entirely functional workaround. Yay!
https://twitter.com/ckoppelman/status/1368651358782521346
• • •
Missing some Tweet in this thread? You can try to
force a refresh
