Excel 2016

Enable “Send to Mail Recipient” Option in Excel & Word 2019

Posted on November 11, 2018 by Mitch Bartlett 5 Comments

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

Excel 2019 & 2016: Force “Open as Read Only” Prompt

Posted on November 11, 2018 by Mitch Bartlett 9 Comments

If you have a file that is sensitive to changes, you can force Microsoft Excel 2019, 2016, or 365 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 2019 & 2016: Force “Open as Read Only” Prompt

Freeze or Unfreeze Panes, Columns, and Rows in Excel

Posted on October 21, 2018 by Mitch Bartlett 3 Comments

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

Posted on October 21, 2018 by Mitch Bartlett 12 Comments

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

Posted on July 15, 2018 by Mitch Bartlett 3 Comments

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

Posted on March 22, 2018 by Mitch Bartlett Leave a Comment

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

Posted on February 3, 2018 by Mitch Bartlett Leave a Comment

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

By Mitch Bartlett 49 Comments

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

By Mitch Bartlett 4 Comments

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.”

By Mitch Bartlett 5 Comments

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.”