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 […]
Easily Calculate Body Mass Index in Excel
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 of work to bring down […]
Automatic worksheet/tabs list in Excel
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 a manual list of tabs/worksheets. […]
Explore five (yes FIVE) different Exclamation Mark ! in Word and Office
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 emoji with infinite variations possible […]
Add the King Charles III monogram to Microsoft Office docs
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. There’s a Royal Cypher below […]
Beware a Microsoft Office 365 – OneDrive outage, what you must to do protect yourself
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 a good thing for customers. […]
Exploding Head 🤯 emoji in Word, Excel, PowerPoint and Outlook
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 more like a bowl than […]
Three ways to understand part of an Excel formula
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 at least Excel 2007. It […]
Understand or fix an Excel sheet with Evaluate Formula
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 mentioned despite its usefulness. We […]
Automatic worksheet/tabs list in Excel – the old way
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 older method for the sake […]
