Computers are being infected with at least eight different viruses in an attack that uses steganography to hide nasty code in images linked from Word and Excel documents. But there’s good news for most Office users. Steganography is a way to hide text or code in an image or object.
The File Open and Save dialog boxes in Office have many not-obvious features which let you do a lot of file management and housekeeping on the spot. You try to save a document and realize you need a new sub-folder. Or open a document and want to move it to
Pictures in Word, Excel, PowerPoint and Outlook can make the file sizes at lot larger than you expect. Here’s how to make images smaller (in file size) for Office documents without changing the look of the document, slide etc. The images in a document are what take up a lot
The world can be divided in many ways — how about by paper sizes? Letter/Legal/US sizes vs A4/Metric. Microsoft Word makes it easy to cope with both even with different paper sizes in one document. There’s a very handy way to rescale between Letter <> A4 for printing. Amazing Maps
How to insert the Coin 🪙 symbol or emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Coin 🪙 looks in different fonts Only Segoe UI Emoji font has the coin symbol in standard Windows. Coin 🪙 codes These are the
For many readers being able to edit incoming Outlook messages is just a handy feature, but for anyone in the legal or corporate world it could have ‘interesting’ consequences. In Outlook for Windows, open the email in a full window (not the Reading Pane) then go to Message | Move
There’s a useful but niche Excel warning about date with two digits for the century. That’s a useful precaution but sometimes the warning is wrong! Those of us around at the turn of the century will remember the Y2K problems and possible mistakes with a date that has only two
Copilot AI makes writing Excel formulas a lot easier but you still need to check the results to make sure Copilot has understood want you want and gives the right answer. There’s a lot of hype and promises about how AI can help make work easier. That’s not as true
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
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!
