Entering blocks of text in Excel is quite easy. What’s not obvious are all the options to make the text easier to enter and look better. Just typing in a cell will enter text. By default it will extend into any unfilled cells. If there’s something ‘in the way’ the
You may have heard about ‘Project Monarch’, Microsoft’s plan for a single Outlook program for Windows, Mac and maybe other platforms. This is what we know so far about Microsoft’s ‘vision’ for ‘One Outlook’ Project Monarch is an early Progressive Web App (PWA) which will have email, contacts, calendar and
Here’s how to install Outlook as a standalone web app or PWA. This looks like Outlook in a browser but it’s not, it’s Outlook as a standalone Progressive Web App (PWA). It’s available now in Windows 10. It’s not the upcoming Project Monarch but a part-way step in that direction. See
Microsoft Office (plus Word, Excel and PowerPoint) can be installed as a standalone web apps or PWA. We’ll explain how and the current limitations. This looks like the Office.com web page but it’s not, it’s Office as a standalone Progressive Web App (PWA). It’s available now in Windows 10 with
Windows 10X is coming and you’ll hear a lot about it in the coming months. Let’s see what Windows 10X is, how it will run Office (Word, Excel, PowerPoint, OneNote and Outlook) and why most people won’t need to worry about Windows 10X. What is Windows 10X? Windows 10X is
News that WhatsApp is sharing more data with Facebook (the owner) has led to a stampede of people moving to more private alternatives. But which – Signal or Telegram? Secure messaging is an important way to safely and quickly exchange any type of file or document. Even if you’re not
iCloud accounts can now be added to the new look Outlook 365 for Mac but there are limitations and it’s harder than Microsoft’s ‘help’ says. Outlook for Mac has always been able to link with iCloud using IMAP. Now Outlook 365 for Mac with the new interface can automatically setup
Microsoft announced 83 security bug fixes for January 2021, the count is really 96 once you add the Edge browser patches from last week. At first look, it seems there’s only five Office related patches including two each for Word and Excel. It’s important to keep both Office and the
Amazon UK has a good deal on Microsoft 365 Family (six user). For the next week only save £30 on the regular price for new and existing customers. Pay £49.99 for (another) year of Microsoft 365 Family, instead of £79.99 which is what Microsoft charges for automatic renewals. Click here
Benford’s Law is an amazing tool that is simple to use in Excel. Benford’s Law is one of those mathematical laws that seems to defy common sense but works for most naturally occurring number sets. It says that in most groups of naturally occurring numbers, the leading digit 1 will
Continuing our series on the ‘Not Allowed’ symbol, let’s make a versions with text instead of a graphic or icon. Check out our article on Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint about creating, resizing and coloring the basic shape. Text in circle Instead of
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with text and graphic or icon. Check out our article on Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint about creating, resizing and coloring the basic shape. Better ‘Not Allowed’ red circle/line symbol with
How to convert metric to imperial and other measure conversions in Excel. Converting measurements from one system to another can be done by Excel using the CONVERT function … here’s how it works and then we’ll tell you what CONVERT can’t do or should do better. As usual, we decided
As we mentioned back in October, Office Lens has been dropped from the Microsoft Store but it’s not the end of Lens, far from it. Microsoft announced that the cloud services backing Lens features would be disabled from 1 January 2021. Only Office Lens for Windows 10 and Windows Mobile
There’s plenty of scope for variations on the basic Not Allowed symbol (red circle with diagonal) using the tools in Microsoft Office. See Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint for how to insert the basic ‘Not Allowed’ shape and change to suit your needs.
Well, that’s been an ‘interesting’ year for all of us <sigh> . Here’s some of the articles that have been popular with our worldwide audience over 2020. Getting more from online video calls With the global lockdown, Office Watch switched roles for a while and added lots of advice for
Microsoft India is raising the price of their commercial and online services from 1 February 2021. The news is out despite a pointless attempt at secrecy by the local subsidiary. As reported by DQChannels Commercial on-premises software goes up 11% Online services like Microsoft 365 hosting goes up 9% The
Argo UK is offering Microsoft 365 Family for just £39.99 saving £40 or half the regular price of £79.99. But there’s no deadline given so we suggest you grab one or more packs asap. UPDATE The price has changed to £59.99 which is still a good deal on a 12-month Microsoft
Microsoft has announced some changes to the Editor feature in Word and Outlook to improve access to spell-check and grammar tools. Look for these changes in upcoming releases of Word and Outlook for Windows and later for Mac. Many reports on these changes say that the Editor is a ‘new
NewEgg is offering a 15-month new or renewal of Microsoft 365 Family for just $75 saving about $45. There’s a special discount or promo code that we’ll tell you below. UPDATE The price has changed to $99 which is still a good deal on a 15-month Microsoft 365 Family. $99
If you like to jazz up your Zoom, Teams or other presentations, try out mmhmm . It looks like an interesting tool you might like to try out over the break. mmhmm lets you create an online presentation for live broadcast or recording with many effects combined. Here’s an example
Commercial users of Microsoft Teams can now quickly switch to a personal account without shutting down the app or browser window. Personal Teams can keep in contact any group of people, family, extended family, school friends, study group, class, sports team or club. See Teams gets personal for families and
Pantone has announced not one but TWO ‘colors of the year’ for 2021 and, as usual, we’ll explain how to use those exact colors in Word, Excel, PowerPoint and Outlook. The colors of 2021 are … Illuminating and Ultimate Grey As usual what’s more amazing than the color is the description
Word and PowerPoint online, the browser versions, now have the same Synonyms feature that’s in the Windows and Mac releases. Synonyms helps you vary your vocabulary by suggesting alternative (different, substitute, other ) words. If you’ve used Synonyms in Office for Windows or Mac, there’ll be no surprises in the
