Multiple Duplicate Worksheets: Click on the first worksheet tab and hold down the Shift key. Keeping the Shift key down, click on the last worksheet. They should all appear white, rather than gray. Now, just start typing. What you do on one sheet will also be on the remaining selected worksheets.
Q. Why can’t I “script” animation in PowerPoint 2010? All I can do is add animation?
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?