In-cell charts in Excel provide a powerful method to visualize data trends and patterns. They allow you to quickly derive insights within a worksheet, making information interpretation more straightforward without fussing about with full charts. We’ll explain how to make in-cell charts and then go further and show how to make them look better by […]
How to lock your Excel worksheet from editing – the whole thing or some cells. Allow some people to edit a few cells, leaving the rest of the cells and formulas untouchable by others using the worksheet. Here’s a very simple example: Anyone opening the worksheet can enter a US dollar amount to see the […]
Just when you thought there was nothing left to explore on the frontiers of knowledge, three Danish academics have uncovered the science of paper cuts! Paper cuts are surprisingly common but not well understood. Researchers found that paper around 65 micrometers thick is the worst culprit. “Here we visualize and quantify the motion, deformation, and […]
An old and unsafe Microsoft technology, ActiveX is finally being dropped from Microsoft 365 and Microsoft Office. As usual, there are details and niceties behind the major announcement. For starters, ActiveX isn’t really being discontinued. Microsoft is disabling ActiveX as a default. If you need ActiveX, a menu, registry or Group Policy change will turn […]
Microsoft’s promise of offline support in Outlook (new) is a lot LESS than it appears as the company continues to over-promise and under-deliver their Outlook replacement. We’ve said it before … Maybe someday new Outlook will really be ready for the public but it’s not there yet. See Outlook (new) is NOT ready, ignore what […]