How to stop Microsoft Teams opening automatically when the computer starts – Windows or Mac. Microsoft wants to push their Teams software to as many people as possible. Part of that is making Teams (free or paid) really obvious or intrusive, depending on your point of view. Teams doesn’t take
Excel PivotTable can show a count of unique items if you know where to look. Handy to see the number of customers, products or students from a long data list. What is the count of unique customers who made purchases in each region? How many unique products were sold in
Microsoft has released a preview version of Office 2024 LTSC. Here’s how to get it, what’s in the preview and why not to bother with the preview software. Office 2024 is the next fixed price or perpetual license version of Microsoft Office that will be released later this year. The
OneNote for Windows can straighten handwritten, digital ink, text so it’s nicely even across the screen. We tested Straighten to see how it really works … and it’s not bad. Microsoft doesn’t provide a working example of straighten just a mockup with grey lines and nothing like the real OneNote
Word, PowerPoint and OneNote 365 for Windows have digital ‘ink to text‘ feature to not only handwrite into documents but also edit text and add bullet or numbered lists. Ink to Text requirements Before we explain the new feature, we’ll detail the specific requirements of the new ‘Ink to Text’
A strange case of letter spacing with a Microsoft font showing differences between Word and PowerPoint. Here’s the anomaly with three possible fixes for it and similar situations. Office Watcher Paul B noticed this peculiar spacing between a fullstop/period and digit 1 with the Tenorite font. In PowerPoint, the two
Computers are being infected with at least eight different viruses in an attack that uses steganography to hide nasty code in images linked from Word and Excel documents. But there’s good news for most Office users. Steganography is a way to hide text or code in an image or object.
Paper shredding isn’t always welcome as recycled paper. Turns out there are hidden complexities even to just protecting your privacy and reducing waste. Wirecutter at The New York Times surprised us by explaining how putting shredded paper in a recycling bin can create all sorts of trouble. Shredded paper can
Quickly switch accounts while using Microsoft Office 365, Office 2019 and Office 2021 for Windows and even have different logins in separate programs. Many people wear different ‘hats’ while using Office. There’s a Work ‘hat’ or ‘hats’ with more than one job. Plus your personal or home role. Sometimes even
The File Open and Save dialog boxes in Office have many not-obvious features which let you do a lot of file management and housekeeping on the spot. You try to save a document and realize you need a new sub-folder. Or open a document and want to move it to
Pictures in Word, Excel, PowerPoint and Outlook can make the file sizes at lot larger than you expect. Here’s how to make images smaller (in file size) for Office documents without changing the look of the document, slide etc. The images in a document are what take up a lot
Microsoft has announced ‘extras’ for Microsoft 365 Basic but we can’t see anything new that wasn’t promised over a year ago and delivered six months ago. It’s a just a simple PR stunt that worked. The ‘Microsoft 365 Basic’ plan has just 100GB of OneDrive storage plus a 50GB Outlook.com
The world can be divided in many ways — how about by paper sizes? Letter/Legal/US sizes vs A4/Metric. Microsoft Word makes it easy to cope with both even with different paper sizes in one document. There’s a very handy way to rescale between Letter <> A4 for printing. Amazing Maps
How to insert the Coin 🪙 symbol or emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Coin 🪙 looks in different fonts Only Segoe UI Emoji font has the coin symbol in standard Windows. Coin 🪙 codes These are the
There’s a way to link someone to view a specific slide in a PowerPoint presentaion which is a lot faster than hunting through a big slide deck. Providing a direct link to a specific part of your slideshow not only streamlines the process of receiving feedback but also enables them
Outlook for Windows has both automatic and manual options to translate incoming messages into a language you understand. We’ll explain the choices available and the Outlook settings that are in a strange order. Microsoft Translator supports over 100 languages, enabling users to translate text across a diverse array of linguistic
Microsoft Mesh is a new way to have online meetings with avatars and virtual “immersive” spaces. It works with computers but especially VR headsets like Meta Quest devices (Oculus). Mesh puts online meeting participants in a virtual setting, instead of the usual grid. This example shows two important parts of
Teams app is being forced out of the Microsoft Office bundle. It’s a compulsory divorce with a side-benefit for anyone who doesn’t use Teams or doesn’t use it often. Microsoft has now decided (under duress) to stop selling their Teams app as part of Microsoft Office / Microsoft 365 bundles
Pivotby() is a new and easy way to make PivotTables in Excel. It’s one of two new ‘aggregation functions’ but we prefer to call them fast summary powers. We’ll dig into the detail of what PivotBy() can do. Excel has been able to group or combine data for many years
More common Excel desktop features are being added to the browser based version too. Drag and Drop pasting, Autofill, right-click for more Paste options and also export to text file (CSV) format. All these features will be familiar to Excel desktop (Windows/Mac) users and work in much the same way.
For many readers being able to edit incoming Outlook messages is just a handy feature, but for anyone in the legal or corporate world it could have ‘interesting’ consequences. In Outlook for Windows, open the email in a full window (not the Reading Pane) then go to Message | Move
What’s the story behind the “Update Licence” option that’s appearing in Microsoft 365 apps? What does it mean and when to use it? In Microsoft 365 for Windows you might see a new item on the bottom of the File menu called “Update Licence”. It’s strangely prominent and misleading, based
There’s a useful but niche Excel warning about date with two digits for the century. That’s a useful precaution but sometimes the warning is wrong! Those of us around at the turn of the century will remember the Y2K problems and possible mistakes with a date that has only two
Copilot AI makes writing Excel formulas a lot easier but you still need to check the results to make sure Copilot has understood want you want and gives the right answer. There’s a lot of hype and promises about how AI can help make work easier. That’s not as true
