Here’s how to easily install VBA code or macro in Microsoft Office. Adding some code you’ve seen on a web site or been given is simple once you know the little tricks. Often people are given some Office VBA code to use with Word, Excel, PowerPoint or Outlook but without
Changing the measurement units in PowerPoint is possible but unnecessarily complicated, we’ll show you how in both Windows and Mac. The Measurement Units show up in the ruler and also in places like the size and exact positioning of images. Measurement option – US or Metric Ideally you want to
New shortcuts are coming to Microsoft Office 365 for Windows which will help navigate larger pull-down menus with keystrokes. Plus the screen-reader labels are being improved. In short: the Tab key moves between sections/blocks of a pull-down menu.That’s it … so simple and perhaps surprising that it’s not there already.
Add your personal signature to a PDF with the Microsoft 365 app for Apple or Android devices. You can sign a PDF and save your signature for quicker reuse with other documents. This is a useful trick if someone sends you a document to be signed. Instead of printing, signing
The European Space Agency has released the first full Earth image from its new weather satellite and it’s a fantastic, high-resolution view of Europe, Africa and the Middle East. Great for a desktop, screen saver or Powerpoint slide. Taken by the Meteosat Third Generation Imager-1 (MTG-I1), the image is available
Microsoft is now looking at the contents of password protected ZIP files stored on OneDrive, Sharepoint and other cloud services. Maybe with honorable intentions but there are serious privacy concerns that haven’t been acknowledged. For a long time, Microsoft’s antivirus and safety systems have opened up compressed ZIP files to
There’s another security bug in Windows, embarrassing for Microsoft because it was caused by their own March fix for another security bug in Outlook! That means anyone with Outlook for Windows or Windows should ensure they have the latest updates. This is another ‘zero-click’ Outlook bug that can infect your
At long last, more features are in the Quick Note box in OneNote for Windows. New toolbars make text formatting, ink and screen clipping directly available. Once you bring up a Quick Note you’ll notice a toolbar at the top: It doesn’t look like much, in my view this toolbar
There are different check mark, tick or cross symbols available in Word, PowerPoint or other Office apps. Here’s an easy searchable list of all Unicode symbols plus in modern Office ✅✔️☑️ is called a ‘check mark‘ or ‘check‘ in some places and ‘tick‘ in others. Same symbol, different English names.
There are at least NINE simple statistics formulas and functions in Excel that can summarize a list of numbers into something easy to understand. Often Excel has lists of numbers or money that makes little sense until you add a summary like this: We have a table called CountbyState and
Search for text and a lot more within a document using the Find side-pane feature in Microsoft Word. There are secrets making it more powerful than first appears. You might think it’s as simple as typing in a word and Office will find it but, as usual, there’s a lot
There are different arrow or hand pointing symbols available in Word, PowerPoint or other Office apps. Left, Right, Up, Down, North, South, East, West. Here’s an easy searchable list of all Unicode pointing symbols plus the arrow and point icons in modern Office See also Check ☑︎, tick ✔️ and
CoPilot, Microsoft’s AI project, inches towards reality with news of a very limited preview plus hints that Dall-E like image creation will be possible from inside PowerPoint. OneNote, Outlook and Whiteboard will also get an AI makeover. Microsoft continues to make announcements about their AI product, CoPilot, as if it’s
In early January 2023, Microsoft 365 for Windows stopped supporting Windows 8 or 8.1. Here’s the details of what you’ll have to do and a possible workaround. Microsoft 365 for Windows is supported on Windows 11, Windows 10 and, until 2023, Windows 8.1/8. It’s been a little surprising that the
A nice little tool that will make sense of any email header you receive in Outlook. An email header tells you a lot about the sender and the route the message took to reach you. Emails don’t go directly from your computer to the receiver, they pass through at least
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 Opening Credits
All 20 (yes, twenty!) emblems for the Coronation of King Charles III, the exact colours required and how to use them in Microsoft Office like Word documents and PowerPoint slides. Also how to get an SVG/icon version of the emblem, ideal for modern Office apps and show just the parts
Add the British National flag “Union Jack” into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the British Flag Image There are many, many copies of
Has your invitation to the Coronation of King Charles and Queen Camilla got lost in the mail? Never fear, you can make your own ‘replacement’ <g>. Or more likely use the ornate graphics for some other purpose, not always so serious. Here’s an ‘invitation’ made in PowerPoint with a name
Microsoft Designer is now available to everyone with no wait list. You can make graphics and images using Microsoft’s AI system at no cost … for now. The future pricing of Designer has also been revealed. Until now, anyone could use Designer but there was a wait list for access.
How to type the Per Thousand ‰ (or it’s official name ‘Per Mille‘) sign into Microsoft Word, Excel or PowerPoint. Per Thousand / Per Mille ‰ means ‘parts per thousand’ and can be used for values below 1%. It’s not regularly used in English. How Per Thousand ‰ looks in
3D models have a secret. They let you choose the exact look you want, turn it into a 2D ‘normal’ image that you can do a lot more with. Here’s a 3D model from the Smithsonian collection, a full length but frankly plain view of a famous statue. With a
Reducing the line spacing or vertical gap between lines in Word paragraphs can be done in six different ways depending on your needs. Adjusting line spacing to put lines very close isn’t usually necessary for regular text. It becomes useful when trying some design tricks for headings, for example the
Font vs typeface, ascender, desender, X-height, finial … there’s a nice one-page guide to all the Typography terminology. Become a typography nerd in under 10 minutes by Andrew Coyle Has a good visual summary of all the major words used talking about type – the broad categories of fonts (Serif,