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 […]
Microsoft blocks Excel XLL add-ins – at last!
XLL addins for Excel coming from the Internet will be blocked by default as a security measure. Here’s how it works and how to enable XLL files and bypass the new block. You can implement a similar block now in other Excel versions without waiting for Microsoft’s late change. Excel can use .XLL files to […]
Check out the new look Microsoft Office on an iPhone
There are new look menus and toolbars coming to the iPhone Microsoft Office apps, Word, Excel, PowerPoint and the all-in-one Microsoft 365 app. We’re not sure when you’ll see these changes because they are three months late! Microsoft started talking about this ‘fast and fluent’ change in November 2022. Three months later and there’s still […]
Make and customize your own tab on Office Ribbon
Have all your favorite Office features and buttons in one place. Commonly used buttons or options that aren’t on the regular ribbon. The Office ribbon lets you make a personal tab filled with your choices. We will show you how easy it is to make in Word below, but this can also be done the […]
Type double circled digits in Word, Excel and more
Insert digits with double circles from ⓵ to ⓽ in Microsoft Office, Word, Excel, Outlook etc. Use them as an alternative way to number a list like this … Double Circled digits 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 […]
Beamed ♬ Musical Notes ♫ in Word, PowerPoint and More
Type beamed ♫ or joined ♬ musical notes into Word documents, Excel worksheets, PowerPoint slides or emails. It’s possible to type musical notes and other notation in Word documents. Full musical scoring isn’t practical (there’s other software). Unicode only has two ‘beamed’ or joined musical notes, the Eighth or Quaver and the Sixteenth of Semi-quaver. Beamed musical notes different in each font […]
Musical 𝅘𝅥𝅮 notes 𝅘𝅥𝅰 in Word, Excel and more
Type musical notes from breve 𝅜 (double whole note) to the semihemidemisemiquaver 𝅘𝅥𝅲 (128th note) in Microsoft Office, Word, Excel, Outlook etc. It’s possible to type musical notes and other notation in Word documents. Full musical scoring isn’t practical (there’s other software). How musical notes look in different fonts. Most fonts don’t include musical notes. The only common Office font that […]
Body Mass Index BMI calcs can do more in Excel
After explaining Body Mass Index calcs in Excel, there are other options. Finding your ideal weight from height and desired BMI. Also a BMI alternative and how it can be used in Excel. Find your ideal weight based on BMI Most BMI calculators show your current ratio but what about calculating your ideal weight from […]
