Disable Spelling & Grammar Checks In A Specific MS Word Document

Word Options_proofing
MS Word is one of the most sophisticated word processors available in the market today. I'd say Pages is just as good but I'd be lying. You can use MS Word to write reports, make your CV, write up a great paper with citations and captioned images, insert a smart table of contents and even a table of figures, and much more. With it having so many great tools it makes it perfect for just about any sort of writing. Now imagine Tolkien writing one his epic books in MS Word and you know it would have more red than the flag of Turkey. Sometimes the grammar and spell check in MS Word saves our lives but at other times, it can be simply annoying. If you find you're writing something where the tool is a hindrance, here's how you can disable it for just that one document. Read More

How To Change The Default Save Location For MS Office Apps

When you save a file in MS Word, PowerPoint, Excel, etc, it by default offers to save to the documents library. You do of course have the option to navigate to a different folder and just save the file wherever you want. If you find that you rarely save to the default save location that the MS Office apps offer to save files to, you might want to change it to a location where you save file to more frequently. For each MS Office app, you can set a different default save location and you can even change where the auto-recovery file is saved. Here's how. Read More

How To Rename A Bookmark In MS Word 2013

Templates and Add-ins
Microsoft Word lets you add bookmarks anywhere in a document. You can add a bookmark to a blank space or anchor it to a word or phrase. The bookmarks function as you would expect them to and allow you to quickly jump to a particular part of the document in a matter of clicks. They are particularly useful when the part of the document you want to jump to cannot be set as a heading or section. That said, the bookmark functionality in MS Word has always been rather basic; you can add and remove bookmarks, and you can of course jump straight to one but you cannot rename it. To do so, a third-party tool, i.e. an add-in is required. The add-in of choice is called Bookmark Tool. Read More

Change The Font & Style Of Numbers In An MS Word List

I'm learning about this a good five years too late but you can set a different font for the numbers used in the automated number lists in MS Word. In fact, you can even make them bold, underlined, or in italics without changing the font of the text that follows it. The feature has been around long enough, as far back as 2003. It may escape most people's notice because the option gives no indication that it is meant for just the numbered list. The devil is in details, or more precisely, what is selected when you bring up the font editing window. Read More

How To Extract All Images From MS Office Documents

docx to zip
Microsoft Office is one of the most widely used productivity suites in the world. Online suites are gaining in popularity as is Apple's iWork but Office still enjoys wide appeal. MS Word is one of the go-to apps we use today for just about any and all documentation needs; CVs, reports, research papers, short stories or novels, and what not can all be written in the app. That said, and this is bound to have happened to you, if you ever got a report or even a presentation that contained lots of images that you wanted to use, you would have to save them individually. Fortunately, there is a simple little trick that lets you extract all images from an MS Office file in one go instead of having to save them one by one. This trick works for files with the DOCX, PPTX, XLSX extensions only. Your original file will remain intact and uncorrupted. Read More

Run A Live Poll During A Presentation & Get Instant Results [PowerPoint]

participoll results
If you give presentations a lot, whether you're a speaker, trainer, or it's just part of your job, you may at some point have needed to poll an audience. There are likely some options available out there that let yo do that but Participoll has blown me away. It's a service that comes with a PowerPoint add-on for polling a live audience. Audience members need nothing more than a phone and an internet connection to participate in the poll and you can instantly get your results right there in the presentation. It has a perfectly functional free plan, and a pro-plan which is more than worth its price tag. Here's the rundown of this super amazing service. Read More

Get MS Word To Remove Formatting When Pasting Text From The Browser

The clipboard manager on both Windows and OS X copies the text and any formatting that has been applied to it. When you paste this text into a program that doesn't support rich text like the address bar of your browser or a program like Notepad, the formatting is lost. If you instead paste it into a program like MS Word, or even in a browser based text editor like the Compose email box in Gmail, the formatting is duly preserved and likely to ruin the formatting of an entire email or document. Most text editors have a clear formatting button that you can use to quickly erase any and all text formatting from pasted text but it takes time and is nevertheless annoying. Here's how you can tech MS Word to ignore formatting when you paste text from your browser, or even from a different document. Read More

Get Excel 2013 To Recognize The Comma Delimiter In A CSV File

