How To Select Only Visible Cells In Excel

Excel lets you hide columns and rows.This is a great way to make a clean, presentable Excel sheet. You can insert formulas in rows and columns, and hide them later. It also keeps other users from editing your formula. If the formula isn't visible, chances are people are less likely to try and edit it. Hiding rows and columns is also a good way to hide the data used to create graphs or dashboards in the spreadsheet. The only problem with hidden cells is that while they are invisible, Excel still selects and copies their content. It still reads the data in hidden rows and columns even if it doesn't show it.  This is a problem if you want to copy only the visible cells in a sheet. Here's how you can select only visible cells in Excel, and copy their content.Read More

How To Open An MS Word Document In Outline View By Default

MS Word has three different display modes; Reading Mode, Print Layout, and Web Layout. When you exit an MS Word file and open it again, it remembers the mode you were using when you closed it. This only applies to saved documents. You can't use this same setting for a new MS Word document. A new MS Word document will always open in the Print Layout. MS Word also has another, lesser known, mode called Outline View. Outline View shows all headings in the document as a list. It's a great way to move one section to another. If you want to open an MS Word document in Outline view by default, you're going to need a little Macro for it.Read More

How To Move All New Emails To A Folder In Outlook Via Quick Steps

Outlook lets you create rules for the emails you send and receive. Rules are a great automation feature that help you control and sort your email. Another equally impressive but less talked about feature in Outlook is Quick Steps. It's an automation feature that automates actions like moving emails or copying them. Using Quick Steps, you can move all new emails to a specific folder in one click. This will move them out of your inbox and into their own dedicated 'Today' folder. It takes very little to set up and you can run the quick step multiple times a day. Here's what you need to do.Read More

How To Stop Saving Sent Emails In Outlook 2016

MS Outlook is one of the oldest desktop email clients in the market. It's also one of the most powerful clients with features such as rules to make it even better. Over the years, the email client has evolved both in terms of features and UI. The UI of Outlook 2016 is vastly different from the UI of Outlook 2010 or Outlook 2007. As with any change in the UI, this too resulted some controls and buttons moving around. Older versions of Outlook had an option that let you stop saving sent emails. In Outlook 2016, this option moved so that you can't find it on the ribbon. Here's how you can stop saving sent emails in Outlook 2016.Read More

How To Fix OneNote Not Saving Local Backups

The OneNote 2016 desktop app has an odd little bug that prevents it from saving local backups. The app takes regular local backups so that you never lose your notes and notebooks. If you have sync enabled across devices or to OneDrive, the local backup may be slightly less important but important nevertheless. OneNote backs up everything automatically but you can also force it to take a back-up anytime. If you're experiencing this bug, the app fails to create local backups of your notebooks. Fortunately, there is a simple way to fix OneNote not saving local backups. Here's how.Read More

How To Customize Heading Levels Shown In Table Of Contents In MS Word

The day I learned to generate an automatic table of contents in MS Word was a glorious one. It saved, and refined many an assignment and project I'd have to do. MS Word lets you auto-generate a table of contents, a table of figures, and a bibliography. The headings in MS Word are what make the auto-generated table of contents work. The headings can all have sub-headings; you can start with a level one heading and add additional sub-headings to it. By default, the table of contents in MS Word shows the first three heading levels. Here's how you can customize heading levels shown in the Table of contents in MS Word.Read More

How To Auto-Refresh Filtered Data In Excel When It Is Updated

Microsoft Excel lets you filter data. It's a useful feature that can help you make sense of large amounts of data. If you lack the technical know-how needed to create a database, this feature is a life saver. The filters are fairly basic and allow you to include or exclude data from a column. The filter extends to and applies to data values in the corresponding rows as well. What the filter doesn't do is auto-update itself. If a value in a filtered column changes, either because you manually updated it or a formula is in use, you have to apply the filters again. A simple code snippet allows you to update filtered columns on the fly.Read More

5 Best MS Office Tips Of 2016

With 2016 at an end, we're looking back at the best tips and tricks we reviewed. MS Office still remains one of the most popular productivity suite of apps. It's so feature rich that you'd be surprised at how many features you don't know about. Microsoft continues to add features on occasion to the apps in Office. It's also flexible enough that existing features can be tweaked to make the apps more productive. Here are the five best MS Office tips we reviewed in 2016.Read More

How To Create A Custom Keyboard Shortcut In MS Word 2016

MS Office is a very powerful productivity suite and MS Word is one of the most powerful word processors in the market. It's feature rich and most of its frequently used tools can be accessed via a keyboard shortcut. It might take you a little time to learn them all but you can increase and decrease font size, activate the format painter, find and replace a word, and more all from your keyboard. Of course, not all tools can be used via a shortcut. There is in fact a whole host of tools in MS Word that have no shortcut. What MS Word gives you instead is a way to record your very own shortcut for almost any tool you like. Here's how.Read More

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

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

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 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

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 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

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

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

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

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

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

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