We’ve already gone over my top 10 keyboard shortcuts in Excel… I’ve even shown you how to make your own custom shortcuts, using Macro capturing and a little VBA tweaking. But even if you don’t want to dive off the deep end into custom programming, there’s still a way to make quick keyboard shortcuts for some of your most-used actions. Better yet, it’s built right in to Excel, and it’s called the Quick Access Toolbar! Learn how to customize it with your favorite shortcuts and turn them in to easy hotkeys… Continue reading Make Custom Excel Keyboard Shortcuts with Quick Access Toolbar
Tag Archives: Keyboard Shortcuts
Make Your Own Custom Keyboard Shortcuts Using Macros
We all know that keyboard shortcuts are the fastest way to accomplish most tasks in Excel. I already showed you my top 10 keyboard shortcuts, and you can get a free quick reference for them when you join the newsletter. Unfortunately, not every common action in Excel has a keyboard hot-key assigned to it by default. Paste Values, for example, is one of the most common actions when formatting spreadsheets, but the only keyboard access for it is the cumbersome ALT+H+V+V through Excel Key Tips. Here, we’ll show you how to make your own custom keyboard shortcuts with macros by giving Paste Values the convenient CTRL+SHIFT+V it should have had all along… Continue reading Make Your Own Custom Keyboard Shortcuts Using Macros
Top 10 Keyboard Shortcuts to Save Time in Excel
![Keyboard Shortcuts [Image]](https://exceltactics.com/wp-content/uploads/2013/08/KBLead.png)
You know about Copy (CTRL+C) and Paste (CTRL+V), but did you know that almost every menu and operation in Excel can be controlled from the keyboard? Left and right clicks can get a lot done, but knowing your way around the keyboard is often the fastest way to crunch the data in your spreadsheets. Here are the Top 10 keyboard shortcuts in Excel, along with a few extras… Continue reading Top 10 Keyboard Shortcuts to Save Time in Excel