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
There’s a new King in Britain (and other countries) which means there’s a new Royal Logo Cypher or Monogram. Here’s how to get the Cypher for Microsoft Office documents or slides. The Royal insignia is usually made from two parts, the Tudor Crown or Scottish Crown above the Royal Cypher.
No cloud service is perfect, no matter what the company says. Here’s what you must do to protect yourself from breakdown of your OneDrive, SharePoint, Teams or Microsoft 365 cloud storage. Microsoft pushes use of OneDrive to store all your documents and images. That suits Microsoft’s strategy but isn’t necessarily
Insert the Exploding Head 🤯 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Exploding Head 🤯 emoji looks Windows only has Exploding Head 🤯 in the Segoe UI Emoji font, either color or black. To me the black version looks
Excel has three different ways to see a partial formula result to help you locate and fix a problem or understand how a formula works. Two methods have been in Excel for some time and there’s a new tooltip feature. Evaluate Formula The full Evaluate Formula has been around since
Excel has a simple way to understand or fix a complex formula. Evaluate Formula lets you calculate parts of a formula and see interim results that make up the final value that appears in the cell. It’s on the Formulas tab under Formula Auditing. Evaluate Formula isn’t new, just little
Here’s the ‘old-fashioned’ way to make a list of worksheet tab names. It’s old because the formula uses ” Get.Workbook() ” which is an Excel 4 macro function that’s now blocked in modern Excel for security reasons. See Excel 4 macros are now blocked and about time tooWe’re including this
The famous Art Deco font used in US National Park posters is available free for Word, Excel or PowerPoint. National Parks Traveller has an interesting article on the history of US National Parks posters. Original posters now sell for four figure prices, not bad for things that were once thrown
Type Loudly Crying Face 😭 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. In mid-2011 Loudly Crying Face 😭 was the most popular emoji in the world. Alternative names are; Crying, Sobbing, Sad Tears, Bawling, uncontrolled laughter or even overwhelming joy. How
Insert the Down arrow ↓ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Down arrow ↓ symbol is used for all sorts of things including a bullet symbol. How Down arrow ↓ looks in different fonts. Here’s some examples of how Down
Insert the Rolling on the Floor laughing 🤣 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Rolling on the Floor laughing 🤣 emoji is commonly used, sometimes using the acronym ‘ROFL’ or ‘Hysterical Laughter’ Not to be confused with Face with rolling
Type the Beta – lower case β into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Beta – lower case β symbol is the 2nd letter of the Greek Alphabet. Within finance, it is used as a measure of investment portfolio risk. Within statistics,
If you have Office VBA you’re trying to understand, ChatGPT can help. ChatGPT can take some VBA code and explain it in plain human language. This is very useful for digging into poorly documented or undocumented code. Also for beginners trying to get a handle on how Office VBA works.
