How To Save An MS Excel 2016 Graph To A PDF File

excel-chart-export
PDF is the format to use when you want to publish documents online. PDF is easily one of the most common file types found online and it's used to publish not just documents but also presentations, reports, and catalogs. The thing with a PDF file is that while the format is exceptionally popular the app that lets you create or edit it, Adobe Acrobat, is rarely used. For the most part, others apps like Photoshop are used to compose a PDF file and export to the format. Owing to the format's popularity a lot of apps support exporting to PDF and MS Office is no different. You can easily create a document in MS Word and export it as a PDF file. Likewise you can export an Excel sheet to PDF. If you're looking to export just a single graph or chart and not an entire worksheet to PDF here's how to do just that. Read More

Use Outline View In MS Word To Reorder Headings In A Large Document

ms-word-reorder-headings
We shared a tip a while back on how selecting a collapsed heading in MS Word selects everything; images, tables, sub-headings, under it, making it easy to cut, copy, and paste quickly. If you're looking to copy a section from one document to another, this is possibly one of the easiest ways to do it. If however you have a large document that you need to reorder headings in you might want to do it in Outline view. MS Word's Outline view has a tool that lets you select headings and move them up/down in the document. Read More

How To Create A Master Document And Add Subdocuments In MS Word 2016

ms word 2016 show doc
MS Word has long had a really useful feature that allows users to manage large documents and their subsections that they're collaborating on by separating sections into different files. The subsections or subdocuments as they are called make it easy to update and export parts of a large document. The feature isn't just great for large documents but also for smaller ones that have many seemingly independent sections. You can make a Master Document in MS Word 2016 any time i.e. it's not something that must be set when you first create a document. You will identify a document as the Master Document and then proceed to identifying the subdocuments in it. Subdocuments can be split or merged with other subdocuments and we will take a look at how to do that. You can also add a different document as a subdocument to an existing master document and we'll be touching on that as well. Here's a walk-through to making a Master Document and adding subdocuments to it in MS Word 2016. Read More

How To Delay Sending Emails In Outlook With A Rule So You Can Undo Send

outlook-rule-sent
Gmail has a built-in feature that lets you 'undo' an email that you've sent. It's there to help you avoid last minute email accidents such as forgetting to attach a file. It gives you a brief window in which you can stop a sent message from being delivered. It's widely reported that this feature has saved lives. If you use MS Outlook and would like a similar feature on the desktop app, you can set it up yourself with an Outlook rule. Here's how. Read More

How To Customize & Remove The Title Bar Background In MS Office 2016

ms-word-background
MS Office 2016 doesn't have a long list of awesome new features. The new additions made to Office 2016 are few and they aren't for everyone. Moreover not all new features are functional in nature. MS Office 2016 has made an effort to make the UI better looking. It comes with a dark and light theme now, and it's added a background design to the title bar. The design by default shows clouds but you can change it or remove it altogether if you like. Here's how. Read More

Move Your MS Word Auto Recovery Folder To The Cloud To Avoid Losing Documents

ms-word-auo-recovery
If Microsoft Word ever crashes or you experience a system crash while you have an MS Word document open you can likely recover most if not all of your document through the auto-recovery copy that the app saves regularly. In most cases, this will always save you when something goes wrong. If you're however looking to be extra safe for when Murphy's law kicks in a night before something important is due, you should consider changing the MS Word auto recovery folder's location to a cloud drive. You can use just about any service that has a desktop app and syncs files to the cloud. Dropbox, OneDrive, and Google Drive are all great options. Here's how to change the Auto Recovery folder's location. Read More

How To Check The Readability Of Document In MS Word

readability-stats-ms-word
Writing a technical document isn't the most fun thing to do but it requires a person to be concise and use the simplest of terminologies. What's more is that you likely know the comprehension level of your target audience and you know they will understand the terms used as well as the context they have been used in. The same can't be said for non-technical writing . Any time you're writing fiction, or even if you're writing a report, it has to be easy to understand. The readability of a report isn't just about how dense the vocabulary used is but also how complex your sentences are. MS Word has a built-in readability tool that checks the readability of document on two different indices. Here's how to use it. Read More

Stop MS Word From Opening Documents From The Internet In Protected View

-ms-word-protected-view
When you download an MS Word document either from a cloud drive or from an email it opens in the 'Protected' view. In the Protected view, just about all editing options are disabled and the most you can do is copy text from the document. The document of course isn't locked to the Protected view and should you wish to edit the document, you can quickly switch over to the editing mode. It's only a few extra clicks but if you would rather get right down to editing a document and this security measure is an annoyance, here's how you can turn it Off. Read More

Find Which Slide In Your PowerPoint Presentation Is The Largest In Size

ppt-publish-slides
PowerPoint lets you add different types of media files to a presentation. Anything from images, videos, and audio files can be added to a slide. The support for so many different types of media no doubt make it exceptionally easier to create engaging presentations but at the same time, with each image, graph, document, video, and audio file that you add, the presentation itself becomes bigger and bigger in size. If the size of a presentation file ever becomes a problem, either when emailing it, or when sharing it via a cloud file sharing service, you will either have to find an alternative method to send the file or you will have to cut it down to size. Here's how you can check which slide in a presentation is the largest in size and cut back where it really matters. Read More

How To Get A Dark Grey Theme In MS Office 2016

