Discover Excel’s Text-Splitting Power – Unlock Faster, Smarter Data ManagementMicrosoft has elevated text handling in Excel by rolling out powerful formula functions—TEXTBEFORE, TEXTAFTER, and TEXTSPLIT—that revolutionize how you extract and split strings. No more convoluted nested LEFT, RIGHT, or SEARCH formulas . Normally when working with text it’s common to need
Discover a smarter way to insert images directly into Excel cells with the IMAGE() function — no more awkward floating pictures. With just one formula, you can pull in external images using a secure URL, control how they fit or fill the cell, and even fine-tune dimensions with pixel-level precision.
Everyone knows that Word checks your spelling with red underlines but do you know everything that’s possible in the spell check menus. Simply click the underlined word to view suggested corrections. Choose the right option, and Word will replace it instantly. So far, so easy. More choices below the suggestions
To prevent somebody ripping off your prized presentation or deck, you should password-protect your presentation, making it accessible only to people you trust. PowerPoint includes a built‑in password‑protection feature that ensures only authorized users can open and modify your presentation. Why password lock a PowerPoint presentation? To keep the deck
The BBC has published a good history of the famous “Keep Calm and Carry On” poster from World War 2 but missed what, to us, is the most important 21st Century innovation. When “Keep Calm and Carry On” first became popular, we saw the opportunity to showcase what Word and
Microsoft has finally rolled out two highly requested updates for OneNote users on Windows, macOS, and iPad: Merging table cells and a paste text shortcut. Merge Table Cells No more resorting to convoluted workarounds or dragging your content into Excel. Now, select two or more adjacent cells in a OneNote
Microsoft has officially warned all Microsoft 365 customers to update Office—or risk losing handy features like Read Aloud, Transcribe, and Dictate. Most people will already be OK but it’s worth checking to make sure. Microsoft is totally revamping the backend services that powers the voice related parts of Microsoft Office;
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
There was a sudden disappearance of the Ctrl + Shift + V Paste Special shortcut in Outlook classic for Windows. We explain what caused the issue, when Microsoft will finally roll out a fix, and why the delay happened, so you can get back to efficient email editing without the
Microsoft has quietly announced that the Microsoft Store version of Microsoft 365 apps will no longer receive feature updates after October 2025, nor security updates after December 2026. Microsoft 365 for Windows via the Microsoft Store was delivered via the Store’s Appx installation—sandboxed, safe, but increasingly outdated for modern enterprise needs.
OneDrive isn’t just used for documents and photos. Microsoft saves a lot of related files in secret, hidden folders taking up the space customers pay for and preventing proper backup. Let’s look at the messy mix of things hidden in OneDrive and other Microsoft online locations. You can see what’s
Looking for a way to revert to classic Outlook after trying the new Outlook for Windows? This guide provides step-by-step instructions on how to switch back to classic Outlook, explains how both versions are probably on your PC. If you’ve tried the new Outlook for Windows and wish to return
If you’re wondering why a contacts address change in Outlook doesn’t stick, you’re not alone—many Outlook users face this frustrating issue. There are three possible reasons starting with a little known quirk in how Outlook saves email addresses. An Office Watch reader asks why Outlook keeps remembering an old email
Transform how you format Word documents with keyboard shortcuts—going beyond the built‑in ones for Headings 1–3 by adding your own for Heading 4, 5, 6 (and beyond) that Microsoft has forgotten. With these simple tweaks, your document structuring becomes faster and more consistent. Word’s in-built Heading styles come with some shortcut keys, but
Microsoft is retiring the Reuse Slides feature, however you can still copy slides manually—and it’s simple. Whether you’re preparing for a meeting, a lecture, or a project presentation, knowing how to quickly and efficiently move or copy slides between presentations can save you both time and hassle. To get started,
Worried about losing files in OneDrive or getting locked out of your Microsoft account? You should be worried. Reading about one horrifying OneDrive experience. Here’s what you need to know about keeping your data safe, why regular backups matter. Discover practical tips to protect your files and avoid the common
Microsoft is dumping the long standing “Reuse Slide” part of PowerPoint 365 for no good reason, just the usual lame excuses. Reuse Slides (Insert | New Slide | Reuse Slides) is (was) a way to quickly copy slides from another presentation and drop it into your existing deck. It’s a
When will your version of Microsoft Office stop getting security bug and software bug fixes, what Microsoft calls the “end of support“. This is important because software updates are necessary for Office apps. Mainly because outdated versions are more vulnerable to hackers, particularly in the case of opening malicious emails,
Down in Australia there’s another example of a mistake when redacting a Word document before public release. Make sure you delete any links to redacted text, such as a Table of Contents or summary. What caught our eye was the latest example of an oversight when redacting a document. Aussie
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,
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
Transform your next presentation by mastering five powerful ways to add images in PowerPoint. Whether you’re embedding visuals directly from the web, creating photo albums, leveraging SmartArt, or using Copilot enhancements, these expert tips will streamline slide preparation. On a PowerPoint slide with a picture placeholder, just click the image
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
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
