You can combine Excel cell formatting into a style, but not like in Word. Excel has Styles … truly it does. Word has a way to combine formatting attributes of a letter, word or paragraph into a single block with a name like ‘Heading 1’. Excel has a feature also
Slipped into the bottom of a long Microsoft announcement was news about which versions of Microsoft Office would not be supported on Windows 11. According to Microsoft, Office 2013 is not supported on Windows 11. With that little snippet of news, here’s the list of Office releases that ARE supported
Get the best quality images in a PDF file made from Microsoft Word for Windows by changing some simple settings. There are also options in Word for Mac, Excel and PowerPoint. Better quality images in the PDF file are possible, starting with Word’s settings for saving images within the document.
There’s a curious trick which might let you print a PDF that’s causing printer errors. An Office Watcher started getting PDF’s which looked OK on the screen but produced errors when he tried to print out. Otherwise the printer worked fine so the problem seemed to be in the PDF
Amazon UK is offering Microsoft 365 Family at about £31 less than the usual price for both new and renewing customers. Thanks to an Office Watch reader, we can tell you about an even better deal from Argos. An even better ARGOS Offer Thanks to Julian H. for telling us
A clever techie, Rudy Ooms, has found a worrying bug in Windows 10 and Windows 11. The Wipe and Fresh Start options are supposed to remove all user data from a computer but leave really obvious files behind and unencrypted. The problem is the Windows feature which is advertised as
A delightful piece in The New Yorker turns a resume cover letter into an ode about the applicants love of Microsoft Word. Eli Burnstein’s humorous article opens with: “Bold and italics are the oils that grace my palette. Cut and paste the strings upon my lyre. Fonts, bullets, columns, indentations—these
Amazon UK is offering Microsoft 365 Personal at about £30 less than the usual price for both new and renewing customers. There are a few peculiarities about the offer, we’ll explain those below but the basics are: Microsoft 365 Personal (one user) New or renew/extend existing plan Regular price £59.99
Microsoft has released a preview anti-virus and security apps for Apple iPhone / iPad, Android plus Windows and Xbox called, confusingly, Defender. Trial apps are available for personal use now but in future you’ll need a Microsoft 365 Personal or Family plan. Defender was the name of Windows protection parts
The Outlook mobile app from Microsoft is ending its support for older versions of the Android operating system. Office Watch explains who is affected, how and when. All these changes apply to devices with Android 7.1 and previous. That’s a quite elderly version of Android (by tech standards). The current
Jon has found a clever way to show words (singular, plural or zero) with many numbers in Excel using conditional formatting. We already shown you several ways to put singular or plural words against numbers in Excel – like 1 cookie or 3 cookies. At the end we noted how
Excel 365 has a way to grab information about movies dropped directly into worksheets. Get info about films, cast, director, rating, budget, box office returns and a lot more with the Linked Data Types. Our ebook Real Time Excel goes into detail about Linked Data Types as well as more
Excel 365’s Linked Data Types have gone beyond the original Stocks and Geography feeds. Now there are more Linked Data Types to pull more public information into Excel 365 workbooks about diverse topics as Anatomy, Chemistry, Plants, Movies and more. It’s a massive extension of the existing Stock and Geography
There’s a quick way to clone or duplicate an existing file in Windows 11 so you can make a new, similar document. Quite often a new document is based on an existing one, for example a fresh invoice for the same things each month. Or a proposal to a new
Why are the numbers on the numeric keypad are different from the number keys on the top row of the keyboard? How to use either set of number buttons in Microsoft Word. “I don’t understand why pressing a number on the main keyboard is different from the number pad (assuming
“I’m confused. In Outlook there are two choices for a UK/London time zone. UTC or London. Both are zero meridian (+00:00). What’s the difference and why isn’t an entry for GMT?” Oscar R, Missouri. The quick answer is to always choose the time zone entry that matches the city or
Sensing a big opportunity to poach Google customers, Microsoft is offering a 60% discount starting deal to unhappy G Suite customers. Here’s the details and inevitable conditions. Google has angered many G Suite customers with their plan to ‘upgrade’ free plan customers to a paid account. Microsoft has moved quickly
Email Read Receipts sound great but don’t often work these days. Articles like “How to tell if someone opened and read your email” aren’t telling the whole story. Here’s the reality behind the Outlook ‘Read Receipt’ feature and how it works across the Internet. The idea is to send an email
There are limited options for entering the current date and time into PowerPoint slides, notes and handouts. PowerPoint doesn’t have field codes like in Word, so Microsoft seems to have shoehorned in some field like features. Insert Date and Time in slide On the Insert Tab, right side there’s an
The COUNTIF worksheet function in Microsoft Excel has a simple format that provides a quick and easy way to count the number of times a certain condition is met in a data set. By Kara Monroe That sounds imposing but it isn’t. Most likely you already use COUNT to count
Excel has an in-built feature to remove duplicates from a list but what if you want to delete both items if they are duplicated or more than two? Remove Duplicates Remove Duplicates is tucked away on the Data tab, Data Tools | Remove Duplicates. It will ensure that an Excel
Three ways to insert or import an EPS (Encapsulated PostScript) graphic into Word, Excel, PowerPoint or Outlook. There are two a ‘quick and dirty’ options and a way that allows some editing. Microsoft Office did support EPS files for many years but dropped them in 2017/2018 because the EPS format
There are four different ways to change an Office icon or SVG graphic in Microsoft 365, Office 2019 or Office 2021. The two official SVG edit methods in Microsoft Office with their in-built limitations or some choices before inserting into Word, Excel, PowerPoint or Outlook. Within Office Limited SVG/Icon changes are
Some simple changes to SVG graphics can bypass some of the more annoying limits of SVG support in Word, Excel and PowerPoint for Office 2019/365. Here’s a simple SVG with three parts: the circle <circle> the rectangle <path id=”bar” …> letters are defined in other <path … > and <use
