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
Copilot now has some in-built editing of the background of an AI made image, some borrowed from similar features in Designer. Request an image from Copilot e.g. “Make an image of a koala in the desert”, select one of the thumbnail pictures to see the full size version. Click on
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.
A good part of Designer has been deleted with no notice or explanation. Erase is missing with only a ‘dumb’ alternative. The feature is Erase it let you select and remove parts of an image and automatically fill the area with surrounding content. The entire ‘Erase’ option has disappeared for
All Microsoft 365 administrators should make sure this setting is completely ON to ensure emails are delivered and not marked as spam. It’s a setting many administrators might assume is already on but it’s not. Some email hosts have started stronger enforcement of two email verification systems called SPF and
Microsoft Loop has a new feature that should be added to Word and PowerPoint, see what text has been written by Copilot AI instead of a human. Loop is adding a tag (‘floatie’) which shows who wrote some text and includes ‘Copilot’ as one of those authors. That’s a very
Need a heart symbol or image for your Valentine’s Day message, email, slide or card? Microsoft Office Icons have many choices available including Icons. Many of the stock or supplied resources in Office have passionate ‘heart’ symbols. As you’ll see, there are some anatomically correct icons among the romantic ones,
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
There are two options for changing the default fonts in Excel, either for new blank workbooks or existing spreadsheets. Maybe you prefer another font. Perhaps the old default font until mid-2023, Calibri. Or a spreadsheet specialist font like Goldman Sans. Maybe your organization or client has a preferred font? Go
Here’s the simplest way to switch from Aptos fonts in Excel 365/2021/2019 to either the previous font (Calibri) or some other font. In Excel, Aptos Narrow is the new (mid-2023) default font style with a font size of 11, Black. What if you don’t like the new default font? Aptos
Just by using Copilot you’re giving Microsoft free access to anything you do or get from their AI system. It’s a legal trap that everyone needs to keep in mind. We found this buried in the Copilot Terms and Conditions (T&C’s) starting on the Bing web site https://www.bing.com/new/termsofuse (strange place
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
While a lot of Word, Excel and PowerPoint might appear to be the same for decades, there’s a lot of work happening ‘under the hood’ to keep Office working. Gilad Oren at Microsoft has written an interesting piece on how the whole real-time collaboration feature in Microsoft Office has been
For yet another way to make AI images, perhaps with a different look, you can now try Google Bard. Bard is Google’s AI helper, now available in ‘most countries’ (Google’s wording) but only in English for the moment. It does all the things we’ve come to expect from a broad
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
Keyboard shortcuts for special characters that work outside Office and without special setup on any Windows computer. It’s possible to enter any character into a Windows program using the Alt key plus the number pad (usually on the right side of a larger keyboard). This is a handy shortcut to
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!
