If you have a file that is sensitive to changes, you can force Microsoft Excel 365 / 2019 to prompt the user to open as Read Only whenever they attempt to open the file. Here's how to enable this setting. … [Read more...] about Excel: Force “Open as Read Only” Prompt
Excel 2016
Enable “Send to Mail Recipient” Option in Excel & Word 2019
By default, Microsoft Excel 2019, Word 2019, and Office 365 doesn't have the useful "Send to Mail Recipient" option available on the toolbar. The option enables users to quickly access their email client to send documents. Here's how to add it. … [Read more...] about Enable “Send to Mail Recipient” Option in Excel & Word 2019
Freeze or Unfreeze Panes, Columns, and Rows in Excel
In Microsoft Excel 2019, 2016, and , you can freeze rows and columns so that when you scroll, those panes stay in place. This can be handy for header sections so that you can see your headers no matter where you scroll to in the spreadsheet. … [Read more...] about Freeze or Unfreeze Panes, Columns, and Rows in Excel
Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365
When you perform a normal copy and paste on a cell in Microsoft Excel 2019, 2016, and 365 that has been calculated by a formula, the formula gets pasted as well. There is a simple way around this if you wish to just copy and paste only the value within the cell and nothing more. Just follow these steps. … [Read more...] about Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365
Excel 2016: 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. … [Read more...] about Excel 2016: How to Lock or Unlock Cells
Excel 2016: How to Install and Use Macros
Want to learn how to use macros in Microsoft Excel 2016 to speed up repetitive tasks? This tutorial will help you get off and running with Excel macros. … [Read more...] about Excel 2016: How to Install and Use Macros
Excel Calculations Are Wrong
Are you staring at your Microsoft Excel spreadsheet wondering why the calculations are not adding up properly? A row or column may clearly add up in your head, but it's just not accurate in your spreadsheet. Here are a few things to check if your Excel spreadsheet is calculating wrong. … [Read more...] about Excel Calculations Are Wrong
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. … [Read more...] about Fix Excel Freezing or Slow
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.”