Inside the new look and defaults in Office 365
The look of Microsoft Office 365 for Windows is changing with new features beyond the simple design changes. Here’s what you can do with the new look, mostly changes to the Quick Access Toolbar and important changes to Office default settings. Note: what you see in Office 365 might not match our description. The Office […]
Approximately Equal or image of ≒ in Word and Office
How to insert the Approx Equal or the image of symbol ≒ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Approximately Equal To or the Image Of ≒ symbol is commonly used Japan, Korea and Taiwan to indicate two values are approximately equal, but not exactly equal. How Approximately Equal ≒ looks in different fonts. Here are some examples […]
Fast typing the same thing across many Excel cells
Sometimes when you are filling out the cells in an Excel worksheet, the same thing must be written repeatedly. There’s a fast way to do it using a surprising Excel shortcut. Luckily, there’s an easier shortcut around it. Previously we have spoken about Auto Fill hidden tricks in Excel, but you might not be aware of this simple trick. Firstly, […]
Nine hidden tricks for Auto Fill in Excel
Typing or formatting cells of repetitive data can be very boring, but Excel has an Auto Fill feature to make it easier by automatically filling in data for you. We thought we knew Auto Fill, but just found nine surprising and useful tricks. Auto Fill goes beyond simple incrementing numbers or dates which is what […]
Big numbers are rounded without warning in Excel
It’s not easy working with Excel and really large numbers. In fact, Excel doesn’t do a great job with larger numbers. Up to 15-digit integers, Excel is fine, but once you go over that, it quietly rounds numbers. Basically, data above 15 digits stop being accurate. As a result, Microsoft hides that inaccuracy by displaying the number in scientific notation […]
New Prime Number is too big for Excel
In 2013 they discovered a new Prime number but not for Excel. The GIMPS project has discovered a new prime number – that’s a number that can only be divided by itself and one. The new arrival is a bouncing bonny number 257,885,161-1 which is 17 million digits long. Prime numbers aren’t just mathematical curiosities, they […]
Reversed Tilde ∽ symbol in Word, Excel, PowerPoint and Outlook
Type the Reversed Tilde ∽ into Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Reversed Tilde ∽ symbol is the vertically flipped version of the usual tilde ~ symbol. A tilde starts with the downward curve while the reversed tilde has a rising curve at left. How Reversed […]
White Chess Queen ♕ symbol in Word, PowerPoint and Office
How to insert the White Chess Queen ♕ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. White Chess Queen ♕ symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or just a generic ‘Crown’ graphic. How White Chess […]
Beyond simple Undo in Microsoft Office
There’s a lot more to Undo than just reversing the last thing you did in Microsoft Office The UNDO command is surely one of the greatest time-saving inventions of the digital age. According to Jensen Harris, the head honcho of the Microsoft Office User Experience Team back in 2008 , undo is the fourth-most used […]
Best Laundry label text font for Microsoft Office
Which font to use if emulating a true laundry care or clothing text label in Word, PowerPoint or other Office program? We’ve already talked about how to put standard laundry care symbols in Word, Excel or PowerPoint but what about the text that usually goes with the icons? In our research we couldn’t find any […]
All about check in and check out in Microsoft Teams
Checking in and out of documents for Teams isn’t well understood. Using it can end in tears with lost changes or a seemingly stranded document that’s not available to others. What is Check in / Out? In a multi-user environment where lots of people might want to edit a file at the same time, check […]
Watch Window finally in Excel for Mac
An essential Excel testing and debugging tool is finally in Excel 365 for Mac. The Watch Window makes fixing workbooks a lot easier. Watch Window is a separate pane which shows the current status of selected cells from across many workbooks or sheets. When you can’t figure out why Excel is misbehaving, the Watch Window […]
Good stuff now and coming changes to Office.com
There are some good and practical changes coming to the main web portal for Microsoft Office users, Office.com plus some features already available you might not realize. These changes are either happening now or in the coming months. As usual, there’s a gradual rollout to Microsoft server farms across the globe. Here’s both an overview […]
Cartoon People and a lot more in Microsoft Office 365
Microsoft Office 365 has a very interesting addition to their stock graphics range called “Cartoon People” but is really a lot more than just people. Cartoon People has been added to stock Images, Icons, Cutout People, Stickers and Illustrations. Access it from Insert | Pictures | Stock Images or Insert | Icon then click on […]
How to find more Cartoon People in Office 365
Here’s a better look at more Cartoon People graphics in Microsoft Office 365. Check out the main categories, how to search Cartoon People and some useful search terms. This article looks at the people graphics available under the ‘Cartoon People’ section with many examples to give you a better idea of what’s possible. We have […]
Cartoons without People you can add with Office 365
It’s called Cartoon People in Office 365 but there are plenty of non-human graphics available to use either on their own or as part of a combined graphic. See also How to find more Cartoon People in Office 365 to see the human side of this feature for Word 365, Excel 365, PowerPoint 365 and […]
