How to insert the Sigma upper case Σ and Sigma lower case σ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Sigma (uppercase Σ / lowercase σ) is the eighteenth letter of the Greek alphabet. In mathematics, the uppercase sigma symbol is used
Insert the Double Dagger ‡ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Double Dagger ‡ symbol is used to mark a third footnote after the asterisk and dagger in a Word document. How Double Dagger ‡ looks in different fonts. Here’s some
How to change the look of Word mail merge data like dates and dollar amounts to exactly what you want to see in the documents. Nancy M asks: “I try to merge data (such as amount, PO#, to whom, as well as the date) from an Excel database. In the
Here’s how to check how many days are left before Microsoft 365 needs an online ‘license check’ to confirm your license. Microsoft calls this a ‘grace period’. Also what’s the maximum possible offline access period. See Restart or renew Microsoft 365 licence before going offline Microsoft 365 software and apps check
Consider switching to SumIFS, it’s much the same as the older Excel function, SumIf() but easier to expand as your needs change. It can add up values according to more than criteria like a name and date range. We’ve talked about SUMIF and how its parameter order is a little
ChatGPT or Copilot can be used to learn the basics of Microsoft Office VBA coding with examples made to order. Here’s some VBA made by ChatGPT for Word, Excel, PowerPoint and Outlook and some of its mistakes. ChatGPT or Copilot will take a simple request and returns some text. People
There are official and unofficial biohazard symbols available for Word docs, PowerPoint slides or any other place you need them. We have download links to better graphics you can use with variations to make them stand out The official biohazard symbol was developed in 1966 and there are many variations
Type Infinity ∞ and similar symbols into Microsoft Word, Excel, PowerPoint or Outlook. In Office for Windows and Office for Mac you can enter Infinity, Incomplete Infinity, Tie over Infinity and Infinity negated. Infinity ∞ symbol is used for anything that has no end or boundless. Of course, it’s in
Can Office 2007 and other older versions of Office (Office 2010, Office 2013) be installed on Windows 11? What are the licensing, activation problems? How about moving documents? There are four issues to consider; licencing, compatibility, support/patches and migrating documents: Officially only these versions of Microsoft Office are supported on
Side to Side is a different way to view a Word document. Flip through the pages with touches on the screen, like a book. If you’re sick of endless scrolling, Side to Side Page Movement is available for Word 365, Word 2021/2019 and Word 2016. Using Side to Side View
Can Office 2007 and other older versions of Office (Office 2010, Office 2013) be installed on Windows 10. What are the licensing, activation problems? How about moving documents? Eileen G asks a common question to Office Watch: “I got a new HP desktop computer, but can I install the old
Insert a Dagger † into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Dagger † symbol is used to indicate a footnote if an asterisk has been already used. Footnotes and Endnotes in Word Formatting Footnotes and Endnotes Dagger is a different look
Microsoft Office has plenty of important changes and end dates coming in 2023, starting with two in January. Here’s a list of what Microsoft has in store for their paying customers. Microsoft 365 app coming in January 2023 The Office mobile app (the ‘all in one’ app) is being changed
There are a lot more airplane symbols available in Microsoft Office including ones for landing, takeoff and even pilots. Also how to get plane graphics for specific models like a 747 Jumbo. If you know where to look, Office has plenty of ‘airplane’ related graphics beyond the simple Airplane ✈
How to remove or move email attachments using Outlook for Windows or Mac and the workarounds for Outlook.com in a browser. Doing this reduces the size of your online mailbox and, from 1 Feb 2023, your OneDrive storage. Removing email attachments is the fastest way to shrink a mailbox that’s
Adding color gradient effects to your text, shapes and borders is a good way to give it a bit more zing to Microsoft Word, PowerPoint or other Office docs. The gradient feature is quite sophisticated, with a wide range of options and adjustments available but not obvious. To add a
Microsoft is hyping their “Microsoft 365 app” but here’s what’s really happening, when the changes will happen and why it’s more hype and rebranding than useful improvements for Microsoft 365 customers. There’s really two parts to this “new” Microsoft 365, changes to the Office.com web site and later, a “Microsoft
Microsoft has two new formula helpers in Excel. One to suggest the right function (Formula Suggestions) and the other to automatically insert copies of a formula (Formula by Example). For the moment, these two features are in Excel on the web but are likely to spread to other Excel’s during
How to add a calendar as quick reference to your desktop on Windows or Mac. It can be a yearly, monthly or weekly calendar, just like the old paper calendar / blotting paper on an office desktop in olden times (i.e. 20 years ago)! A handy place to put a
Here’s a great Excel yearly planner that we’re delighted to share. It works for 2024 or any other year you like and highlights Public Holidays in a simple and elegant way. Office Watch friend David Peel from the UK made this workbook and let us share with our readers. He’s
Excel has a Calendar Creator template which might work or might not. Why it doesn’t work is a little mystery but we have an alternative for our readers. The ‘Calendar Creator (any year’) template sounds great … a one-page year calendar. Find it from File | New then search for
Type the Lambda upper case Λ, and Lambda lower case λ symbols (aka Lamda) in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Lambda/Lamda (uppercase Λ / lowercase λ) is the 11th letter of the Greek alphabet. The uppercase symbol has various uses, it is
The Delta upper case Δ or Delta lower case δ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Delta (uppercase Δ / lowercase δ) is the fourth letter of the Greek alphabet. It’s the “d” sound in Modern and Ancient Greek. Delta
Looking for some Christmas images, pictures or graphics? Microsoft Office has some in-built Xmas options for the festive tide of Yule. Add these images into Word documents, Outlook emails, PowerPoint slides or even Excel worksheets. Unsubtle Hint: Christmas Cheer with Office has a collection of festive cards, letters, gift tags,
