The Clear Formats Button: Did you ever inherit a badly formatted document just wish you could start over? Use Ctrl+A to select all the text and on the Home tab, in the Font group, click the Clear Format button. Now, put in your own formatting!
Q. Can I have a shortcut to insert a Quick Part?
If you find yourself looking for the most recent/best presentation from which to make a new one, or pondering the question, “Now, how did I do that last time?” it’s time to get familiar with custom PowerPoint templates. The basic steps are pretty straightforward: With the presentation from which you’d like to create a template […]
Q. Can I set up a macro to run automatically in a Word template?
I got this question in a SharePoint class this week: How can I take the email addresses out of an email with a huge “To:” line and create a list for SharePoint? Well, here’s how to do it. 1. Create a blank worksheet in Excel, then switch to the Outlook email with the addresses you […]
Q. I need to perform a calculation if specific text is found inside a cell in an Excel work sheet. It won’t always be in the same place. How would I do that?
If you know what a secondary axis chart is, then you know what a challenge it can be to show disparate values on the same chart. This used to be somewhat cumbersome in older versions of Excel, but with Office 2007 and Office 2010 it’s a piece of cake! For those unfamiliar with the term, […]
Q. When I link two sheets together and a cell in the source sheet is blank, I get a 0 in the target sheet. How do I get rid of the 0’s?
Are you planning a big meeting with lots of moving pieces: Catering, handout materials, AV. Wouldn’t it be great to not have to recreate the meeting attendance data from Outlook to do that? Well here’s how you can. In a meeting where you were the meeting organizer, in the Show group on the Meeting tab, […]
Q. Can I copy someone on an email without sending them the attachments?