How to Protect Workbook Structure and Windows in Excel

There is a “Protect Workbook” feature under the Review tab in Excel, which allows you to protect Excel workbook for structure and windows. This post will introduce this feature and how to use it. Differences between Protect workbook for……

How to Remove Password to Open/Modify in Excel 2010-2016 File

If an Excel file is protected by a “Password to Open” or/and “Password to Modify” but you don’t known (or remember) the password(s), you won’t be able to open or/and modify the Excel workbook. In this case, you would want to……

How to Change Data File (.PST/.OST) Location in Outlook 2016

The default saving location of Outlook data files (.PST/.OST) in Windows is on the disk C, if you haven’t changed it. If huge amounts of data are saved in your Outlook data files, they will occupy your system drive and may make your system ru……

Word 2016 Document Closed without Saving, How to Get It Back

If you accidently closed your Word 2016 document being edited without saving or if the Word document was forced to close due to computer crash or power failure before you could save it, how can you get back the unsaved contents or changes in the Wo……

How to Create and Import .PST File in Outlook 2016 for Windows

.PST file is Outlook data file that stores your emails messages, contacts, appointments, and other items. When you setup an e-mail account in Outlook using POP3 mail server, a .PST file is created and saved in the ‘Documents\Outlook FilesR……

How to Turn on and Set Autosave in Word/Excel 2016

While reading/editing document in Microsoft Word/Excel, occasionally you may encounter sudden power failure, application crash, or computer crash, so that the Word/Excel document is forced to close before you can save the data. In such a case, you ……

2 Ways to Completely Uninstall Office 2016 in Windows 10

In some cases, you may want to uninstall Microsoft Office 2016 and then reinstall it, for example, when Office 2016 apps can’t run properly due to file corruption or other errors. Now this post shows you how to completely uninstall Office 2016 in W……

3 Ways to Remove or Disable All Hyperlinks in Word 2016 Document

How do you remove all hyperlinks in a Word document at once? Get three ways from this page. By default, when you type a web address in Word document, Word can identify the address and automatically create a link that you can follow to navigate to t……

How to Change Default Font for Emails in Outlook 2016

If you are bored with the default email font in Outlook 2016, you can change it based on your preferences. Now this post will show you how to change the default font for emails in Outlook 2016. Part 1: change font for email messages Part 2: change……

How to Lock All or Specific Cells in Excel 2016

Sometimes you may want to lock all or specific cells in an Excel 2016 worksheet to protect the date from being edited, altered or lost. Now this post will show you how to do this. Part 1: How to lock all cells Part 2: How to lock some certain cell……