Category: Range Names

Do you find that some dialogs like the Name Manager and the Data Validation dialog mess you around when you edit or enter formulas?  I call this the Excel Dialog Box Muddle!  For years and years now these two dialogs …

Excel Dialog Box Muddle Read More »

Tagged with: ,

Up until quite recent versions of Excel (I am guessing a little here because I only have Office 365 so always have the latest and forget when I discovered this) if you wanted a dynamic list for your Validation Dropdowns, …

Validation Dropdown lists based on Table Columns ranges Read More »

Tagged with: , , ,