There’s more than one Credit Card 💳 image available in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Credit Card 💳 looks in different fonts. Only two standard Windows fonts have the credit card symbol; Segoe UI Emoji and Segoe UI Symbol.
Grouping in Excel lets you collapse or expand sections of a sheet so you can see the ‘big picture’ but still drill-down to how totals were made. Another use for grouping is hiding rows or columns from view. You can organize and manage data more effectively by grouping together rows
A respected author has a warning about the future of AI using the mixed history of spreadsheet mistakes as an example. Tim Harford is an excellent columnist and author known as “the Undercover Economist”. Check out his “More or Less” podcast for the BBC. In a recent article he argues
Excel has some nice choices for clearing out cells quickly. You can remove the contents, the formatting only or both contents and formatting plus choices for deleting just notes, comments and cleaning up links. As you can see the drop-down menu Home | Editing | Clear offers options such as:
Excel has some useful options for printing less than an entire workbook. Printing a selection, active sheets or just a table. As Office-Watch.com has discovered before, there’s a lot more available in Office than a quick look suggests. See Print options are at File | Print then choose the menu
There are shortcuts that automatically format bold and italic text in Word. The same shortcuts and more work in WhatsApp texting as well. There are now four more formatting options; bullet lists, numbered lists, quotes and inline code. AutoFormatting Bold and Italics as you type In Microsoft Word and Outlook
Make an unpleasant point with the world’s ugliest color. A ‘drab dark green’ can be used in any Word document, Excel sheet or PowerPoint slide. And we’ll explain the recommended complement color and font. It’s not our opinion, but the market researched result of an effort to find the most
The British have 546 ‘drunkonyms’ or words for drunkenness according to a new academic study. We could not resist seeing how the Microsoft Word handles them (after we’ve had a quick drink to get us going 😀) We compiled a list of 55 drunkonyms and ran them past the Word
How can you buy an older version of Microsoft Office to fit in with your other computers? Fran, a loyal Office-Watch.com reader has that problem getting an older version of Office. “ I have Office 2013 on two computers now. Is there a way to get another copy for the new Microsoft Surface
Here’s a way to ensure your outgoing emails include DKIM and SPF details all setup correctly. DKIM email verification is becoming more important for deliverability of emails. This is mostly for anyone using Microsoft 365 email hosting, especially individual or small business users who have change their email verification setup.
Ever wondered what fonts say to each other. How newcomer Aptos treats Calibri? How Dingbats dance and what Comic Sans wears? Elle Cordova answers these and other important typographical questions in two Instagram videos. Fonts Hanging Out part 1 https://www.instagram.com/p/C2cZBIAr24m/ Fonts Hanging Out part 2 https://www.instagram.com/reel/C2sxcszyLnN/ Enjoy … Excel –
All Outlook for Windows have a critical bug which makes it too easy for any hacker to gain access to a computer. It just needs a simple link clicked from an email to bypass Office Protected View protections, even from the Preview pane. So all Outlook’s should be updated asap.
The latest AI tools can help add a personal touch to Valentine’s Day images, graphics and text like a love poem. Add some details about your loved one (name, hobbies etc.) and AI can do its magic. Free AI tools like Copilot, Microsoft Designer, Dall-E or ChatGPT can make something
Most readers of Office Watch will have a Microsoft account but is it as secure as it should be? Two-step authentication is becoming essential for the key Microsoft account. If you have Microsoft 365, OneDrive, Outlook.com, Windows 11/10/8.1/8, Windows Phone or (likely) Skype then you’ll have a Microsoft account. It’s
Two economics professors have been caught using Excel’s Autofill feature to fill in the blanks to complete a published academic paper. A study on green innovations and patents in 27 countries by two professors has come under scrutiny by a student as reported, by Retraction Watch. The paper was said to use
More than five ways to type characters with accent, grave, circumflex, tilde, umlaut, dieresis or cedilla in Microsoft Word and Outlook when they aren’t on the keyboard such as á ã à ä Ç ç ē é ê è ë â ê î ô û and many more. Typing accented
Compare one set of numbers with another list of values using ChiTest() in Excel. It compares two sets of numbers and gives a single number to show how different the sets are. ChiTest() or ChiSq.Test() sounds like a complex formula that only expert statisticians can understand – not at all!
A technical issue has been affecting Outlook.com users who try to access their accounts using various email clients, Microsoft announced. The problem started on January 23, 2024 was partly resolved late on 31 January and finally on 2 Feb for some but not all customers. Outlook 2013 and Outlook 2016
Wordpad is about to be removed from Windows 11, here’s something you can try to keep this useful Word document app available. Microsoft is ending WordPad the long-standing app that’s installed with Windows which can open, view, edit and print Word documents (.doc .docx) and RTF files. Microsoft isn’t just
Here’s a combined ‘one-click’ way to force an update to both Windows and Microsoft Office at the same time. Normally Windows and Office both update themselves automatically and in the background so you don’t have to worry about it. But there are times when you need to ensure both are
At long last, there’s a way to get Microsoft Forms results synchronized with an Excel workbook. It’s not what Excel users were expecting but it’s a start. Microsoft is calling this a ‘highly anticipated feature’ which is corporate weasel term for a long-standing customer request that’s finally fulfilled (in part).
Check that emails you send are labelled properly with your name in the FROM box. It’s a common email mistake we see every day. We found a problem with Outlook that makes this mistake automatically for Gmail users! The FROM: part of an email can have the wrong name or
Let’s take a moment to explain, without the hype, what Copilot is and what it can do for you and all Microsoft Office users including Office 2021,2019 and earlier. We’ll explain some ways Copilot can save time and money doing simple tasks for anyone with Microsoft Office. Beleive me that
Many different ways to type or insert laundry care symbols, which appear on clothing labels, into Word, Excel or PowerPoint. Laundry care symbols can be for laundry area signs or for fun like this t-shirt. Or alternative symbols in a PowerPoint slide. All five symbols were black laundry care icons.