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.
With Excel comments, you can put a quick note in a cell, to explain a cell's value. A new type of comment is coming to Excel soon, and here is a warning, before you make the switch.
Someone asked how they could show the items in a worksheet Combobox list, one after the other. It was an interesting challenge, so here is my Activex Combobox item select macro.
If you add comments to worksheet, eventually those comments might wander away from their original locations. Sometimes the comments change size too, and you need to adjust them. Instead of making changes manually, move or resize Excel comments with macros, to save time.
When you're building a pivot table, if you add fields to the Values area, Excel automatically adds "Sum of" or "Count of" to the start of the field name. You can manually remove that text, or use macros to quickly change the headings. There is one macro example here, and more on my Contextures website.