To use VLOOKUP, the value you're looking for has to be in the first column of the lookup range. But what if your lookup table has Scores in column 3, and you need a description from column 2? Here's how you can do an Excel VLOOKUP to the left. Continue reading "Excel VLOOKUP to the Left"
In Excel 2013 and later versions, each file opens in a separate window. Unlike earlier single-window versions, there is no Exit button or command, to close all the files, without clicking each window individually.
Happy Halloween! Some people think that Excel is a bit scary, so I made an interactive workbook that lets you show the friendly side of Excel. Download my sample workbook, to see all the Excel Halloween tricks, and share it with your spreadsheet-fearing friends too! Continue reading "Excel Halloween Tricks"
Happy Spreadsheet Day 2018! It seems like we just took down the decorations from last year's party, and here it is again, our favourite celebration of the year.
To make data entry easier, you can create drop down lists in a worksheet, using Excel's data validation. Usually, those lists are trouble free, but sometimes the arrows disappear, for no apparent reason. See some of the reasons for that behaviour, and how to fix or avoid the problems.
Instead of struggling to build your own custom tab for the Excel Ribbon, download my sample file. It has a pre-built tab, and you can put your Excel macros on this custom tab, by making simple changes on a worksheet.
Have you ever been working with text in Excel, and wondered how that text would look in a different colour? Instead of black, maybe it would be better in red, or green, or blue. Did you know that Excel has a built-in command called Cycle Font Color?
Were you using Excel, way back in 1993, when VBA was introduced in Excel 5.0? Now, there are new ways to automate Excel, and a great opportunity to learn more about them, at the Develop Excel conference in London, on October 18th.
When you double-click a pivot table value cell, Excel adds a new sheet to your workbook, with the details for that summary value. To make it easy to find those sheets, and delete them later, use the latest version of my macros to rename Pivot Table DrillDown sheets.