An update for Excel users on the upcoming new Imperial Era in Japan and how to type the Reiwa era name in Office documents The Japanese government has now announced the new Era name that will coincide with new Emperor. From 1 May 2019 we’ll be in the 令和or Reiwa
In Japan there are two amazing uses of Excel. Excel used for displaying train timetables and to make beautiful works of art. The Michelangelo of Excel Tatsuo Horiuchi has become the Michelangelo of Excel. On retirement he wanted to turn to art but didn’t want the expense of paint, brushes
What can you do when Outlook won’t connect to a new mailbox no matter what you try? Long time Office Watch reader, Phil, found himself with an especially stubborn Outlook which would not connect to his new mailbox. He’s changed Office 365 mail servers so had to reconnect Outlook to
Thanks to everyone who tried out Microsoft Forms by filling out our example survey. Here are the results. Our form was mainly an example of what’s possible in Microsoft Forms as part of Microsoft Forms – a quick look and sample We took the opportunity to get a better idea
Continuing our look at Excel tab/worksheet listing here’s a fully automated alternative with more control and filtering. See Make Excel tabs list in a worksheet Automatic worksheet/tabs list in Excel Fit more tabs across an Excel workbook There are many VBA code samples on the Internet, we’ve taken one we like
Does Excel have enough significant digits for Pi in the inbuilt Pi() function? Modern computing can calculate Pi to 3.14 trillion digits which is a good trick but even extreme situations only needs Pi to 15 significant digits. What’s extreme? How about interplanetary travel? JPL/NASA calculate the paths of probes
Make your own clickable list of workbook tabs in an Excel worksheet to workaround the small number of tabs that can fit in a single line. See Fit more tabs across an Excel workbook for some suggestions to squeezing more across the single line available. Those suggestions work to make
A long-standing and unpatched problem in Office provides a stealthy doorway to other security problems in Office with Equation Editor already being targeted. Mimecast discovered an undocumented behavior in OLE (Object Linking and Embedding) which is a doorway into security bugs in Office. It isn’t a security problem on its
Word for Windows has three options for saving a document to a web page, Web Page, Single Web Page or Web Page, Filtered. Here’s a look at all three and how to choose the best option for you. What you choose depends on how much similarity you need between the
The full match schedule for the 2019 Rugby World Cup can appear in Outlook calendar. Internet calendars can be added to your regular appointments or placed in a separate Outlook calendar that can be viewed side-by-side or overlaid on your regular calendar. 2019 Rugby World Cup calendar First, find an
Many new emoji are now in the official Unicode list but we’ll have to wait for them to appear in Word or Outlook emails. After the Unicode Consortium ratifies additions to the vast character list, it takes some time for Microsoft, Apple and others to add the emoji to their
Here’s the list of the February 2019 bug fixes or ‘non-security’ updates for Office 2016, Office 2013 and Office 2010. They don’t apply to Office 365 or Office 2019 which use the ‘Click to Run’ install and update service. Many of the updates are preparing for the upcoming Japanese Era
Here’s a quick and easy way to totally erase file, folders or free disk space so there’s no trace of the original data. Also erasing an entire drive before handing over or selling. As you may know, deleting a file doesn’t really remove it from your computer. Even after deleting
It’s the Chinese Year of the Pig and there are some symbols in Word, Excel and PowerPoint to mark the occasion in Office for Windows or Mac. The Unicode standard has three Pig related emoji, Pig, Pig Face and Pig Nose. Once you know the names or hex value, they
Web based email is very common these days but it’s not the best way to handle your email. At worse, webmail can leave you stranded and out-of-touch. A lot of people now use webmail as the only way to access email on their computer, not realising, until it’s too late,
How can you tell if you’re reading email in a web browser or using email software like Outlook for Windows or Mac? This might seem obvious to some but many people use ’email’ without understanding the important difference between webmail and email programs. There are two ways to read and
If the Translation options in Microsoft Office don’t do it for you, try the Google Translate full document translation option instead. For a long time, Google has a word and text translation between languages. The app is a godsend to travelers around the world, and the locals dealing with them!
Bitlocker is an important part of Microsoft Windows so why isn’t it in the Microsoft Word dictionary? Bitlocker is the drive encryption feature in modern Windows. It secures your drive if stolen or lost because the entire drive is unreadable without the password. Our books for Windows 10 and Windows
A Canadian man has been caught trying to hide assets from bankruptcy because the wrong fonts were used in documents. Gerald McGoey, the former CEO of Look Communications filed for bankruptcy over a year ago. He presented trust documents that appeared to shield two properties from his creditors. But there
An astonishingly simple security breach in Microsoft Office has finally been patched two months after Microsoft confirmed the problem. The unanswered question, why did it take so long to discover it? Mimecast.com discovered the ActiveX memory leak back in November 2018 and told Microsoft. Two months later Microsoft fixed the
Excel can display dates in many different formats including Japanese Imperial Era. You don’t need the Japanese version of Excel. Office-Watch.com shows how to display an Era date and how Excel knows which Era to use. You don’t ‘convert’ a date from western format to Japanese Era. Like any date
The British Army has new recruitment posters for Millennials or ‘Snow Flakes’. Make your own versions in Microsoft Office with either Word or PowerPoint. The campaign targets “snowflakes”, “millennials” and “selfie addicts” with a call-back to the famous Lord Kitchener “Your Country needs YOU” poster. Here’s our re-creation in Microsoft
Office has picture adjustment tricks to convert a picture into something gray and transparent. Remove Background We found a black & white photo (rights free) online and used the Office Picture Tools | Format | Remove Background to make the surrounding transparent and show through the page background color. Color
An Arizona man practiced as a dental anaesthesiologist using a Microsoft Word template as part of his application. It wasn’t hard for Office-Watch.com to find the template he used and you can too! ABC15 (Arizona’s News Leader) has the story of Dr. Pankaj Goyal who applied for a General Anaesthesia
