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
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
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
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
Shrink to Fit in Excel
MS Excel: Data Too Long for the Cell? Use Shrink to Fit & Let Excel Fix the Problem for You! Ever have data in MS Excel that's just a bit too long for the cell? What happened? Did the column widen to accommodate? Or, maybe you got the infamous ##### to let you know that the number didn't … Continue reading Shrink to Fit in Excel
Using the Clipboard in MS Office
MS Office 2007 & 2010: I Thought That the Clipboard Could Hold More Than One Item? You're right - it can... you were used to accessing something like this via the Edit menu in older versions of MS Office: A clipboard pane where all the items that have been copied or cut, are stacked in … Continue reading Using the Clipboard in MS Office
Add Information to Excel Formulas
MS Excel: A Little Something More to Say Ever find yourself working on an Excel formula and wondering how in the world the person you're handing this off to will ever understand some of the more complex calculations? Short of writing lengthy documentation, or spending a whole lot of time walking them through things piece … Continue reading Add Information to Excel Formulas
Disable the Zoom Slider in MS Office
So, here's the scenario... you're happily working in one of the newest versions of an MS Office program and things are progressing nicely. Then suddenly it happens - the program window goes "wacky" and you find yourself looking at the file after a zoom in or zoom out. What happened there? To be quite honest … Continue reading Disable the Zoom Slider in MS Office