Pantone has announced its Color of the Year for 2019 but before you run off to grab color swatches, here’s how to get it in Microsoft Office – Word, Excel, PowerPoint etc. The color of 2019 is <drum roll> ….. Living Coral … As usual what’s more amazing than the
Dig a little into PowerPoint for some slide printing choices. They apply to printing slides only, slides with notes, outline or handouts. See also: Print part of a Word document Print selected pages or sections of a Word document in any order Print selection and other choices in Excel The choices
Microsoft has released four security patches that all Outlook for Windows need to protect from newly discovered bugs. The patches apply to Outlook 365, 2019, 2016, 2013 and 2010 for Windows and are available today. The four Outlook security bugs are related. They involved a hacked .RWZ file that could
A previously theoretical way to misuse Office documents to infect your computer is now ‘in the wild’ and Microsoft isn’t interested in stopping it. Last week we told you about a new way for Office documents to get malware onto your computer. Cymulate discovered that the Online Video feature could
A little side-trick for converting text dates to Excel dates is replacing the text separator. Excel lets you replace text within the selected cells only. If the text dates are in the correct order (e.g. m/d/y ) but use the wrong separator for your Windows regional setting (e.g. m-d-y ).
Cymulate is reporting how embedded video in Word or other Office documents are another way for criminals and hackers to infect your computer. It’s yet another example of how Word, Excel or PowerPoint documents can be used to get malware onto computers to steal data, becomes bots or other nasties.
Changing an Excel formula into the values is amazingly easy. It’s just a copy and special paste. Another way to think of it is deleting the formula but leaving the results in the cells. Select the cells. In this case from our article on converting text cells into Excel dates.
The 2018 Scrabble World Championship is over. How does the Microsoft Word spell check fare against the Scrabble champs? Microsoft Word has slightly different dictionaries for many English language variations (US, UK, Australian etc). Word’s English dictionaries different from the official Scrabble dictionary. Among the words in the final rounds
A judgement from the US Court of Appeals turned on the Word Count feature in Microsoft Word and how it differs from the rules for court submissions. Most courts have rules about the length of submission which, in this case, were accidently exceeded. The plaintiff is representing himself (‘pro se’)
Adding or subtracting months in Excel is easier with the Edate() function. As you probably know, Excel uses whole numbers to calculate dates. Add 1 to an Excel date adds a day. How to add a whole month? How to make Excel jump a whole calendar month? For example from
A New York Times article about parents writing their kids college entrance essay reminded us of a forgotten feature in Microsoft Word. A feature of modern ‘helicopter parenting‘ is helping, if not entirely writing, essays for their children. The article How I Know You Wrote Your Kid’s College Essay by
An Australian university has developed a font that will help you remember what you read. It sounds like an April Fool’s joke, but the font is real and works in Office for Mac or Windows. Sans Forgetica was made at RMIT University in Melbourne, Australia. Unlike most fonts, Sans Forgetica
Adding email, calendar and contacts Live Tiles to the Windows Start Menu would seem like an obvious thing to do. Here’s how you can workaround to do it. On the Windows 8 and 10 large Start Menu are ‘Live Tiles’ which are updated to show the latest information. Some of
A fun new font using famous logos for letters also demonstrates where Windows 10 and Windows 11 color font features become useful with Microsoft Word. Brand New Roman is a fun mashup font made up of famous logos. It looks best in color so it’s handy that Windows 11/10 supports
The Windows clipboard is quite limited but there’s a better one hiding inside Microsoft Office for Windows. It can collect more items, paste in any order and be cleared when you like. We’ll also show how to keep the sometimes annoying pane out of the way. You’re about to hear
A new report from Sophos shows how hacking via Office documents has changed of lot in 2018 with new attacks coming much faster than in the past. Microsoft’s assurances that a security bug (sorry ‘exploit’) hasn’t been used ‘in the wild’ doesn’t mean a lot. Office document hacks made in
Outlook has only one date and time related feature in email messages. As you may know, Outlook’s email editor is really Microsoft Word with limited features. On the Insert tag there’s a Text | Date & Time option which opens the same dialog as in Word. Update Automatically inserts a
Each Word document has various hidden data fields and some are called mapped content controls. They let you set some text or date in a document which is automatically repeated any other place in the document that has the same control. Mapped Content Controls are an alternative to other ‘repeating
A small collection of non-security patches for Microsoft Office in September 2018. As usual, all these updates should come to you automatically. Non-subscriber / perpetual licence users can download individual patches if necessary but auto-update should handle it for you. Outlook 2016 The update for Microsoft Outlook 2016 introduces the
When you buy Microsoft Office there’s no CD or DVD with the software to install. The vital thing you’re getting is the Product Key. The Product Key is that the 25 character code which unlocks or activates the software. This applies to both Office 365 ‘subscriptions’ or single-purchase Microsoft Office packages.
After the report of buying illegal Microsoft Office via Amazon (and Amazon’s initially poor response) here’s what to do if you’ve bought an illegal, pirated or at least non-working Office Product Key. Credit Card as separate transaction Whenever possible, pay by credit card. The MS Office purchase should be a
After our recent Excel worksheet for visitors to Europe we were asked for a similar one to help people stay onside with the UK Statutory Residence Test (SRT). This is a test to decide if someone is a UK resident for tax purposes. Depending on the situation, a person can
“More of the same” in August 2018’s round of security fixes for Microsoft products including Windows, Office, Word, Excel and PowerPoint. Overall there a sixty security flaws fixed this month alone, including two ‘zero-day’ bugs not previously known to the public. We’ve all become accustomed to this never-ending stream of
You can quickly apply some Word styles from the Quick Access Toolbar we’ll show how to add the classic Style menu, buttons for Headings and Normal style. And we’ll explain a better alternative. The Quick Access Toolbar (QAT) can have a more useful Style menu than the one Microsoft puts
