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