All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint and Outlook on macOS
Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Looking for the perfect holiday emoji for your document, slide or email? This quick-and-easy list from Office Watch offers a searchable collection of Thanksgiving-themed symbols that work across Windows, macOS, iPhone and Android. These emoji are supported (with different looks) on Windows, iPhone, iPad and Android devices. Unicode value (hex)
If you’re working in Microsoft Excel and want a drop-down list from a dynamic array you have to use a workaround because the direct method for fixed arrays doesn’t work for dynamic arrays. Here’s the simple workaround to use a dynamic array function to generate a list of unique values
Unleash the full potential of Excel’s GROUPBY() function, the game-changer for summarising data in Microsoft Excel. While GROUPBY() seems simple at first glance, clever combinations with other functions open up advanced capabilities: multi-level grouping with automatic subtotals, creating multiple summaries in one formula, custom headings, and even pulling results into
Want to make your document look polished by having an image neatly enveloped by text? In this quick tutorial, you’ll learn how to insert a picture into Microsoft Word and apply proper text-wrapping so it can sit on the left, right, center or anywhere – and stay there. Let your
If you’ve ever paused over that little horizontal line in a document and wondered whether you should use a hyphen, en-dash or em-dash, you’re not alone. In Microsoft Word there are nine distinct dash or hyphen-like characters, each with its own typographic role and keyboard shortcut. From the standard hyphen
If you’ve ever wondered how to replicate the distinctive “school bus yellow” shade in your documents or slides, you’ll find the answer here. It’s the standard hue for North American school buses, chosen for visibility and impact. You can apply this same shade in Microsoft Word, Microsoft PowerPoint or any
Microsoft Australia is issuing refunds to some Microsoft 365 subscribers following court action over its marketing practices. While the refunds currently apply only to Australian customers, the case raises important questions about transparency and accountability for Microsoft 365 users worldwide. The move highlights growing scrutiny over how tech giants advertise
Microsoft’s subscription practices are under scrutiny in Australia as the country’s competition regulator takes the tech giant to court. The Australian Competition and Consumer Commission (ACCC) alleges that Microsoft misled approximately 2.7 million Microsoft 365 Personal and Family subscribers over how it communicated a major price increase and subscription change.
A viral post recently accused Microsoft Excel of bias for labeling the shekel as “Hebrew” instead of “Israel.” However, there’s no conspiracy—Excel lists currencies by language, not country, using the same format for all entries. Thanks to Office Watcher, Gary B. from Portland for alerting us to this bit of
Most Word users stop at page numbers and dates in their headers and footers, but Microsoft Word can do much more. From inserting document titles, authors, and file paths to using advanced field codes like StyleRef or NumPages, you can make your headers dynamic, informative, and even interactive. Discover the
Creating polished, consistent headers and footers in Microsoft Word is easier than you think. This guide walks you through every step—from adding page numbers and section-specific layouts to using “Different First Page” for cleaner title pages. Whether you’re preparing reports, articles, or academic papers, these techniques will help your documents
Microsoft Word lacks native support for adding prefix and suffix text through styles—but clever workarounds can make it possible. This guide from Office Watch shows how to simulate prefixing and suffixing paragraphs or character styles, just like CSS’s :before and :after elements. Learn how to format consistent labels, product codes,
Microsoft’s Copilot is NOT the wildly popular, world class AI product that Microsoft says it is. That’s not just an opinion; there are hard facts to back it up. The recent sharp price drop and ignored user frustration suggest otherwise. From intrusive integration to privacy concerns, Copilot’s rollout has backfired.
Microsoft’s Copilot “Deep Research” promises detailed, AI-generated reports—but does it deliver? Office Watch’s hands-on tests reveal the strengths, limitations, and frustrating formatting flaws behind Microsoft’s most ambitious Copilot feature yet. From factual errors to messy Word documents, here’s what you should know before relying on Deep Research for serious work
Did you know Windows quietly swaps out Helvetica font for Arial every time you open certain documents? This subtle substitution affects how text looks in Word, browsers, and more. Learn why Helvetica isn’t included in Windows, how Microsoft handles font replacements behind the scenes, and what you can do to
A viral post sparked debate over whether Microsoft Word’s grammar checker shows hidden bias, but the truth is more technical than cultural. Office Watch investigated and found that Word and Google Docs simply make different choices about what to flag in grammar suggestions. There’s no homophobia here, just decisions that
Microsoft’s Copilot() function in Excel comes with real risks. When used incorrectly, Copilot() can produce misleading or nonsensical results that could compromise data accuracy and decision-making. Treat this AI feature with caution and Microsoft should add stronger safeguards and clearer warnings against misuse. It all started with this post on
Want to show only the year, month, or day from an Excel date? We explain how to use the TEXT(), YEAR(), MONTH(), and DAY() functions or cell formatting to display or calculate date details efficiently. Learn when to use each method, which is fastest, and how your choice affects Excel
Need an attention-grabbing border for safety notices or urgent messages? Creating a striped border in Microsoft Word isn’t as simple as it seems—but with the right technique, you can design professional-looking emergency or warning signs in minutes. This step-by-step guide from Office Watch shows how to use Word’s background picture
Want to make your Microsoft Word pages or signs stand out? Skip the frustrating page background tool and try this smarter way to add diagonally striped borders. Get full control over stripe position, color, and layout — perfect for eye-catching warning signs, notices, or creative designs that look sharp on
What does the new Microsoft 365 Premium plan mean for all subscribers? It’s all good news with no major changes or price rises to worry about. Microsoft 365 Premium: Copilot AI, new Features & Pricing is the the second major change in Microsoft 365 consumer plans in less than a
Microsoft is extending more Copilot features to Microsoft 365 Personal and Family subscribers, offering expanded AI tools across Word, Excel, Outlook, and more. While users now gain access to enhanced drafting, summarizing, image generation, and voice features, the long-standing cap of 60 AI credits per month still applies. Compared to
Thinking about switching to Microsoft 365 Premium? Whether you’re moving from a Personal or Family subscription, upgrading unlocks expanded AI-powered Copilot features and enhanced productivity tools. This guide walks you through the upgrade process, highlights what to expect, and answers common questions about credits, shared accounts, and potential billing issues—helping
Confused by ads promoting “Microsoft 365 Premium for Consumer”? You’re not alone. Until late 2025, no such plan even existed—making many online offers misleading at best and outright scams at worst. With Microsoft now officially releasing Microsoft 365 Premium, it’s crucial to understand how to spot the real subscription and
