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.
Print Grid Lines in Excel 2016
Make the grid lines print out when you print a spreadsheet in Microsoft Excel 2016 with these steps.
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 […]
Excel: Fix “File is locked for editing/in use” Errors
When working the helpdesk, I get many calls from users who say they cannot edit a Microsoft Excel file because it is locked and in use by other user. The message that appears will say “File in Use – {filename] is locked for editing by {username}. Open ‘Read-Only” or click “Notify to receive notification when […]
Excel Calculations Are Not Accurate
Are you staring at your 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.
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: Copy and Paste Values Without Formulas
When you perform a normal copy and paste on a cell in Microsoft Excel 2016, 2013, and 2010 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. […]
Office 2016/2013: Turn Office Clipboard On/Off
Turn the Microsoft Office 2016 or 2013 clipboard features on or off using these easy steps.
Excel 2016: Freeze or Unfreeze Panes, Columns, and Rows
In Microsoft Excel 2016, 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.
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. […]
Enable “Send to Mail Recipient” Option in Excel & Word 2016
By default, Microsoft Excel and Word 2016 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.
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.
How to Prevent Workbook Editing in Excel 2016
How to protect a workbook and disable the options in Microsoft Excel 2016 to Insert, Delete, Rename, Move or Copy, Hide, and Unhide.
Enable Slashes (/) in Excel 2016
By default the slash (/) key acts as a shortcut to the Excel menu bar. Here’s how to disable this so that you may use the slash character within your Microsoft Excel 2016 spreadsheet.
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: Unhide Rows or Columns
If you can’t see certain rows or columns in Microsoft Excel 2016, it may be because they are hidden. Here’s how to unhide rows or columns.
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 […]