You can sort paragraphs, lists and tables in a Word document with all manner of tricks available under the simple ribbon button. Following our look at different alphabetical orders, here’s a look at the sorting options in Word. Select the list or paragraphs then choose Home | Paragraph | Sort.
Excel can make bar charts in-cell without bothering with the full Chart system. Despite what you might have seen, there’s plenty of options in Excel Data Bars. The usual example of Excel Data Bars has the colored bar in the same cell as the value. In this article we’ll show
It’s not enough to setup two-factor security for your Microsoft account. Make sure your recovery settings are checked and up to date. Do it now before it’s too late. Today we’re helping someone trying to login to their Microsoft account after losing their password. Many, many hours of frustration and
The new version of Microsoft Office 2024 is now on sale to the general public all around the world. This is the ‘perpetual licence’ or single purchase release with no subscription fee. Office 2024 is now available direct from Microsoft.com and some retailers at the same prices as Office 2021.
Here’s how Office Watch reader, Erik and we drilled down into Windows and Word to narrow down the source of the Word language bug. Erik’s tests are with Office 365 on Windows 11 Pro 23H2 but the same behavior has been reported by others in many versions of Word and
Sometimes Word will switch to another language despite all the settings saying otherwise. With the help of an Office Watch reader, we’ve dug into the details to find what might cause the bug in Word and suggest some possible solutions. Word and Office should obey the default language setup in
There’s a simple way to drill into the Windows or Mac clipboard to see what’s saved and how it’s saved. The clipboard is a lot more complicated than most people think. Happily, most of the time the complications don’t matter to us mere humans. Copying text from, say, Word might
Ever wondered what font is used in a famous logo? There’s a fascinating collection of familiar brands with their names replaced with the font name. Emanuele Abrate has made Logofonts, for example the Starbucks logo with the font name, FreightSans Black. Nike uses Futura. WhatsApp with HelveticaNeue. YouTube uses AlternativeGothic
An 85-year-old blunder has just been fixed at Westminster Abbey to change the spelling to Brontë with the important diaresis. Here’s how to type an ë in Word and other matters arising. Here’s how the memorial to the Brontë sisters looked in Poets Corner until a few days ago. For
There are plenty of audio and music options available in PowerPoint if you want to give your audience a break from your voice. We’ll go beyond the simple ‘adding music’ help to give some practical advice for audio in presentations: You will find the audio basics at Insert | Media |
The BBC has a great collection of over 16,000 sound effects that you can add to your PowerPoint presentations. Use them as a trigger sound for a click on a presentation, as a novel background noise or even an alert sound on your computer or smartphone. Sound Effects Galore Exploring
A short video which brings up some interesting points in the early development history of Microsoft Office, some might surprise you. Microsoft Office started as separately sold products (Word, Excel, PowerPoint and Outlook) and only gradually did they become an integrated package with shared components, consistent interface and some interconnections.
While it lasts, check out some free classes about Python in Excel for better data analysis, DataFrames, charts & visualizations and machine learning. We’re a big fan of Python in Excel and these lessons should help those of us who haven’t yet caught the Python bug. Advance Your Python in
Excel 365 now has Python features included for all business and enterprise customers with a Microsoft 365 software licence Python is a powerful programming language with many great libraries of tools for analysis and charting. It’s a massive extension to Excel that we’ve already raved about. Python Editor for Excel
Add something special to the start of your Word document with a banner image with text. We’ll explain how to do that with free tools like Copilot or Designer. We were inspired by a Microsoft promotion which wrongly said that a Microsoft 365 subscription with Copilot Pro is required, when
The latest version of the macOS for Apple Mac computers, Sequoia v15, is out now. Here’s a few features and settings that might interest Microsoft Office users plus a few tips from real use of macOS Sequoia. macOS Sequioa is available now and works quite well for us. More cautious
All you need is a ‘strawberry’ to see both ChatGPT and Microsoft’s Copilot gets simple things wrong. Or ask which is larger of two numbers. Modern AI systems aren’t as great as the hype and why you definitely need to check anything Copilot, ChatGPT, Google Gemini or Meta etc tells
No spam/junk email filter is perfect but it’s hard to understand how some recent messages have been missed by Microsoft’s inhouse security systems. Here’s two peculiar examples to watch out for. A prank email or a failed scam? An email is sent out to many people that seems to have
A new collection of Copilot features have been released under the banner “Wave 2” with inclusions for Excel, PowerPoint, Outlook, Word and Teams. Don’t get too excited because there’s ‘fine print’ that limits who can catch this wave. Before we explain a little of what’s in the new set of
Here’s the basics of Styles in Word for paragraph, character or both (Linked) plus Tables and Lists. I know talking about styles in Word makes eyes glaze over but they are a really useful part of Word (plus Excel, PowerPoint and Outlook). Today I watched an ‘experienced’ Word user reformatting
What to do if Excel’s columns have numbers across the top instead of letters. There’s a simple setting to switch between two different ways of labelling cells. You open an Excel workbook and the column headings look all wrong – instead of letters (A, B C …) there are numbers.
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
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
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
