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.
Put Your Excel Macros on This Custom Tab
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.
Excel Cycle Font Color Command
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?
New Ways to Build Excel Addins
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.
Rename Pivot Table DrillDown Sheets
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.
Excel Threaded Comments Warning
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.
Excel ActiveX Combobox Item Select Macro
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.
Resize Excel Comments with Macros
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.
Remove Sum of in Pivot Table Headings
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.
Excel Roundup 20180712
Are you melting yet, in the summer heat? Stay indoors, and keep cool, while you read this Excel Roundup for summer 2018.