Are you unable to modify cells because they are locked? Here's how to lock or unlock cells in Microsoft Excel 2016 and 2013. … [Read more...] about Excel 2016: How to Lock or Unlock Cells
Excel 2013
Office 2016 & 2013: How to Enable or Disable DEP Mode
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. … [Read more...] about Office 2016 & 2013: How to Enable or Disable DEP Mode
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 a few things to check. … [Read more...] about Office: Fix “The clipboard cannot be emptied. Another program may be using the clipboard.”
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. … [Read more...] about Enable/Disable Display of Formulas in Cells in Excel
How to Highlight Duplicate or Unique Values in Excel
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. … [Read more...] about How to Highlight Duplicate or Unique Values in Excel
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 with many Excel spreadsheets though, it can … [Read more...] about Excel: Permanently Disable Compatibility Checker Dialog