If you have MS Excel installed on your system, any CSV file you download is automatically associated with the program. Excel is more than capable of opening and editing a CSV file, the only problem is the way it reads the data in the file. By default, Excel is not set up to recognize the comma as a delimiting character. The result is, whenever you open a CSV file, the data looks all wrong. The data in rows is successively added to columns instead of staying in its CSV defined layout. It's hard to read and even harder to work with. Here's a simple way to get Excel to read and display the data correctly. Read More

Customize What Types Of Changes Are Tracked In MS Word 2013

When I learned about the Track Changes feature in MS Word I felt like I'd discovered the secret of life. I've since used it for professional, academic, and personal documentation work. It's a pretty neat tool that makes collaborating on a document easier especially if the people you're working with are averse to trying out some of the online tools that support live collaboration like Google Docs. That said, MS Word tracks everything by default, every little thing. Entering so much as a space will show up with a red highlight which is great when you've got a long report to work on with different people. What's not so great is that formatting changes and  comments will appear as changes too when you may not want them to be tracked. Here's how you can customize what types of changes MS Word tracks. Read More

How To Cross Reference And Link Cells Between Different Excel Files

Linking two excel sheets so that one can read a value from the other is much easier than it sounds and it's a function that a lot of people need. No one has just one Excel file and while it is easy to add data from file to the other, keeping up with the changes so that they are reflected across all files is both time consuming and prone to error. The following little tutorial helps you link a cell from one Excel file to a cell in a different Excel file such that it updates itself. Read More

Copy Text Faster By Selecting A Collapsed Heading In MS Office 2013

A few days ago we covered a little tip on how to get text to collapse and expand on click in MS Word 2013. The trick to it is pretty simple and I originally thought it was useful when viewing a really long document. That isn't something small in terms of convenience especially if you've got a long document with lots and lots of sections in it but it turns out that a collapsed heading is really useful in another common scenario; copying and pasting text. Here's why. Read More

Get Text To Expand/Collapse On Click In MS Word 2013

A good four years ago we wrote about hiding text in MS Word 2010 and the brief discussion on the post put forward a new question; users wanted to insert expandable/collapsible text in the word processor. Back in the 2010 version there was no easy way to accomplish this and for something that should be relatively simple, you would have had to resort to using Macros. In the end, they may not have done the trick in a very refined way. Such was the hasstle of it that we never found a viable and simple solution to it. Fortunately in Office 2013, the feature has been added and is very easy to use, if you know where to look for it. In this post, we're going to show you how to get text to expand/collapse and how to make it look a little refined as well. Read More

Get Custom Templates To Appear On The Start Screen In MS Office 2013

Microsoft provides a fairly large library of templates that users can download for free, for each of its productivity apps. Office also comes packed with a few templates and themes, and if you're looking for something exceptionally original, you can create your own templates or download, even buy them, online. In Office 2013, Microsoft added a start screen that shows popular templates or custom templates each time you launched the app. It makes  it easier to open templates instead of a blank presentation. There is just one little catch; if you download say a PowerPoint template, it doesn't show up on the start screen. Instead you have to browse to where it's downloaded every time you want to open it. This pretty much defeats the purpose of the start screen. The work around is pretty simple though so here's how you can get any template you've downloaded for an Office app to show up on its start screen. This works for templates for all Office 2013 apps. Read More

Disable MS Office 2013 Start Screen & Always Open Blank Documents

MS Office 2013 is without argument the most polished face the productivity suit has ever had, to date. It's an obvious outcome of it being around for years and being improved upon. That said, I don't always like the new start screen in Office 2013 which stalls the actual program being launched. I use Word quite often and I'm still in the habit of launching it from the taskbar and immediately being able to start typing or at times, pasting text. The start screen is often an unnecessary extra step for me and at times very annoying. For anyone in the same boat, there is a simple solution to this problem and that is to disable the start screen. It's an option that can be exercised on a per-app basis for the Office Suit and is very easily reversible. Read More

Import Your MS Office Dictionary To A Different PC Or Fresh Install

