•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What are your most used keyboard shortcuts that aren't the obvious ones?
Our take
Keyboard shortcuts can significantly enhance your productivity, especially those that fly under the radar. While most users are familiar with Ctrl+C, Ctrl+V, and Ctrl+Z, many powerful shortcuts remain hidden gems. For instance, using Ctrl+Shift+Arrow allows for quick selection of entire data ranges, while Ctrl+Space and Shift+Space make selecting columns and rows effortless. Even Alt+E+S+V for paste special values can save you valuable time. What are your favorite lesser-known shortcuts that streamline your workflow?
We all know Ctrl+C and Ctrl+V. And everyone loves Ctrl+Z. But I'm curious about the shortcuts you use constantly that might not be as well known. The ones that save you time every single day but most people dont think about.
For me its Ctrl+Shift+Arrow to select entire data ranges in a split second. Changed how fast I can format stuff. Also Ctrl+Space and Shift+Space for selecting whole columns or rows without touching the mouse. And Alt+E+S+V for paste special values even though theres probably a faster way now.
I work with messy reports a lot and these little shortcuts add up over a week. Probably shave hours off manually selecting things.
What are the shortcuts you use constantly that new users might not know about Or even just the ones that are underrated. Always looking to speed up my workflow and theres so many hidden ones in Excel that nobody talks about. Ctrl+, for todays date is another one I only discovered recently.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- What’s the one Excel trick or formula that changed everything for you?I feel like Excel is one of those tools where a single formula or shortcut can save hours of work. For me, learning things like basic formulas and shortcuts already made a big difference, but I know there’s still a lot I don’t know. So I’m curious: What’s that one Excel trick, formula, or feature that made your work much easier or faster? Could be something simple or advanced - anything that you think more people should know. submitted by /u/Suspicious_Twist386 [link] [comments]
- Do you use VBA regularly or have you moved entirely to Power Query and formulas?I have been using Excel for years and VBA was always my go to for automation. Lately I have been seeing more people say they barely touch VBA anymore because Power Query and dynamic arrays cover most of what they need. I still use VBA for things like automating reports across multiple files or generating custom email bodies from data. But I am wondering if I am behind the curve. For those of you who work in data heavy roles, what is your current workflow? Do you still use VBA regularly or have you replaced it with other tools? Curious if I should be spending more time learning Power Query and the newer formula features instead of maintaining my VBA skills. submitted by /u/ProfessionalOk4935 [link] [comments]
- I’m researching how people automate repetitive Excel/CSV workflows in day-to-day work.I’m building a desktop tool to set up these processes visually, but before going further I want to understand what actually hurts today. I’m not selling anything in this post, just trying to learn from real-world cases. If you work with this kind of thing, I’d really appreciate your input: - What was the last annoying Excel/CSV workflow you automated? - How often does it run? - What was the most frustrating part: combining files, cleaning data, standardizing columns, deduplicating, exporting, etc.? - Are you the only one who runs it, or do other people need to run it too? - What do you use today: Power Query, VBA, Python, Power BI, something else? Thanks! submitted by /u/Remote-Ad-6629 [link] [comments]
- I’ve been using Excel more lately and I’m trying to understand some of its more advanced features without making everything overly complicatedWhen working with data that has multiple conditions or needs to update automatically, what are the most efficient functions or tools to use? for example, is it better to rely on formulas like XLOOKUP and FILTER, or are there built in tools that handle this more cleanly? Also, how does excel handle performance when formulas start getting longer or more complex? Is there a point where using too many formulas slows things down significantly? What are the best built-in features in Excel for handling complex data in a simple way? submitted by /u/icepix [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#rows.com#Excel compatibility#real-time data collaboration#Excel alternatives#big data management in spreadsheets#conversational data analysis#financial modeling with spreadsheets#intelligent data visualization#real-time collaboration#data visualization tools#workflow automation#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel#keyboard shortcuts