Learning new Microsoft Office tricks in "just a minute"
It’s so frustrating when you do Ctrl+C to copy some text, and when you paste it into something like an email, it copies over all the text formatting too. So you head over to Notepad to paste it there (to lose the formatting), and then you copy and paste it into something like Outlook or Teams to get just the text. Today I learned that you can use Ctrl+Shift+V (or Option+Shift+Command+V on a Mac) to paste over content without formatting! Here’s how that works…
If you have a spreadsheet that has a lot of column filters set, it can be laborious (and probably error-prone) to try and delete all the filters one at a time. But by using the CTRL – SHIFT – L keyboard shortcut, you can turn them all off at once. Here’s an example…
Sandra showed me a cool trick today that is useful for anyone using Microsoft Teams. You can quickly get a pop-up list of all the keyboard shortcuts that might save you a few seconds every time you do something out in Teams. Here’s how it works…
Are you the type of person who likes to use keyboard shortcuts when you’re working with software? If you do, here’s a great resource for keyboard shortcuts in Excel.
I know a number of my readers are keyboard wizards, and they would prefer do most/all functions using keyboard shortcuts rather than the mouse. I just learned this shortcut today… sending an Outlook email using the CTRL + ENTER shortcut…
Not being an Excel guru, I tend to do things manually instead of using features that can make things a LOT faster… such as selecting all the data in an Excel spreadsheet. I’ve been known to do a lot of scrolling to find the end points and dragging to select everything. It’s a lot easier just to use the CTRL-A keyboard shortcut!
If you use the CTRL+Tab key combination, you can move across the section tabs from left to right at the top of your OneNote notebook.
We were recently asked about what shortcut keys exist for Skype. Sandra found a great list of all the Skype shortcut key combinations at Microsoft’s support.office.com site.
Two Excel keyboard shortcuts that makes selecting data a lot easier…
One Minute Office Magic 