office 2016 dark theme
Productivity apps ensure that they are distraction free and that the interface they offer makes it easier for the average person to concentrate. Some of the best apps do this exceptionally well but what many will often neglect is make sure an interface doesn't strain a user's eyes. Very few apps are built with both light and dark themes making them easy to use in a well lit room but are practically a strain to use at night. Microsoft's Office suite of apps was no different up until the 2016 version which comes with a built-in dark grey theme that you can apply to all apps in one stroke. Here's how. Read More

5 Popular MS Office Tips From 2015

ms-office-posts-2015
Microsoft's Office Suite has no parallel. Google tries with its cloud documents option, and the iWorks Suite of apps does come close but Office has been around for ages and it's grown into an exceptional product. Knowing how to use the basic Office apps is often a prerequisite for many jobs and what might get you a shoe-in, or perhaps make your work easier and more presentable is if you know your way around these apps better. We covered a few tips for Word, Excel, and PowerPoint in 2015 and here are the five best. Read More

How To Round Off All Decimal Values In A Row Or Column In MS Excel

excel-value-round-off
Working with numbers comes with a few rules and one such rule that deals with numbers in decimals is to round them off. If you work with Excel, you know that it doesn't round off numbers unless they're being treated as currency. If you're dealing with other types of numbers i.e. non-currency ones, and need to round off numbers to certain decimal point, there's a pretty simple way to do it. Read More

Use RGB Values To Set A Custom Color For Text In MS Office

ms-word-more colors
All Microsoft Office Suite apps have template support; you can create a standard document layout, complete with a locked down or predetermined color scheme, set margins and layouts, and save it as a template. The apps in the Office Suite come with a lot of pre-loaded color schemes but if they aren't enough for you, you can always make your own. When it comes to colors and color schemes, you have a choice to use the default colors of a theme, a shade of one of the default colors, or set a custom color. If you're trying to use your company's colors in the document,  here's how you can get an exact match with the RGB values of a color. Read More

How To Add A Full Page Background To An MS Word Document

ms-word-page-color
If you ever wanted to print out an MS Word document on a colored page, you would likely just type the document out on a plain white background and insert a colored page in the printer when you print it. The same can't be said if you want to add an image to the background of a page. There's the watermark option to make do with but if you're interested in adding a full page background image to a document and have it tile properly if needed, there's a built-in feature to do just that. Read More

How To Properly Crop Pictures Inside An MS Word Document

ms-word-crop
Managing pictures inside an MS Word document has always been tricky. Simply moving an image is enough to upset the setting of an entire document. MS Word has lots of great pictures editing features one of which is the Crop feature. As the name signifies, this feature lets you cut out a portion of your pictures and it seems simple enough to use on the surface. If you have used it though, you know that the crop feature will not delete the cropped out portion of the picture. To do so, you need to perform one extra step. Read More

How To Create & Save Custom Cover Pages In MS Word

ms-office-save-cover
MS Office comes with some very nice cover pages that you can use for official reports, dissertations, assignments etc. The covers provide placeholder elements that make up a cover page in different layouts. Some are picture heavy while others are minimal in design giving you a reasonable variety to choose from. That said, the covers meet generic needs and it's very obvious when you've used one.  If you'd like to create and use a custom cover page in MS office, here's how. Read More

How To Swap Values Between Cells, Rows, Or Columns In MS Excel

swap-cells-excel
When selecting text in MS Word, you might have accidentally clicked at the wrong time, or released the mouse button when you didn't intend to and ended up rearranging text. Swapping text, when done accidentally is annoying but a swap function is nevertheless very useful and if you think about an application like MS Excel, a swap function is a must have. With MS Excel, you have cells filled with data that you may need to swap between cells, or even between rows and columns. Fortunately MS Excel has a swap function that lets you swap date in cells easily. Here's how it works. Read More

Recover Unsaved MS Word Documents With Version Control

word-recover-unsaved
It isn't until you lose a very important document moments before a deadline that you truly get in the habit of compulsively saving documents. I'd be lying if I said I didn't sometimes accidentally try and save the tab I currently have open in my browser but I'd rather be safe than sorry. If you have however had the misfortune of your computer crashing, or accidentally hitting 'Don't save' when closing a document when you meant to save it, there's a way to recover it. It works even if you don't have file history enabled in Windows because the recover feature is in MS Word itself. Read More

Disable Spelling & Grammar Check For A Paragraph In MS Word

ms word - proofing
Last week, we showed you how to disable spelling and/or grammar checks in MS Word for an entire document without turning it off for every document. While it may be useful to turn spell-check off for a document, the chances that you write one where it's completely useless or more of a hindrance than a helping tool are small. What you're more likely to find yourself writing is a document where portions of it need to be excluded from the spelling and grammar check while others need it. Here's how you can disable it for portions of a document but keep it running for the document on a whole. Read More

How To Copy & Paste Text Formatting In MS Word via Keyboard Shortcuts

ms-word-formatting
The first group project I ever did in college was a mess. Besides not knowing how to collaborate on a project, we had little to no idea what a finished and perfectly formatted project report looked like. We did know that one poor soul in the group would be in charge of compiling the work everyone had done into a presentable document. I only wish we'd discovered the format painting tool back then. When I did finally discover it I was amazed for about two weeks and then wishing there were an easier way to do it i.e. keyboard shortcuts. Fortunately, there is. MS Word lets you copy and paste text via keyboard shortcuts but it also lets you copy and paste format from selected text though it isn't as widely known. Here's how. Read More