What Is “Compatibility Mode” in Microsoft Office?

When you open a document created in an older version of Microsoft Word, Excel, or PowerPoint in a modern version of Office, you may see “Compatibility Mode” appear after the name of the document in the titlebar. This changes the way the document appears and prevents you from using some modern features.

How to Recover an Unsaved Microsoft Office File

You’ve just closed an Office document and accidentally clicked Don’t Save. Or maybe Word crashed or your laptop lost power before you remembered to save what you were working on. We’ve all felt that pain, but all is not necessarily lost. By default, Office applications automatically save temporary backup copies of your documents as you work and there’s a good chance you can recover them.

How to Reduce the Size of Microsoft Office Documents That Contain Images

Even in these times of fast internet connections, huge hard drives, and loads of free cloud storage, file size sometimes matters. You might have a limit to the size of files you can send or receive via email, or you might be running low on thumb drive space. Whatever the reason, if you have Office documents that include images, you might be able to significantly reduce the size of those files.

How to Add a Calculator to Microsoft Word

To do basic arithmetic in Word, you normally have to open the Windows calculator to get your answers, then manually insert them into Word. However, there is a third-party add-in for Word that provides a popup calculator that will calculate numbers in your document, and automatically insert the answer.

How to Manually Calculate Only the Active Worksheet in Excel

If you have large workbooks with a lot of formulas on the worksheets, recalculating the workbooks can take a long time. By default, Excel automatically recalculates all open workbooks as you change values in the worksheets. However, you can choose to recalculate only the current worksheet manually.

How to Transpose Rows and Columns in Excel 2013

You’ve setup your worksheet with all your row and column headings and you’ve entered all your data. Then, you discover that it would look better if the rows were the columns and the columns were the rows. How do you accomplish this easily?