Office gets Irish language or Faigheann MS Office an Ghaeilge
Irish Gaelic, Gaeilge or just Irish is available in Microsoft Word Translator and other translate services from Microsoft. Here’s how to download the Irish spell check and other proofing tools. Irish Gaelic is the first official language of the Republic. English is more commonly used and the second official language. Gaeilge is also recognised in […]
Add the Irish Flag into Word, Excel or PowerPoint
Put the Irish flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Great for St Patrick’s Day too. The same help applies for any other national flag, just look for a different source. Get the Ireland Flag Image We’ve opted for the Wikipedia site because it has an SVG […]
Discover the Content Status flag in Word, Excel and PowerPoint
Tucked away in Microsoft Office is a little used tag ‘Content Status’ or just ‘Status’ that could help manage and find Word, Excel and PowerPoint documents in organizations. Unfortunately, Content Status is only used once in Office features. It’s supported in Windows Explorer if you know where to look. On the Mac it’s all but […]
New Paste Values keyboard shortcut for Excel
A new-ish keyboard shortcut in Excel 365 (Windows/Mac) is very handy for pasting values into a cell or matching the destination formatting. A common Excel task is pasting content into a cell from non-Excel sources (a web page, document, email etc). Until now (and in Excel 2021/2019 etc) is quite possible though a little clumsy, […]
Play fantasy college basketball on Excel
Some basketball fans at Microsoft have released an Excel workbook to play mens and womens ‘fantasy’ college basketball with friends and family. Excel randomly allocates the 64 teams to your players who can see how the tournament progresses through the shared workbook. Even if you’re not interested in ‘college hoops’, you can look around the […]
Excel’s five Pie Chart tricks
Excel has five different Pie Charts, here they all are, showing how to use each chart and tricks to make the charts look better. Microsoft has five Excel Pie Charts though one of them is really a donut/doughnut. Find them all at Insert | Charts; 2-D and 3-D Pie charts plus the Doughnut/Donut chart. Part […]
Excel Tables and Transpose – Solved!
There are several ways for an Excel table to be transposed (rows and columns) but none of the online suggestions work very well with tables. We’ve found a solution which transposes one table into a ‘swapped’ table i.e headers become column A and column A becomes the headers. Along the way we’ll explain a clever […]
Make list of Excel sheets/tabs – automatic and even better
Here’s an even better way to make an automatic list of tabs in an Excel workbook it works in Excel for Windows and Mac and bypasses some possible traps. Start with our article on Automatic worksheet/tabs list in Excel which explains how to add a list of Excel tabs/sheets with or without clickable links to […]
Epsilon lower ε or upper case Ε symbols in Office and more
Insert the Epsilon upper case Ε, and Epsilon lower case ε symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Epsilon (uppercase Ε / lowercase ε) is the fifth letter of the Greek alphabet. The uppercase isn’t commonly used outside of the Greek language, due to the similarity to […]
Upside-down ¿ or Spanish Question mark in Word
The inverted or Spanish question mark ¿ is available in Microsoft Word, regardless of language setting. There’s even an in-built shortcut. ¿ is most commonly used in Spanish for the start of a question sentence. This guide is mostly for people without a Spanish keyboard or who only occasionally need the inverted question mark. See […]
Excel Mobile Read Aloud in iPhone and iPad
Make Excel mobile for iPhone or iPad read aloud a workbook. Great for double-checking figures from a printed source. The options aren’t very good but we’ll explain what might be possible. Excel 365 does not have a Read Aloud or Speak feature similar to Word for iPhone/iPad let alone Word for Windows. The same goes […]
Capture full size still images from video
Grab high-res still pictures from movies and videos to insert into Office documents or emails. We’ll show you how to capture or grab a proper, full size, high-resolution still image from a high quality video file then paste that picture into an Office document or Outlook email. Why do this? Sometimes a video turns out […]
Add circled lower case letters in Word, Excel and more
Insert lower case letter with circles ⓐ to ⓩ in Microsoft Office, Word, Excel, Outlook etc. Officially they are called Circled Latin Small Letters. Circled small letters in different fonts Only two common Office fonts have double circled digits Segoe UI Symbol and Calibri. Here’s how the symbols look in both fonts plus the Unicode Hex […]
Rainbow shape and Rainbow text in Office
The rainbow shape with multi-color effect is possible in text, shapes and images for any Microsoft Office documents including Word and PowerPoint. With a few changes you can make a rainbow for documents or slides. Rainbow Text Effect Insert | WordArt choosing whichever preset is closest to what you want. Select the text and go […]
Rainbow gradient or effect in Office, Word or PowerPoint
A rainbow in Office is a custom gradient effect available for Shapes including WordArt borders and many elements in Word, PowerPoint and other Office programs for Windows or Mac. We have the exact colors, positions and options to use for a great rainbow. All the Office preset gradients are single-color effects however it’s possible to […]
Make a transparent shape to mask a photo in Word, PowerPoint and more
Here’s how to mask a photo with any Microsoft Office shape or icon and do it with full control over what appears from the original image. We’ve already explained two simple ways to crop a photo to a shape or fill a shape with some options to move and resize each element. This method has […]
