Here’s a better and more flexible version of the Calendar Creator with both Sunday and Monday start of week. We’ve told you about The Mystery of Excel’s Calendar Creator template which doesn’t always work as it should. Office Watch reader, David Peel, has made a better, more compatible Calendar Creator. We added some different versions […]
He’s done it again, David Peel has quickly made up a new version of his Excel Year Planner that starts the year from any month you choose. Great for academic years (start in August) or financial years (e.g. Aussie start in July). The year selector is top left of the main worksheet. Change the starting […]
Here’s how to find and add the US National Flag into Office documents, Word, Excel or PowerPoint then use some Office picture tools to enhance the image. The same help can be used for any other national flag, just look for a different source. Get the US Flag image There are many, many copies of […]
The Year Planner Excel workbook download is just the start. Here are many suggestions for changes to improve or customize the download. We have tips for changing the headings, overall look, change financial year, highlight public holidays, change the look of a day in the week, change weekend shading or day label. We’ll even show […]
The second Access memory leak has finally been patched by Microsoft, almost a year after a very similar problem was discovered. These bugs have been around since 2002 and the effects are still in some Access files. Both are faults in the way Access saves data to memory locations in ways that hackers could exploit. […]
There’s a limitation in Word’s Table Styles; no individual cell styles within a Word table We’ll explain the problem and several options to workaround it. Along the way it’s a chance to dig into some interesting parts of Word and Office and make them do things that might not have occurred to you. There’s a […]
It’s possible to apply individual cell formatting in Word consistently using a little VBA code. In effect it makes styles for cells in a way that Word itself won’t do. Reuse this code to apply the same formatting to many cells. Cell Format Special We’ve made two VBA functions for two different cell formatting settings; […]
Hidden Text Printing in a Word document is possible but is more complex than it should be. Here’s how to change the setting quickly from the ribbon or change the print setting just for one print job. By default, the hidden text will not be printed, but you can choose to print it if you […]
There are 2020 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. Just like Word calendar or Excel calendars, ignore the labels like ‘Succulents’, ‘Floral’ etc. Instead look for […]
How to lock your Excel worksheet from editing – the whole thing or some cells. Allow some people to edit a few cells, leaving the rest of the cells and formulas untouchable by others using the worksheet. Here’s a very simple example: Anyone opening the worksheet can enter a US dollar amount to see the […]
The only specific 2020 calendar template in Microsoft Word is an academic calendar from August 2019 to July 2020, here’s how to use it and make it better. In File | New search for ‘academic calendar’ there are a few options. We’re looking at ‘Academic year calendar’. A few notes before moving on. Despite the […]
Word has many 2020 calendars in the File | New templates supplied by Microsoft. There are tricks to getting the most from the templates and make them personal and special. Search for ‘ calendar’ in the File | New pane. This year there are no specific year calendars for 2020 with one exception, a 2020 […]
Excel has a Calendar Creator template which might work or might not. Why it doesn’t work is a mystery. The ‘Calendar Creator (any year’) template sounds great … a one-page year calendar. Find it from File | New then search for calendar creator. When the template is opened, it should display a calendar for the […]
Excel calendars get 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 make a specialist Excel calendar into something quite different that suits your need. […]
Nested IF statements can be hard to understand and manage but there are alternatives which can be easier to handle, fix and change. We’ll start with the relatively simple example we used for demonstrating IF and nested IF. =IF(C2>89,”HIGH DISTINCTION”,IF(C2>79,”DISTINCTION”,IF(C2>69,”CREDIT”,IF(C2>49,”PASS”,”FAIL”)))) This example has only five levels of nesting, we’ve seen nested IF’s with many, many […]
It’s not too late to send a colourful and personal Merry Christmas, Happy Holidays or Happy New Year email. Here’s a quick design you can do in Outlook from the resources and settings you already have. As usual with Office-Watch.com, we’ll explain our choices so you can adapt them to your preferences. Keep in mind […]
Are there any advantages to getting an Solid State Drive (SSD) when running Microsoft Office? We have some advice from actual use. Solid State Drives are faster and power saving drives that are now less expensive and more available, but are they worth the trouble for Office users? YES — absolutely and definitely YES. We’ve […]
Open and close your presentation with a look from a galaxy far, far away or at least a Star Wars movie near you. Here’s the fonts, colors, background and other details to emulate the opening and closing credits. See Star Wars in Office Star Wars in the Office dictionary A long time ago in a galaxy […]
If you want to change the background color on an email, Outlook’s option to do that has changed name and location. At least Windows users can change background color, Outlook for Mac users lost this option at few years ago! A colored background can be nice in an email but care is necessary when replying […]
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter and Victor have again been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost quite beyond the practical help […]
