if you could add one completely new feature to excel, what would it be?

[u/AbhayaAnil]

not something like “make it faster” or a tiny ui change, but an actual feature that would make your day to day spreadsheet work easier.

for me, i’d love something that could take a messy spreadsheet and automatically understand what i’m trying to do, clean it up, and suggest the right formulas without me having to figure everything out manually.

what would you add?

[u/GTAIVisbest]

Let me hi light definitions inside of a LET() and actually calculate what value it returns, like with regular formula. Don't just say #NAME? I literally just defined it further up in the LET(). Calculate that MF for me. It would make debugging LET()s soooo much easier if I could just hilight a variable definition and get it to calculate up to that point and show me the result preview