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
Dictate now has formatting commands with two ways to apply bold, italic, underline and other text formatting as you speak. Dictate with formatting is now available in Word Online (in a web browser) for Microsoft 365 customers. It’ll spread to other Word releases (for Windows, Mac etc) later. To use
Setting up and testing a microphone to work with Windows 10 is necessary before using Dictate in Office. Go to Windows settings to control which microphone is used by Word 365’s Dictate. Dictate has no microphone settings of its own (in Word for Windows or Word Online). Both use the
Mac Word 365 and Outlook 365 have the same powerful ‘Speech to Text’ option, Dictate, that’s in the Windows version of Word and Outlook. No compromises or differences except the setup is a LOT easier. Dictate is only available to Microsoft 365 subscribers with Office 365 software for Mac, Windows,
Let’s look at the ‘Big Picture’ of Project Moca. Each overall Space has a Canvas, menus and Zoom options. Each Space can contain Bucket, Notes, Tasks, Goal, Weather, Location, Person, Email or Calendar items. See Inside Project Moca – Bucket, Notes, File and many more Spaces Project Moca can have
Project Moca is a new and interesting offering for some Microsoft 365 customers. A single web page that you can pin task lists, emails, calendar items, notes and more. It’s an attempt to bring all the separate features of Microsoft 365 into an overall view or spaces. This is where
Outlook for Windows is getting a different way to ask questions of people via email – a quick poll. Quick Polls use Microsoft Forms, the online quiz or polling system. Start in any new message, Insert | Include | Poll. It’s more likely you’ll just see a small bar graph
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
According to Microsoft, there’s only four audio formats accepted by their new Transcribe option to convert audio into a text transcription. That’s not true, there are more formats possible with no conversion necessary. The official list of audio formats for Transcribe is .MP4 .M4A .MP3 and .WAV. Strictly speaking that’s
Microsoft is making an important step towards cloud storage security with the public preview of Double Key Encryption. That means, for the first time, Microsoft customers can secure their data from access, even by Microsoft itself. All the ‘secure’ cloud storage from Microsoft can be accessed by Microsoft. For all
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
Microsoft 365 Translator now has the language Odia (or Oriya), taking the list of Indian languages supported to 11. in Odia, according to Microsoft …. Microsoft 365 ଅନୁବାଦକ ବର୍ତ୍ତମାନ ଓଡ଼ିଆ ଭାଷା (କିମ୍ବା ଓଡ଼ିଆ) ଅଛି, ଯାହା ଦ୍ୱାରା 11ଟି ଭାରତୀୟ ଭାଷାର ତାଲିକା ଗ୍ରହଣ କରାଯାଇଛି । Microsoft Translator is a cloud-service so Odia
Microsoft has a Microsoft 365 offer for students and recent graduates that’s worth a look but watch out for the fine print. The offer is Microsoft 365 Personal for $12 instead of $69.99 which is a good deal if you qualify. It’s available to students and recent graduates of colleges/universities
There are strange and worrying reports of double billing, disconnection of service and other anomalies that leave some Microsoft 365/Office 365 paying more or getting less than what they paid for. Here’s what to do if your Microsoft 365 account and billing has gone wrong, Just some of the troubles
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.
