Add-ins - TheSpreadsheetGuru

Parts Of A Ribbon Button’s Tool Tip Programatically, there are two parts to a button’s tool tip box that appears...

I’ve had quite a few IT administrators request that I provide an MSI Installer file (often referred to as a...

Versions Of Microsoft Excel For XLOOKUP Function The following versions of Microsoft Excel include the XLOOKUP function: Excel 2021 or...

Steps To Add The Developer Tab In Excel For PCAdd The Developer Tab in Microsoft WordAdd The Developer Tab in...

What Is The Oracle Smart View Add-in? The Smart View Excel Add-in is a free Oracle tool that allows you...

What This VBA Code Does There may be times when you need to refresh the user interface (UI) of your...

I’ve run into this issue numerous times and I just figured out how to prevent the dreaded error message from...

Why Is This Happening? This year (July 2016) Microsoft decided to heighten its security features and block files that are...

What This VBA Code Does There may be times when you want to incorporate code from your add-ins into other...

What Are Add-ins? Add-ins for Excel are similar to the apps you can download and purchase for your smartphone. They...

Why Center Across? I am a huge advocate for using the Excel functionality of Center Across Selection instead of Merge...

One of the most prosperous skills I have picked up over the years as a financial analyst has been the...

Installing Your Excel Add-in1. Ensure Your Excel Add-in File Is Unblocked2. Save Your Excel Add-in File To Your Computer3. Enable...

PowerPoint Is Not Excel! I have spent probably 90% of my Microsoft Office usage inside Excel. Because of this, I...

What's a QAT? QAT is short for Quick Access Toolbar and this bar is typically setup to store frequently used Excel functionalities;...

Where Did My Code Go? That was the question I was asking myself when I first began to create PowerPoint...