See which Excel cells need updating or stale
Excel 365 is getting (at last) a clear warning that some cells have not been recalculated aka a ‘stale cell’ with the addition of a ‘Format Stale Values’ option. This feature only applies if you’re using partial or manual calculation modes. Most of us use the default Automatic mode where Excel updates cells when necessary. […]
Make any Excel function dynamic (almost)
Many common Excel functions have a great new power added to them with little fanfare. They can become dynamic array functions which improves the consistency of worksheets. It’s simple and easy to do. When Microsoft added dynamic arrays to Excel, all the focus was on the new functions like SORT, FILTER, and SEQUENCE that “spill” […]
Excel Spill Mystery: Why It Happens and How to Fix It
Some Excel functions won’t spill their results in the way you might expect. Edate(), EOmonth(), IsEven(), IsOdd() and RandBetween(), among many, need an extra little trick to become a dynamic array function. We’ve already explained how many common Excel functions (Round(), Trim(), Upper() and many more) can “spill” their results into multiple cells. But then—bam!—you […]
July Office updates include a real worry
The July 2025 security bug fixes list plugs another 137 problems found in Microsoft software. Some are really serious and need patching right away for all Microsoft 365 and Office users. BitLocker also gets some security fixes. This months load of Microsoft Office security updates includes a fix for a series of “Remote Code Execution” […]
Request more access to a Word, Excel or PowerPoint file
There’s a new feature in Microsoft 365 Word, Excel, and PowerPoint for the web to request elevated permissions directly within the application. Anyone with view-only access can ask for higher editing or reviewing rights without leaving the document. Microsoft, as usual, buries an important condition deep in their promotional blurb so we’ll put it up-front […]
Add the US Flag into Word, Excel or PowerPoint
Add the US National flag “Old Glory” “The red, white and blue” into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Learn how to properly get and use the US Flag in Word Excel PowerPoint for your presentations and documents. The same help can be used for […]
Why can’t AutoSave work with a macro in a Word or Office document ?
Autosave in Microsoft 365 and Office is one of the more frustrating features with annoying limitations. One of them is not automatically saving any macro-enabled Word, Excel or PowerPoint file. We’ve talked before about how Autosave is used to push customers into using OneDrive to save documents. Autosave could work for all files, not matter […]
How to turn Copilot on or off for each Microsoft 365 app
Take control of Microsoft 365 by learning how to enable or disable Copilot in each app—Word, Excel, PowerPoint, Outlook, and OneNote. This guide provides step-by-step instructions to customize Copilot settings per application and explains why sometimes you can’t turn it off. Copilot integration into Microsoft 365 is a mess. Microsoft is focused on adding more […]
How many Copilot AI Credits do I have?
Some Microsoft 365 consumer plans come with a monthly allowance of “AI credits” but it’s hard to find out how many are left. The AI credit balance does not show up in the Microsoft 365 apps nor Windows 11 account information. It should be there and maybe Microsoft will eventually get around to it but […]
Copilot chooses Excel data a bit smarter
Microsoft has given Copilot in Excel 365 some smarts to choose the table or cells to work on. Previously, Copilot relied on the user’s selected cell to determine context, often defaulting to the nearest structured table. We explain how it works in the real world and the important limitation. Enter the new context inference capabilities. […]
Stop Using Old Office Document Formats Now
Still using .doc, .xls, or .ppt files? These outdated Microsoft Office formats are not just relics—they’re major security risks and should be banned. Hackers exploit these older files to spread malware, ransomware, and steal data, as they often bypass modern antivirus protections. After our suggestion to ignore old style Office documents, it’s clear some folks […]
Android Users Rejoice: View Shared Office Files Without Logging In
Microsoft has extended a nifty new feature to include Android users: the ability to view shared Word, Excel, and PowerPoint files without needing to sign in with a Microsoft account. Previously, this was an exclusive perk for iPhone/iPad users—but Android’s finally been invited to the party. That said, if users want to leave their mark—via […]
Fit more tabs across an Excel workbook
Struggling with a sea of worksheet tabs at the bottom of your Excel window? Whether you’re managing dozens of tabs or juggling shared workbooks with tight screen space, discover how to fit more visible tabs across your Excel workbook can transform your workflow. In this guide, we walk through both simple and clever techniques to […]
Forget SUM(), use Aggregate() in Excel
Aggregate() is the grown up version ‘all in one’ function that can replace common functions like Sum() and Subtotal() plus powerful options not available in those older functions. AGGREGATE() function is a more advanced alternative to the SUBTOTAL function, offering significantly expanded capabilities. Almost an ‘all in one’ solution instead of using multiple functions. It’s […]
Mastering Date Comparisons in Excel Using IF Statements
Whether you’re managing schedules, tracking deadlines, or analyzing time-based data, comparing dates in Excel is a critical skill. This guide walks you through how to use the powerful IF function to compare dates—such as determining if one date is before, after, or equal to another. Learn essential Excel formulas that simplify date logic and help […]
Excel case-sensitive text comparisons or not
Be careful comparing text in Excel because it looks easy but there are traps when comparing exact text (including upper/lower case) or not. Whether you’re cleaning data or ensuring accuracy in sensitive fields like usernames or product codes, we’ll help you get the results you need every time. Case-insensitive IF statement for text values When […]
