this post was submitted on 30 May 2025
1151 points (97.8% liked)
Microblog Memes
7762 readers
2404 users here now
A place to share screenshots of Microblog posts, whether from Mastodon, tumblr, ~~Twitter~~ X, KBin, Threads or elsewhere.
Created as an evolution of White People Twitter and other tweet-capture subreddits.
Rules:
- Please put at least one word relevant to the post in the post title.
- Be nice.
- No advertising, brand promotion or guerilla marketing.
- Posters are encouraged to link to the toot or tweet etc in the description of posts.
Related communities:
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Text that doesn't wrap and goes off screen. Scrollbars that shrink to a single pixel. Universal undo (open multiple Excel Windows and do stuff in all of them. When you undo it will follow your activity instead of being local to the window). Excels crappy copy.
One of the many extremely basic issues with Excel. Absolutely disgusting.
Excel does all those things it does because it's always done those things it does, and if Microsoft changes it everyone will pitch a fit and probably sue because now they have to retrain their entire accounting department.
The undo and copy behavior for Excel started with office 365. Also the repeat after hitting the end of the redo stack.
I disagree. There are louts of things that would not change old behavior but add so much convenience. Like cell reference for diagram ranges. But nope, we are stuck in 199...4?
I love some of the newer things like LET and LAMBDA. But I'd kill for structured references to be properly implemented everywhere. I'm a bit over using INDIRECT to get around it (when I can).
Yes. I have build dynamic diagrams with indirect, I feel ashamed.
Let us use Python instead of cancerous VBA. You can not even add comments to your variable definitions. Or named vars in functions. Why do I even need macros at all to simply define a function?
You don’t, any more. At least not for relatively simple functions.
LAMBDA combined with the name manager lets you do custom functions even in a regular .xlsx workbook.
You don’t get the full control flow and extended functionality you do in VBA, and Python would be amazing of course, but I find LAMBDA covers about 90% of use cases.