More details on the image insert or linked options in Office, Word documents and Outlook emails. We’ve already talked about the three options available for documents; Insert, ‘Link to File’ and ‘Insert and Link’. Insert adds a copy of the image into the document Link displays the current external picture
There are three different ways to add an image into a Word document or Outlook email. Insert is the most common but there’s also Link or Insert and Link ” When I make a web page I can link to any image on the Internet. In Word, it’s different. You
Here’s how to make Outlook Contact Groups work with both CC and BCC’s as well. Outlook Contact Groups are a way to combine a list of contacts under a single name. They are often used in business but are also useful for individuals or families. For example groups like: ‘Regional
There are at least eight ways to share an entire calendar or individual appointment in Outlook software. Sharing can be ‘live’ and connected. Any changes or updates to the event or calendar are automatically sent to everyone sharing. Or it can be a ‘one-off’ item. A special attachment which is
How to type the Cent symbol ¢ into Microsoft Word, Excel, PowerPoint or Outlook plus any Windows program. Cent ¢ shortcut Word and Outlook The Cent ¢ symbol has an inbuilt shortcut in Word and Outlook: Ctrl + /, C Hold down the Ctrl key while pressing / then type
Adding comments to Microsoft Word documents isn’t just for groups, use them yourself for your own reminders and side-comments while you’re working on a doc. Word has a feature to let you add ‘side’ comments to documents – comments that don’t show up in the final document, don’t effect the
Baskerville has been decreed the most persuasive font after an experiment by Errol Morris and the New York Times. Happily, a very similar font is available to all Microsoft Office for Windows users. In an interview in Fast Company, Errol Morris talks about the experiment where people were asked to
What causes blank spaces in the Word navigation pane and how to fix them. The Navigation Pane in Word shows the Headings in a document but sometimes has the unexpected. Blank lines or text not in a heading. But sometimes blank spaces appear, like between London and Paris above. Why
Any Excel worksheet that has lists with headings on the top row can quickly get pull-down menus to filter or sort the data. For a regular Excel worksheet, go to the Data tab and click the Filter button. This adds extra pull-down menus to each of the headings. For an
You can translate a Pantone PMS code or name into something Microsoft Office; Word, Excel or PowerPoint understands? Sometimes you’re given a specific color using the Pantone color scheme. Most commonly this happens for a corporate logo. The Ford car company specifies ‘PMS 294C’ for their blue logo. McDonald’s uses
The serious Windows and Office security bug is now used to target organizations in Europe and USA. Despite plenty of warnings, Microsoft still doesn’t have a fix, just ‘mitigations’. Last week Office-Watch.com told you about “Follina, or CVE-2022–30190” a relatively simple hack that exploits a security bug in Microsoft’s own Microsoft
Here’s a quick look at some of the modest Excel tricks we used to make the Schengen Visa Calculation worksheet. Table Making the itinerary list an Excel Table lets us make use of some features. Formatting It’s a lot easier to format as a table with banded rows. We’ve turned
A large security risk has appeared in Microsoft Word, a zero-day security problem which can infect even fully updated Word. Microsoft has taken at least 14 months and still hasn’t fixed the security hole. We’ll explain the problem and what you can do. It’s a relatively simple hack which takes
Sometimes you need to convert a date from the Excel cell saved format to a particular format. There are at least five ways to do that. DateValue(), Date() or converting Unix dates to Excel. Simply typing dates into a cell also works but there are traps for the unwary. Excel’s
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve
It’s easy to share appointment details with other people, whether they use Outlook or not. No need to type in appointments when you can send and receive the details right in your calendar. We’ll explain how it works for both sender and receiver (organizer and invitees) on various platforms, including
An IF statement might sound like a complicated thing that programmers do, but it’s actually fairly easy to do in Excel. An IF statement basically puts something into a cell depending on certain conditions – if A is true, put X in this cell. You can even use what’s called a nested
Type the fun Otter 🦦 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Otter 🦦 emoji represents a light-brown otter (a member of the weasel family) on its back with its paws held together. But the emoji can just be used
What are the real words for really big numbers, waaay over a trillion? Does Microsoft Word’s dictionary recognize them? (Answer: most but not all and there’s even a spelling mistake in Word!). How many is a billion anyway? We’ve looked at the informal words for vague large numbers such as
Does Microsoft Word recognize the nicknames for ‘big numbers’ like zillion, jillion etc? There are many informal words to describe a non-specific but really large numbers. Word’s dictionary (at least in English) recognizes them as correct spellings. If you want to be more specific see Real words for really big
Like Word, PowerPoint and Excel also have options to add borders to pictures to add that extra oomph to your work. Users can choose between fairly simple borders or add some further complex, fancy styles to their images. If all this seems very familiar, it’s because the same picture tools
Type the Grinning Cat with Smiling Eyes 😸 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Grinning Cat with Smiling Eyes 😸 emoji is a variant of the grinning face emoji or the cat face emoji, which is yellow on most
There are a couple of email preview options in Outlook. These include the Message Preview and using the Reading Pane (once called the Preview Pane). We’ll explain them in detail including how to turn these features on and off plus viewing attachments in the Reading Pane. Message Preview Message Preview
