Productivity Tip: Copy and Paste without Junk

Have you ever tried to copy information from a web page or a MS Word document and got more than you bargained for when you pasted it into another Word document or web page? Text often comes with unwanted junk in the form of extra formatting codes. The solution is usually to use Paste Special and then choose to paste as Plain Text or Unformatted text. Word actually gives you an opportunity to also choose whether you want to paste using the sources formatting — where you got the content from, target formatting — uses the formatting in the current … Continue reading

Adding New Comments to the Mini Toolbar in Word 2010 & 2013

Unfortunately the Mini Toolbar in Word 2010 and 2013 can’t be customized to add an “Add Comments” button. However, here are a few other ways you can accomplish this. After highlighting your text using the keyboard or a mouse, do one of the following: Keyboard: Press CTRL-ALT-M. A new comment will be created and your cursor will be positioned ready for you to type your comment. Mouse: Right click and select New comment which is the last option at the bottom of the context menu (available in Word 2013 or later). Keyboard or Mouse: Press ALT-R (or click the Review … Continue reading

Excel Formulas – Converting between double letters and numbers

Converting numbers (1, 2, 3…676) to two letters (AA, AB, AC…ZZ) in Excel Formula 1: =CHAR(65+TRUNC((A1-1)/26)) & CHAR(65+MOD(A1-1,26)) Converting two letters (AA, AB, AC…ZZ) to numbers (1, 2, 3…676) in Excel Formula 2: =(CODE(MID(B1,1,1))-65)*26 + CODE(MID(B1,2,1))-64 Example The figure bellow can be re-created by adding numbers from 1 to 5 in column A. Enter formula 1 in B1 and formula 2 in C1, Copy the formulas in B1 and C1 into the cells below. … Continue reading

Reparing Windows 7

Here are a few links to tools and help to guide you through repairing Windows 7. IMPORTANT: Use at your own risk. Always backup your computer before trying these as they can potentially make the situation worse or even impossible to use your computer. At the very least, create a system restore point. Fix Microsoft Windows 7 Windows 7: System Restore Windows 7: How to Boot to the System Recovery Options in Windows 7 Windows 7: SFC /SCANNOW Command — System File Checker Windows 7: Repair Install Windows Repair Windows 7: Service Pack 1 New cleanup tool for Windows old Hot Fixes… … Continue reading

Decrementing Word Number List Without Hard Coded Value

There are times when you might want to create a list in reverse numbered order. For example, if you are listing projects or accomplishments in reverse chronological order (most recent at the top) and want to number them. You’ve probably seen many sites around the web that have solutions to the problem: How do you make a list of numbers that count down? Most solutions will have you hard code the total number in the formula. They look something like this: { =35 — SEQ CountDown } This works great but the day you decide to add or remove one, you will have to … Continue reading

Remove Red and Green Underlines in Word

Using Microsoft Word, you’ve created a professional high quality report at work, or a resume if you are looking for a job. It’s ready to be published to the target reader. The only problem is, it’s full of red (potential spelling mistakes) and green (potential grammar mistakes) squiggly underlines. Adding all the words that are underlined in red to your dictionary will only affect your own computer. When the document is opened on someone else’s computer, those lines will be back and you won’t even know it. Is it possible to get rid of not only the red but also the … Continue reading

Excel Quick Tip: Toggle View Formulas

Did You Know? Pressing Ctrl ~  in Microsoft Excel to toggle the visibility of formulas in the worksheet cells. It is the equivalent of: Office 2003: Clicking Tools > Options > View Formulas checkbox Office 2007 & 2010: Clicking the Formulas ribbon menu > Show Formulas button. If you are having problems switch back to the calculated results when you press CTRL ~, check to make sure that there isn’t an ‘ in front of the formula. If there is, remove it and press CTRL ~ again if necessary. … Continue reading

Making the Transition from Office and Visio 2003 to 2010

On this page… Classic menus Show/Hide the Office Ribbon Training and Support File Compatibility Multiple Versions, Same Computer Additional Information Moving from Microsoft Office 2003 or earlier to Office or Visio 2007, 2010 or 2013 can be overwhelming at first. Be patient. It will take a little while but you will get so used to it that you will find yourself lost should you ever go back to Office 2003. Classic menus for Microsoft Office 2007, 2010, 2013 and Visio 2010 The first thing you will notice is that the menus are gone and have been replaced by what is … Continue reading

Make a Powerpoint Presentation Deck Automatically Run When You Double Click on It

To make a deck automatically start playing when you double click on it, simply save it a PowerPoint Show (.ppsx or .pps) instead of a PowerPoint Presentation (.pptx or pps). For older .ppt files, you can use is to just rename the filename extension to from .ppt to .pps. Unfortunately that trick doesn’t work anymore as of Powerpoint 2007 and 2010.

PowerPoint 2010 Tip: Removing Speakers Notes / Comments / Annotations

Here is a quick tip on how to easily remove speakers notes in Powerpoint. This new feature was not available in previous versions (maybe in 2007). Back then, each note had to be removed manually. Here are the 5 easy steps to removing speakers notes: Open a copy of your presentation in PowerPoint 2010 so that you don’t loose your original version that includes the notes. Click on the File tab in the top left corner and then on Info. Click on the Check for Issues button and then on Inspect Document Make sure the Comments and Annotations and the Presentation Notes … Continue reading