Up Down Arrow ↕ symbol in Word, Excel, PowerPoint and Outlook
Type the Up Down Arrow ↕ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Up Down Arrow ↕ symbol is a vertical line with arrowheads on both ends, pointing up and down. How Up Down Arrow ↕ looks in different fonts. Here’s some examples of how Up Down Arrow ↕ looks in common Office fonts. Up Down Arrow ↕ codes These are the […]
Pantone 2022 color in your Word, Excel and PowerPoint
Pantone has announced their “Color of the Year” for 2022 and, as usual, we’ll explain how to use those exact colors in Word, Excel, PowerPoint and Outlook. For 2022, the new color will also be appearing in Microsoft products with a nice PowerPoint template with extra color palettes. The color of 2022 is … Very […]
Watch the Excel World Cup Final
The Financial Modelling World Cup or Excel esports Final was held a few days ago and you can watch the whole event. There were eight finalists from the USA, Canada, UK, India and Australia. If you can’t get enough of Excel champs at work, check out the earlier rounds. Last 128 & Last 64 (Session […]
Action Pen is editing by drawing in Microsoft Word
The Ink Editor button in Word 365 has gone, replaced with the ‘Action Pen’ on the Draw tab in Word 365. Some of the ink gestures have quietly changed since the original release of the Action Pen. The ‘Action Pen’ is now on right-side of the Draw tab | Drawing Tools. The Word 365 for […]
Who and how to get the new look Office for Windows
The gradual rollout of the new look Office for Windows (Microsoft 365 and Office 2021) continues. More users, but not all, can now try the revamped Office interface. We’ve had a lot of feedback from Office Watchers about the new look. Some approve, others definitely don’t. Some users are eager to try the new look […]
Nasty Excel XLL files are spreading like crazy
A lesser known Excel file, the .XLL, is being used to spread password stealing malware across the Internet by email and online contact forms. As reported by Bleeping Computer, emails and online forms are getting spammed with links to fake and malicious web sites which entice people to download the malware. The malware is contained […]
Approximately Equal To ≅ symbol in Word, Excel, PowerPoint and Outlook
Type the Approximately Equal To ≅ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Approximately Equal To ≅ symbol with a curvy line above the usual = symbol is commonly used within Mathematics to refer to approximate equality between two values, congruence or isomorphism. Not to […]
Excel Charts are better looking with pictures
Excel Charts can be even better looking by completely replacing those plain color blocks with pictures. We’ve already shown how to overlay an Excel Chart with an image now we’ll replace the block with a picture. Although commonly differentiated by differing colors like this, how about we look at different images instead? First, click on the plot area within the column, here we’ve selected the brown ‘Car Payment’. This will display […]
Workaround for styles with table cells in Word
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 […]
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 […]
