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
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
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’,
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
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
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
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,
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
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
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?
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
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.
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
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
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
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
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
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
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.
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
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
BMI or Body Mass Index is a ‘rule of thumb’ calculating body fat based on height and weight. It’s easy to calculate in Excel whether you use metric or feet/pounds. BMI can be a polite way of saying how overweight a person is! A BMI over 30 is considered obese and need
Make an automatic list of tabs in an Excel workbook a better and more flexible way with options to create clickable links and sort the sheet list. Unlike older methods, it works in Excel for Windows and Mac. We’ve already talked about fitting more tabs on the screen or making
There’s more possible with the humble ! exclamation mark / point in Microsoft Word or Office. At least five different ! available and that’s before changing color, size and other text effect options. We’ll show you ways to insert FIVE different exclamation marks into Office, as characters, icons, symbols and several
