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
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
How to make an Excel chart that changes as you add more cells or rows is really simple these days. Forget all the old stuff about named ranges or changing the Chart data. Setup your Excel list correctly and any linked charts will update automaticall. In a recent article we
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
We’re happy to release a new version of our Subscriptions Manager that’s compatible with Excel 2007-2016. Subscriptions Manager is a way to list and manage the many online plans we sign up for; HBO, Netflix, Amazon, Spotify and so many more. You can track who pays (in a family) and
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
There are changes coming for Office 2010 and Office 2013 for Windows plus Office 2016 for Mac on 13 October as Microsoft makes their online services incompatible with older versions of Office. We’ll explain what’s happening, to whom and the effects. What’s happening? Some older, less secure connection methods will
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.
Microsoft Office 2010 ends support later this year but there’s no need to panic. Here’s what to do, when to change from Office 2010 and what to replace it. Office 2010 countdown [ycd_countdown id=”31774″][/ycd_countdown] Office 2010 ends support on Tuesday, 13 October 2020 All the Office 2010 programs will keep
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
Getting started with Word’s footnotes and endnotes. Footnotes is one of those Word features that’s been around for a long time and so it often ignored in all the hoopla about new features. In this article we’ll have a close look at Footnotes and Endnotes. In Word there are Footnotes
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
2020 will be remembered for many things (big sigh) but from a design viewpoint, it could be the Year of the Icon. Many of those graphics are available either in Office directly or imported from elsewhere – we’ll show you both. Everywhere you go there are signs reminding us of
Word 2016, Word 2013 and Word 2010 for Windows all have a ‘text to speech’ or ‘Speak’ feature to read back a document. It’s hiding away behind the ribbon but works fine once you’ve found it. Speak button can be put on the Quick Access Toolbar or Ribbon. Select some
Despite fair warnings, Microsoft has allowed an old Excel format .SLK to get past their email security and infect Excel for Windows computers. As reported by Avanan, criminals have found a way to bypass the email security for Office 365 hosted mailboxes (possibly Outlook.com as well), allowing an infected email
How to quickly fix display problems in Microsoft Office. When Word, Excel, PowerPoint or Outlook don’t show up on the screen correctly. It doesn’t happen often but occasionally Word, Excel, PowerPoint or Outlook open but as all grey. Clicking around the screen displays just a ribbon or menu but not
Outlook can record appointments in the Calendar but it can also record ‘recurring’ appointments for things that happen on a regular schedule. We’ll show you how to make a repeating appointment and suggest some ways it can be used that might not be immediately obvious. Repeating Appointments 101 To make
Headline your next document with cats! Looking for something really different to headline your next document or presentation – why not use ‘Neko Font’ the font made out of cats. Strictly this isn’t a font you can download, instead you type text into a web page, choose the size (Large,
