Microsoft has finally confirmed what was long suspected. There will be another fixed price, perpetual licence version of Microsoft Office. The successor to Office 2019 will be released in late 2021 for Windows and Mac. Update in late 2021: of course we now know it’s called Office 2021 All about
There are several ways to fill in a PDF form and add your signature with Microsoft Word, Acrobat Reader or online services. All these tips are free with nothing to pay. It’s possible to ‘sign’ a PDF form and return it without making a paper copy. Paper forms are so
Common programming tools can be used to make malicious Office workbooks which bypass both online security checks and Microsoft’s own protections in Word, Excel, PowerPoint or Access. We’ll explain what’s happening and what Microsoft could do better. VBA Purging or VBA Stomping are clever tricks to make an Office documents
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter Deegan has been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost quite beyond
Stop duplicate names, email addresses or product SKU’s from being added to an Excel list or Table. Adding more rows to an Excel Tables can be done while preventing accidental duplicates creeping into the list. Excel Tables or lists can grow to hundreds or thousands of rows, there’s a risk
Microsoft is releasing a ‘Quick Poll’ option in Outlook ignoring the very similar, voting buttons, option that’s already in Outlook for Windows and Outlook for Mac. Use Voting Buttons to ask a question and Outlook will automatically collect responses. Office Watch also explains how recipient see the voting options and
Everyone with Microsoft 365 can get a ‘quick poll’ now with any email account or software. No need to wait for the Outlook Quick Poll option, now in preview for Microsoft 365 customers with Outlook for Windows. As we’ve already explained, Quick Poll is a simple and very limited way
Type the Left Right arrow ↔ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Left Right arrow ↔ looks in different fonts. Here’s some examples of how Left Right arrow ↔ looks in common Office fonts. Left Right arrow ↔ codes
The secret to a timeline chart in Excel is the data. Emily writes asking “How can I make an Excel chart with dates on the X axis with a proper time scale – even if the dates aren’t regular? “ We could not understand Emily’s question until we asked for
With all the subscription offerings available (Netflix, HBO, Disney, CBS, Apple, Google, Amazon, Office 365 etc), here’s a way to manage them all from Excel. Along the way we’ll show you some interesting Excel features. We were inspired by Brian X Chen in The New York Times, writing about how
Change the look of Microsoft Word footnotes and endnotes. You can change the look of footnotes and endnotes using their linked styles: Footnote Reference Footnote Text Endnote Reference Endnote Text The two ‘… Reference’ styles create the look of the numbers, usually just superscript positioning of the default paragraph font.
The Notes Pane is the key to some useful Footnote and Endnote options Now that Print Layout is the main editing view in Microsoft Word, the Notes pane has been somewhat forgotten but it’s the home of details in the Footnotes and Endnotes. Get to the Notes Pane Switch to
Don’t like that short dividing line between the Word document and footnotes/endnotes? You can change the color or look. Even delete the line completely. Though it’s hardly obvious even to Word experts. Most commonly you want to remove the footnote dividing line to completely hide the footnotes from a version
Hiding footnotes in Word triggers an annoying bug that’s been there for at least ten years. There’s no sign of it being fixed. While looking into Footnotes and Endnotes in Word for Office-Watch.com we came upon a strange bug. Anyone trying to hide the footnotes in a document will strike
The names of genes are being changed just to stop Excel confusing them with dates during the import process. We’ll explain two ways Excel already works to avoid the geneticist’s problem. Genes named like MARCH1 and SEPT1 which Excel converts into dates when imported the wrong way, usually directly via
Why does Excel change what people type or import, sometimes in ways they don’t want? It’s the General cell format that messes with what you type or import. It’s the default cell format ‘General’. It’s top of the Formats list and most of us haven’t given it a second thought.
A new Windows 10 update includes fixes for some Office related bugs for Word, Excel and Outlook. The patch is called KB4568831 released July 31, 2020 . It’s for the latest Windows 10 May 2020 release (aka ‘2004’ or ‘Build 19041.423’). It’s a large update which fixes many different Windows
Word 365 and Word 2019 for Mac have the same Read Aloud option that’s in other Word releases. Word 2016 and earlier have other options to speak the words in a document. Word 365 and Word 2019 Read Aloud starts from the Review menu. That opens a control panel with
If you’d like to make your social distancing sign stand out, check out some of these examples using animals and objects to explain the distance needed. And we have some more simple template Word signs for our newsletter readers. Here’s a simple example from the Sydney University Veterinary Hospital Use
PowerPoint 365 way back to PowerPoint 2010 all have a ‘text to speech’ or ‘Speak’ feature to read aloud the text in a slide. It’s hiding away behind the ribbon but works fine once you’ve found it. The PowerPoint Speak or Real Aloud feature is similar to the Speak option
Excel can speak the numbers, dates and text in cells. It’s a feature that’s been hiding in Excel since Office 2007 through to the latest Excel 365 for Windows. Speak in Excel is like Word’s Speak but with a few useful spreadsheet options. The audio options are mostly intended for
Microsoft has made a major blunder with the July patches for Office. An update can crash Outlook for Windows entirely and the reason for the problem makes the bug especially humiliating for Microsoft. We’ll explain Microsoft’s blunder, what you can do if affected and how to avoid the buggy patch.
Read Aloud is the newer and better form of the old Speak feature from Word 2016-2010. It’s available in Word 365 and Word 2019. Read Aloud has more controls than the older Speak feature and it appears in more places within Word. The voice selection and settings in Windows are
The Excel team has joined the current ‘Cake’ meme with a new Cake() function in Excel. Hilarity ensues … Source: Twitter Ho ho, very funny, it is to laugh. Most people took the message in good spirit with one person implementing it in VBA That code really works. ChrW() returns