Switching to a new PC is a daunting task that means installing lots of of apps again, and setting things up the way you had them on your old system. Setting up a new PC to work like your old one isn't an easy task but what's more time consuming is when your apps have to learn from scratch what your preferences are, or rather when you have to teach them that. This isn't that hard for apps that have an online service working at their backend but when we're talking about an app that functions entirely on our desktop with no way to export and import settings and user preferences, we run into a problem. MS Office now has an online version but it doesn't do much by way of importing or exporting settings and this can be a problem when you have something like the dictionary you created on your old system over the years. Here is how you can port your MS Office dictionary, complete with every change you've ever made to it, from your old PC to a new one. Read More

Clear The Recent Files List In MS Office Apps

MS Office keeps a list of recently accessed files for each app in its Office suite. It's super useful if you're working on different files at the same time, and constantly switch between which one is open. Not only does it make it easier to locate a file you want to open, but it also makes the list accessible within other dialog boxes in the respective app so that you can link to it etc. As useful as the list is, it does lose its utility when it starts showing documents that you no longer need to access. Here's how you can clear the list and start a fresh one in any Office app. Bear in mind that the process is different for MS Office 2003 - 1020, and different for Office 2013. Read More

Hiding The Mini Toolbar In Office 2013

Word Options
Microsoft got a lot of heat with Windows 8 and loyal Windows users were disappointed with the company's attempt at innovation since it ended up sacrificing two of the most iconic features of the OS but Microsoft and its products aren't all a result of trial and error. Take a look at Office 2013 and you can see the company gets a lot of things right in just the one go. The Office productivity suite has everything you could ever need to make a solid well-formatted document, spreadsheet, or presentation. What's more is that it also features many auto-fill options and helpful pop-ups to make formatting and composing a document or presentation easier. That said, one of the chief annoyances is the Mini Toolbar that pops up in all office apps when you select text. For some, this might be helpful but it appears over the text and there isn't an easy way to dismiss it. You can  however, disable it, if it annoys you. Here's how. Read More

Remotely Control Word, Excel & PowerPoint From Windows Phone With MS Office Remote

Microsoft Office has been the productivity suite of choice for many over decades, and is still going strong among its fans and those simply stuck with it alike, especially in the corporate sector. One major use of the suite is for presentations, but it isn’t always too convenient to manage the slides through the PC itself while giving a presentation. There are many tools out there to remotely control your presentations, both in form of dedicated hardware as well as apps for popular mobile platforms out there. If you are using  a Winodws Phone device, you no longer have to rely on any third-party tools for the purpose, as Microsoft has just released an official Office Remote app for Windows Phone that lets you remotely control Word, Excel and PowerPoint right from your phone. Read More

Disable Typing Animation In All Office 2013 Applications [Tip]

If you’ve started using the new Office 2013 (or version 15, as some may call it), you might have noticed the new typing animation. As you type, the animation is pretty obvious to note. Some may term it as a modern and contemporary addition to the flavor of the new Microsoft Office Suite while others would simply get annoyed. It is for such people that we present a registry hack to get rid of the fancy typing animation. This hack has a reversible effect and if you feel the need to revert to the default graphics, you are just a click away. Moreover, this will apply not only to Microsoft Word, Excel, PowerPoint and the like, the impact would hold for the entire suite. Through this post, we are in no way undermining the typing animation, but only presenting an alternative for the annoyed ones, out there. Read More

What’s New In Microsoft Outlook 2013? [Review]

Microsoft recently announced the next version of Office suite – Office 2013 (codenamed Office 15). Steve Ballmer, the current CEO of the Redmond giant, unveiled Microsoft Office 2013 Consumer Preview, in San Francisco, but as of now, Microsoft is calling the new version as Office 365 Consumer Preview, and has made it available as Home, Small Business and Enterprise editions. This is the first time in history that the Office suite is designed by keeping desktop and touchscreen devices in mind, particularly when Windows 8 is just months away from its GA launch. One of the most powerful and frequently used applications in Office, is the Outlook. Outlook 2013, akin to other programs in the suite, has received much love from the developers, and now looks more polished and elegant. Basically, it’s the same old Outlook with an improved functionality, aesthetics and ergonomics. We decided to do a brief overview of the new Office Suite, and an in-depth review of the new features, changes and enhancements that are made to MS Outlook. Read More