How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata Your email has been sent When a Microsoft Excel workbook contains a lot of sheets, the sheet tab you need is ...

How to add color to a drop-down list in Excel Your email has been sent Color can be a powerful element in an Excel drop-down list, and it’s easier to add than you might think. Perhaps you want to use ...

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

If you enjoy the massive time savings from these methods, don't stop there—there are many other ways to speed up your Excel workflow, like learning the keyboard shortcuts for executing complex tasks ...