Microsoft Excel is the one of the most popular spreadsheet programs used worldwide. It has a variety of features such as data storage, creating reports and charts, using mathematical functions, performing statistical analysis, ability to connect to databases, making use of pivot tables, V-lookups etc. One such very useful feature within Microsoft Excel is the … Continue reading Creating Macros in MS Excel
Export or Import a Custom QAT and Ribbon in MS Office
The other day we talked about a method to copy and paste the OFFICEUI files (which contain all the custom User Interface information for one of the Office 2010 programs). It's a good method, but it requires you to know where to look for the files. It's a great way to save your customizations, in … Continue reading Export or Import a Custom QAT and Ribbon in MS Office
Apply a Slide Transition to All Slides in MS PowerPoint
If you're a person who likes to use transition effects when moving your presentation from one slide to the next and favor consistency in your choice of transition, then you've probably found yourself looking at something like this, while you select a slide, apply the transition effect, move to the next slide, apply effect, move to the next slide...
Deleting Multiple Comments in Excel
MS Excel: Delete Multiple Comments at Once If you've got an Excel worksheet that contains a lot of comments, it can be a bit of a pain to remove them all when you're done. Think about it. If the worksheet is a large one and you've managed to accumulate quite a few comments, it's going … Continue reading Deleting Multiple Comments in Excel
Increase the Number of Undos in PowerPoint
Do you "undo" a lot in MS PowerPoint? Ever run out of undo steps and wish for more? If your response was yes, here's what you need to know about PowerPoint to get a few (or a lot) more undo steps added to your list. Use the Office Button / File tab of the Ribbon, PowerPoint Options button, to get … Continue reading Increase the Number of Undos in PowerPoint
Text Rotation in MS Word
MS Word: Moving In a New Direction Ever find yourself looking to rotate text in MS Word? Maybe you're trying to make a flyer with phone number tabs across the bottom? Or, maybe you need to run some text down the side of a document and you don't want to use WordArt, just simple text. … Continue reading Text Rotation in MS Word
Reset the Default Save Location in MS Office
When you open a file in one of your MS Office programs, do you find that you're always navigating away from "My Documents" to some other folder? Ever wish that it would just open up to that location in the first place? If so, here's the good news... you can set each program to go directly to whatever location … Continue reading Reset the Default Save Location in MS Office
Applying Options in MS Office
When you’re in the Options dialog box for one of these newest MS Office programs, have you ever noticed this part of a section header? (You’ll notice that not all section headers have one…) Even if you did notice it…did you take the time to investigate? For many people the answers are no… either they … Continue reading Applying Options in MS Office
Unclogging the Outlook Outbox
Dale from OR asks: I can receive email messages with no problem in Outlook, but all my outgoing email stays in my Outbox and won't send. Can you help? Despite possibly being the world's most ubiquitous e-mail program, Microsoft's Outlook e-mail client is not without its flaws. Now in its 14th iteration, Microsoft Outlook is … Continue reading Unclogging the Outlook Outbox
Resetting the Default View in Excel
MS Excel 2007 & 2010: How Do You Like to View It? We all have one... you know, that preferred view of our MS Excel worksheets. Some people like to see everything in the Normal view. Others prefer the Page Layout view, where Excel shows the physical breaks between each page, as well as the … Continue reading Resetting the Default View in Excel