Concatenating Excel data with Fill Justify

This is one of those tips you may not know about, but it will be a lifesaver if you only have to use it once. Using the Fill > Justify feature in Excel, you can concatenate data from multiple Excel cells into a single cell. It’s easy, and here’s how it works…

Multiple Office Clipboards in Office applications

Having done this tip gig for a number of years now, I don’t often find a tip that blows my mind. It’s even more rare that I find a tip that blows my mind, *and* has apparently been there for years. Today’s tip fits that bill… you can have up to 24 selectable Office Clipboard entries to choose from when you’re working in Outlook, Word, Excel, or PowerPoint. Even better is that they are shared across all those programs!  Here’s how it works…

Adding shadowing to your PowerPoint images

This is a subtle tip (or at least it should be in my opinion). When you add an image into a PowerPoint slide, it normally starts out in a pretty flat state. However, you can use the Shape Effects option to add some depth to the image, and it can make your slides look a lot more professional. Here’s how to do that…

Using the Screenshot feature in Excel

Here’s a feature in Excel that I never noticed before… like *that’s* a surprise! 🙂 If you need to add a screenshot in an Excel spreadsheet (perhaps for documentation), you can use the Screenshot feature that’s built into Excel… and you can manipulate the image once it’s out there! Here’s how you do that…

Pinning SharePoint document libraries to the Windows Quick Access area

If you use document libraries in SharePoint a lot, you’re probably best friends with the Open In Explorer option that launches the SharePoint document library in the Windows File Explorer interface. However, one of my co-workers (Sara Rice) brought this tip to my attention… you can pin that document library to the Windows File Explorer’s Quick Access area for faster access in the future. Here’s how that works…

Starting Outlook in something other than Inbox

It’s so common, I don’t even think about it any longer… when you start Outlook, it opens up in the Inbox. However, I saw a posting today by Jason Womack that tossed out the assumption that you *have* to start Outlook that way. Here’s how you can open it up in any folder you’d like…