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,
Type the Airplane ✈ symbol, icon, emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Airplane ✈ symbol is often used for signs, directions or an itinerary, possibly in combination with symbols for other transport like train, car, walking. For more ‘airplane’
The Lambda() feature in Excel 365 is great, when you try using it the downsides quickly become obvious. Happily there are workarounds. Lambda() itself is fine. It’s a welcome addition which more advanced users will make Excel do amazing things or simplify complex formulas. See Lambda – strange name for
RGBA color codes are an extension of the RGB (Red, Green, Blue) color system which you can use in modern Microsoft Office with a little trickery. There’s an annoying difference (reversal) in settings on Office for Windows vs other Microsoft services and Office for Mac. RGB colors have been around
The excellent Excel Formula Bot is now available as an Excel addin for subscribers to the Bot service and now can explain a formula in plain language. Excel Formula Bot is a wonderful service which converts human-speak into Excel formula-speak or vice-versa. Since we last reported, David Bressler has added
What to do if you see a #BLOCKED cell error message in Microsoft Excel. The fix is simple, if you can get past Microsoft’s unhelpful, er, ‘help’. Open uṗ a workbook and see #BLOCKED in some cells. The message ‘Check privacy settings’ is typical Microsoft message. It’s strictly correct but
You’re not stuck with the Microsoft automatic settings when inserting a new shape. Change the defaults to whatever you like for faster shape formatting in Office; Word, Excel, PowerPoint or Outlook. When you Insert | Shape, something like this probably appears. Blue fill, 1pt black single line outline, no effects
If you don’t like the large Office Backstage pane, the older and more powerful Open and Save dialog boxes are still available via shortcuts or changing a Microsoft Office setting. Microsoft has spent a lot of time and effort changing the Word, Excel and PowerPoint File panes to add more
Pantone has announced their “Color of the Year” for 2023 is “Viva Magenta” and, as usual, we’ll explain how to use that exact color in Word, Excel, PowerPoint and Outlook. And we’ll look at the purple prose that’s become a hallmark of Pantone’s annual promotion. The color of 2023 is
Microsoft Office rules might let two users or more use the same copy of Office on a computer. It depends on which type of Office you have on a Windows or Mac computer. Office can work for multiple separate users on the one computer. Most commonly, there are separate Windows
Function Keys in Excel are a convenient and quicker way of doing tasks by using keyboard instead of mouse. Here’s the Excel function keys (F1 to F12) and their many tricks. F1 – Help, Ribbon, Chart, new sheet F1 – Displays the Excel Help pane Ctrl +F1 – Displays or hide the
Need a Christmas emoji or symbol? Here’s a quick and searchable list of all the Xmas emoji for documents, sheets, slides, emails or messages that you can use or copy. This list has all the Christmas related emoji we can think of, the broadest sense both secular and religious. These
Microsoft Forms can export survey/quiz results to an Excel workbook, here’s how to do that easy and efficiently and the limitations that Microsoft hasn’t fixed for most customers. The current method of getting Microsoft Forms results into Excel isn’t very elegant. It doesn’t make use of Excel’s excellent data import
Two ways to put left and right aligned text on the same line in Microsoft Word. There’s the commonly used option and the less well-known choice. BONUS: putting left, center and right aligned text on one line. We’ll show how to make Left and Right aligned text looking like this.
Type the Hundred points 💯 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. 100 points 💯 symbol is also known as ’100’, ‘Keep it 100’ or ‘Keeping it real’. How 100 points 💯 looks in different fonts. Here’s some examples of how
Type the Face with Tears of joy 😂 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Face with Tears of joy 😂 emoji is one of the most popular, if not THE most commonly used emoji. Also known as Laughing Crying, Laughing Tears,
You can add a Twitter blue or gray checkmark to your Microsoft Office documents including Word docs, PowerPoint slides. We’ll show you how to add the ‘verified’ graphic at any size you need with the exact blue, gray or some other color. Oh, and save yourself $8 a month <kidding>.
Microsoft Create is a new part of Microsoft 365 that will replace the existing Office templates site and more. Office Watch explains how to use the Create site now, the many categories available and what’s to come. Cut through all the usual Microsoft Hype™ like “ultimate creator launchpad” and the
Type the Tilde ~ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Plus an emoji alternative to Tilde. Tilde is used to mean ‘approximate’ as in “ ~30 minutes late”. In maths it means ‘similar order of magnitude’ e.g. “ a ~
Ronny, a loyal Office Watch reader asks “OK, I now understand that entering dates in Excel as plain text isn’t a good idea. How do I convert my cells with MM/DD text into proper Excel dates?” It’s a trap for Excel novices. Typing in a date as plain text seems
Here’s a handy Excel worksheet for visitors to Europe, including UK citizens. It’ll help you stay within the legal limits for ‘short stays’ by visitors to the EU Schengen zone. Most visitors to Europe are allowed to stay in the Schengen group of countries for 90 days out of the
