DEP or Data Execution Prevention mode can cause problems within some applications, but may be required for certain features to work. Here’s how to enable or disable DEP mode in each Microsoft Office 2016 or 2013 application.
Office: Fix “The clipboard cannot be emptied. Another program may be using the clipboard.”
Microsoft Office users may seen an error that says “The clipboard cannot be emptied. Another program may be using the clipboard.” when attempting to cut, copy, or paste. The error commonly occurs in Excel. When this error occurs, it is likely that a plugin has been installed recently has decided to take over your clipboard. Here are […]
Fix Excel Freezing or Slow
Microsoft Excel is a powerful program. So powerful, that it’s probably the most susceptible to have problems. I have troubleshot problems with Excel freezing and saying “Not Responding” in Windows. The reasons this happen can vary greatly. Here are the most common ways to fix the problem.
Excel 2016 & 2013: Flip Cell Text Sideways
Learn how to make your Microsoft Excel 2016 or 2013 spreadsheets look extra nice by flipping cell text sideways. This is often done at the top of columns that may have longer words at the top, but not so long words in lower cells. It enables you to fit more content in a smaller area. […]
Excel 2016 & 2013: How to Lock or Unlock Cells
Are you unable to modify cells because they are locked? Here’s how to lock or unlock cells in Microsoft Excel 2016 and 2013.
Excel 2016 & 2013: Force “Open as Read Only” Prompt
If you have a file that is sensitive to changes, you can force Excel 2016 or 2013 to prompt the user to open as Read Only whenever they attempt to open the file. Here’s how to enable this setting.
Enable/Disable Display of Formulas in Cells in Excel
Enable or prevent showing formulas in the spreadsheet in Microsoft Excel. Performing these steps won’t actually change the value of the cell. It will only allow you to view the formula within the cell.
Excel 2016 & 2013: How to Highlight Duplicate or Unique Values
If you have the need to highlight cells with duplicate or unique values in Microsoft Excel 2016 or 2013, here’s an easy way to do it.
Excel: Permanently Disable Compatibility Checker Dialog
If you upgrade to Microsoft Excel 2016, 2013, or 2010, you may encounter a “Compatibility Checker” dialog every time you try to save the file using an older file format. In most cases, you can simply select the “Check compatibility when saving this workbook” box, then select “Continue”, then proceed without problems. If you work […]