Where my articles grow up before they go public

Category Microsoft Office & VBA

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… Continue Reading →

Setting up Office 2007 for Canadians

Launch Microsoft Office 2007 Language Settings Ensure that only the following 2 languages are in the Enabled Editing Languages list: — English (Canada) — French (Canada) Set Primary Editing Language to: English (Canada) Click OK to save.

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… 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… 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… 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… 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… 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… 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…. 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… Continue Reading →

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… Continue Reading →

Microsoft Word Numbering Explained

Here are some excellent references for figuring out outline numbering styles in MS Word. The third link below by Shauna Kelly really helped me out and helped me stabilise outline numbering so it would stop breaking. Word Numbering FAQ Automatic Numbering… Continue Reading →

Microsoft Office Macro Security

Using Templates with Macros Getting macros to work can be a problem if you want to distribute templates or documents which contain macros using an intranet, email, or want to be able to store such files in more than two… Continue Reading →

Excel UDF – Get URL Hyperlink Address

Need to get the hyperlink from a cell in Excel? This can be especially helpful after you’ve cut and pasted a list of links from a webpage into or opened a webpage in Excel. You can easily do this by… Continue Reading →

Online Manuals

Here is a list of useful manuals Content Management Systems (CMS) / Websites Website Baker WordPress Programming Languages CSS HTML Javascript PHP vbScript

Mail Merge

Did You Know? You can use Microsoft Word’s Mail Merge feature: To create and print letters and other documents With information in Excel (bonus 6 minute video) To do an electonic mailing in Outlook and send e-mail messages

Copyright © 2024 TNG Consulting Inc.

Theme by Anders NorenUp ↑