•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Has anyone else set up hotkeys for common formulas?
It felt like I was taking the piss when I added them, but when I moved PC's to one without these hotkeys, I really felt the loss - especially when you've got several things in your head and there's that slim chance they'll all fall out if you typo or check the keyboard. Ideally I'd have a keyboard with an extra bank of programmable keys for this, but c'est la monie.
For anyone who hasn't, I'd highly recommend. For anyone who has, are there any you've found useful in your workflow?
I imagine if you're working on similar problems over time then some Lambdas and Lets might be useful, but then it's probably quicker to set up a macro for those cases.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#hotkeys
#formulas
#keyboard
#workflow
#PC
#macros
#programmable keys
#common problems
#Lambdas
#Lets
#typo
#setup
#similar problems