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
Excel 2019 & 2016: Force “Open as Read Only” Prompt
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
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
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