Not a member yet? Register now and get started.

lock and key

Sign in to your account.

Account Login

Forgot your password?

Office: Word, Excel, Outlook…  // Office Apps like Word, Excel, Visio, Outlook, Project, Powerpoint, 2003, 2007 and 2010

SOLVED: Video: How to Separate Numbers From Letters In an Excel Text String

UPDATE: Oct 6 2016 – Before you spend a lot of time on creating a formula to separate text from numbers in Excel, watch our two minute video on how to use Excel’s little used but totally awesome FLASH FILL function to do this work for you. UPDATE: Jan 18, 2017 – Ezekiel from New […]


SOLVED: Video: How To Change Outlook Attachments From Linking to SharePoint OneDrive

If you are attaching files from your Office365 Onedrive Sharepoint cloud storage using Outlook 2016 you will find that it provides a lovely drop down showing you your recently edited files.  If you select files from that list and they are stored on OneDrive / SharePoint what it will actually attach is a lLINK to […]


SOLVED: VIDEO: How to Select Copy Paste Only The Visible Cells in Excel

If you want to select copy paste only the visible cells in Excel: In Excel 2007, 2010, 2013 or Excel 2016, select the cells you are interested in On the HOME tab, click SELECT GOTO Click GOTO SPECIAL Click VISIBLE CELLS ONLY Right click on the cells you selected in step 1 and click COPY […]


SOLVED: How to Disable OneNote From Automatically Starting and Putting an Icon in Notification Area

Having OneNote start up by default everytime you sign into Windows is obnoxious.  If you want to get rid of the OneNote icon in system tray / notification area permanently: Launch OneNote Click FILE Click OPTIONS Click DISPLAY uncheck PLACE ONENOTE ICON IN THE NOTIFICATION AREA OF THE TASKBAR Have a nice day   Share […]


SOLVED: How To Fix Error 2503 2502 On Windows 10 When Installing Software

If you are installing (or configuring) software on your Window 7, 8 or 10 PC, you may see ERROR 2503 followed by ERROR 2502: Fortunately there is both a fix and workaround for this problem: HOW TO FIX ERROR 2503 2502: Set the permissions on C:\WINDOWS\TEMP to AUTHENTICATED USERS = FULL CONTROL HOW TO WORK AROUND ERROR […]


20 Dec Posted by in Office: Word, Excel, Outlook..., Other Technologies | Comments Off on Handy Near Free PDF Tools I Need To Get My Job Done!

Handy Near Free PDF Tools I Need To Get My Job Done!

The following are six tools I use regularly to manipulate Adobe Acrobat .PDF’s: Quick PDF Tools – Free – Used to edit PDF document properties one by one.  They say it works on multiple files, but not for me. Batch PDF Pro – $40 and Batch PDF Watermark – Free – The free Watermark/stamp tool […]


SOLVED: Cannot Paste Into OneNote 2016

If you can not PASTE content into OneNote, you are likely in VIEW ONLY mode.  If you have purchased OneNote or you have an Office 365 subscription that includes OneNote, you can confirm this is the problem by: Click the menu bars  (three horizontal lines in the top left corner). Click SETTINGS Click ABOUT confirm […]


SOLVED: How To Export PowerPoint Slides at 300DPI High Resolution

If you need to output your PowerPoint at high resolution you can change the TIFF export quality to 300DPI with a simply Registry modification. How To Set PowerPoint To Export High Res TIFFs: You do NOT need to close PowerPoint before you make this change. Open RegEdit.exe Expand HKEY_CURRENT_USER\Software\Microsoft\Office\<###>\PowerPoint\Options Select EDIT > NEW and click DWORD Value. […]


SOLVED: How to Force Change ACCOUNTS In Office 2013

If you have a user account at the top right of your Office 2013 product and SWITCH ACCOUNT does not work, you can perform a simple registry change to correc the problem: Close all of your Office products (i.e. Word, Excel, Outlook…) Start REGEDIT.EXE Find HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Identity\Identities Delete any of the entries under the IDENTIIES and […]


SOLVED: How To Remove Links From Excel That No Longer Exist

If, when you open and Excel workbook, you receive an UPDATE LINKS message but the linked source no longer exists, you have a problem.  You SHOULD be able to go to the DATA tab > EDIT LINKS button and choose DELETE LINK on the offender but that often does not work. After working on this […]


SOLVED: Overtype / Insert Is Not Working in Word 2013

The short answer is, you are correct.   Microsoft has intentionally disabled that functionality in Word 2013.  In Excel 2013 the INSERT key still overtypes as you would expect. The long answer is, you can easily change it!  Click FILE > OPTIONS > ADVANCED and near the top you will see USE THE INSERT KEY TO […]


SOLVED: How to CALL Microsoft on the PHONE to Activate your Windows or Office Product

Below is the help file from a Windows Activation screen.  It contains all of the phone numbers Microsoft has worldwide for its activation centers: To activate your product over the telephone, use one of the following numbers: Windows activation: (888) 571-2048 Microsoft Office activation (United States only): (888) 652-2342 TTY number: (800) 718-1599 If you […]