Microsoft 365 – the subscription / annual fee plan for Microsoft Office on Windows, Mac, iPhone, iPad and Android.
Includes Word 365, Excel 365, PowerPoint 365, Outlook 365 and many other ‘365’ programs, apps and services.
Vertical Bar | symbol in Word, Excel, PowerPoint and Outlook
How to insert the Vertical Bar | into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Vertical Bar | symbol (technically a glyph) has many uses in computing, physics, maths and typography. In some programming languages | has a special meaning, for example in PowerShell | is called […]
Excel’s Round () and nine other rounding functions
Excel’s Round () function rounds a number to a specified number of digits. It might seem like the choice for your rounding needs but there are NINE more rounding functions that might be better and even that’s not enough to cover all rounding needs. Round () basics Round() is pretty simple, give it a value […]
More accurate Excel rounding to the international specification
Here’s how to round numbers more accurately than Excel’s in-built Round() and other functions. This method uses the internationally recognized standard for rounding (yes, there is one), we’ll show the long formula, how it works plus the Let() and Lambda() versions that can make your worksheet easier to deal with. Rounding ‘Ties to Even’ The […]
Why Excel’s Round() function is wrong
Excel’s Round() function is not totally accurate. There’s a lot more to rounding numbers than we were taught in school and how Microsoft’s Round() function works. What we learned in school and Round() is OK. But if you’re dealing with larger groups of numbers, narrow rounding ranges or should be very, very fair (e.g test […]
How to color the Column dividing line in Word
Microsoft Word’s ‘Line Between’ option for multiple columns can replaced and formatted to a different color or other types of line. Word’s standard ‘line between’ column setting has no formatting. All you can do is choose ‘Line Between’ and no more. There’s no known way to change the look of the vertical line between columns. […]
6 ways to add vertical lines in Word
There are at least six ways to add a vertical line in Microsoft Word. Vertical lines can help accentuate a piece of text in Word, but adding them is not as obvious as adding a horizontal line. These are most common options available. With all the features in Word there are other more complicated choices. […]
Set your own Text Box default settings in Office
You’re not stuck with the Microsoft Office automatic settings when inserting a new text box. Change the Text Box defaults to whatever you like for faster text box formatting in Office; Word, Excel, PowerPoint or Outlook. There are TWO ways to add a Text Box in Word and Outlook – each with their own ways […]
Make a better PDF from Microsoft Word using the hidden options
Microsoft Word has vital but hidden options for making a better PDF file from your document. PDF’s made from Word can be smaller than usual for faster sending or to get under size limits that apply to email or messaging services. There are choices for including better navigation (like the navigation pane in Word), markup/comments, […]
Inside the controversial Gender Specific checks in Word
A close and in-depth look at what Microsoft Word does and doesn’t flag with the sometimes controversial Gender Specific Language setting in the ‘Grammar & Refinements’ section. Microsoft doesn’t reveal much (or anything) about the Inclusiveness options in Word so we’ve decided to look closely at what they do. We need your help, see below. […]
Has Microsoft Word gone ‘woke’ and politically correct?
Lots of press stories about how Microsoft Word has gone ‘woke’ enforcing ‘politically correct’ words and phrases. Let’s look at what all the fuss is about, why you’ve not seen it in Word, how these ‘inclusive’ grammar checks are old news and easily ignored in several ways. In early 2020 there were news stories and […]
EVEN() and ODD() are yet more ways to round numbers in Excel
Excel has two functions that round numbers to either the next Even or Odd numbers – these functions are called … wait for it … Even() and Odd()! Both Odd() and Even() round positive numbers UP to the next odd/even number. Negative numbers are always rounded DOWN to the next lowest odd/even negative number. In […]
All about Ceiling() and Floor() Excel rounding options
Excel’s Ceiling() and Floor() function rounds a number up or down to the nearest specified multiple. The most common use is to match prices to denominations of coins or notes. Ceiling() is similar to MRound() except that MRound() rounds to the nearest multiple, Ceiling() always rounds UP. The reverse is Floor() which always rounds down. […]
Outlook Function Keys – complete list
Here’s a complete list of the Outlook Function Key features from fast access to Help, jumping around your inbox, doc panes, spelling, grammar and key shortcuts. Let’s look in detail the functionality of the F-keys labelled F1 through F12 on your keyboard. F1 – Help, hide ribbon F2 – Calendar F3 – Search, change case […]
See Word Styles alongside document paragraphs
Each paragraph style can be seen alongside the text in Microsoft Word but it’s very much an afterthought that could be much improved. The Style Area Pane appears only in Draft and Outline view on the left-side. Turn on Style Area Pane Dig into Word for the Style Area Pane. File | Options | Advanced […]
How to put Office Watch ebooks on an iPad or iPhone
Reading an Office Watch ebook on a portable device like an iPad or iPhone is quite easy. We’ll take you through the steps, which work for any PDF or other files, not just our ebooks. Many thousands of our Office Watch ebook readers use their iPad/tablet to read our books. The other day we received […]
Zero Thirds (Baseball) ↉ emoji in Word, Excel, PowerPoint and Outlook
How to insert the Zero Thirds (Baseball) ↉ fraction or symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Zero Thirds ↉ symbol (officially called ‘Vulgar Fraction Zero Thirds’) is a rarely used Baseball scoring symbol. The best explanation we could find was a Japanese Wikipedia page, here’s […]
