Here’s a better and more flexible version of the Calendar Creator with both Sunday and Monday start of week. Office Watch reader, David Peel, has made a better, more compatible Calendar Creator. We added some different versions to suit other calendar formats. We’ve told you about The Mystery of Excel’s
There are 2024 calendar templates available for PowerPoint, giving you landscape oriented calendars but less options overall. Landscape calendars PowerPoint calendars aren’t just for presentations. They offer printable landscape orientation calendars not usually available in Word or Excel. Look for the overall layout you want, change the images and colors
Excel can make calendars from some supplied templates. Some templates are labelled with a specific purpose however a few simple changes can make them better and suit what you need. Sadly, the help with the templates can be wrong or misleading. Here’s just one example to show what’s possible to
In January 2024 a former Microsoft employee will become a Queen. A real live Queen from a noble and respected European royal house not some nerdy or made-up social media title. The former Mary Donaldson of Hobart, Australia and past employee of Microsoft Denmark is now better known as Mary,
All about Find in Microsoft Word Text Boxes. Text Boxes in Word have special needs when you’re either looking for text inside Text Boxes only or just the main document. What’s inside Text Boxes is handled separately to the main document, depending on the options you’ve chosen for the search.
Find and replace inside Microsoft Word Text Boxes is something that Word can’t do directly but is possible in two different ways. As we’ve already explained, Word can only find text inside Text Boxes as either part of a search of the entire document or just the content of Text
Let’s go deeper into the Microsoft Word ‘Find’ function, looking specifically at a number of options that can be accessed in the Word “Find” feature (Ctrl+F) and clicking its “More” button. In a recent issue of Office for Mere Mortals we looked at how to search within a Word document. There
Excel can’t add up reliably and it never has. It’s an important limitation of computer software that everyone needs to be wary of. Phil N sent us an interesting Excel worksheet. He’s simply adding a column of numbers starting with a negative number then positive numbers – the total should
PowerPoint’s ‘camera in slide’ feature ‘Cameo’ is getting a welcome boost, if not an essential piece of Cameo. Cameo placeholders can be added to Slide Masters. Cameo is Microsoft’s name for putting a live camera image into a PowerPoint slide presentation. It’s ideal for online presentations. That was fine but
Microsoft has added new web links to access Microsoft 365 mailboxes in a browser as well as some other unpublished new domains to reach Office apps in a browser. The web links are https://Outlook.cloud.microsoft or https://Outlook.microsoft Use one of those links and login to your Microsoft 365 mailbox (e.g. Business,
Windows 11 and 10 has the Emoji Panel. What a pity that it totally sucks and is incredibly dumb. Emoji Panel is better than what we had before (nothing) but not by a lot. We’re talking about the Emoji Panel or ‘keyboard’ which appears in Windows 11/10 when you press
All about the Windows 10 Emoji Panel, a fast way to type emoji 😁, symbols §⁜✓, emoticons 🙂 and kaomoji (❁´◡`❁) into any Windows app, document, slide, email or message. This is how it appears in Windows 10. If you have Windows 11, the Emoji Panel works differently, see Get
The Windows 11 Emoji Panel is a quick way to type emoji 😁, symbols §⁜✓, emoticons :), kaomoji (❁´◡`❁) and even animated GIF’s into any Windows app, document, slide, email or message. We’re talking about the Emoji Panel or ‘keyboard’ which appears in Windows 11 when you press Win +
Windows 11 and Windows 10 have a better clipboard but there’s a big problem as well, it’s hidden away and many people don’t realize it’s there. Windows 11 and Windows 10 saves more than one item into a clipboard memory. Most likely you have this enhanced clipboard and don’t even
A scene from a famous UK sitcom could also be used as a unique and overly literate Christmas card. ‘Yes Minister’ is a famous UK sitcom set in the British Public Service and politics. Sir Humphrey Appleby (played to perfection by the late Sir Nigel Hawthorne) gave amazingly convoluted explanations
Five ways to add a Snowflake ❄ symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. There are three snowflake symbols plus two Office icons. Snowflake ❄ symbols are normally used to show, well, a snowflake or generally to indicate cold or
Microsoft is changing the way Word’s Read Mode and Outlook’s Reading Pane looks but it’s hard to know what they’re doing because there’s a lot of oversold hype but little detail. These changes were announced more than two weeks ago and still haven’t appeared on any of our test machines.
How to use the font kerning settings in Microsoft Office, Word and PowerPoint and fix the default setting for Heading styles in Word. Kerning letters makes a difference as the letters get larger so the setting is more important for headings and titles in Word and PowerPoint. Here’s common Arial
Meta has joined the ‘text to image’ AI race with Imagine. Here’s how to use it to make interesting pictures quickly and bypass its current limits. There are so many AI tools out there, in particular ‘text to image’ makers, Microsoft has ‘Generate Image’ in Designer and a separate Image
Excel Labs has just added a nice formula Debug option that helps you understand the steps inside a formula and fix errors. There are already three ways to look inside a formula; Evaluate Formula, F9 to calculate part of a formula and the recent Visual Preview. Now Microsoft’s Excel Labs
There are two important changes coming to Get & Transform (Power Query) in Excel. Both changes are probably already covered by the current setup but you should check any external data links now to avoid an unwanted surprise. These changes apply from 11 March 2024. Microsoft is a little vague
Microsoft Designer has secret key shortcuts to quickly insert shapes and text boxes without jumping to the side menus. All you need to do is press a single letter key to insert one of these shapes: R – Rectangle (inserts a square) C – Circle L – Line T –
Here are three ways to add an explanation or note within an Excel formula itself, instead of separate notes. The ‘Achilles Heel’ of Excel or any spreadsheet program has always been explaining or commenting of cell formulas. Adding comments is an important part of any code including Excel’s VBA but
Pantone’s color of the year for 2024 is “Peach Fuzz”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2024 is … Peach
