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.
With dependent drop downs, select an item from one Excel drop down list, and the next drop down only show the related items. For example, choose Canada in column C, and only see Canadian provinces in column D's drop down. Now, go beyond those basics – see how to create multiple dependent drop downs – Region, Country, Area and City.
If you're planning a vacation trip, Excel can help. It's a great place to keep your packing lists, and you can track your vacation spending too (if you really want to know the total!). I've just uploaded a new sample file that will show how far you'll travel. Select cities, and formulas do a mileage lookup, with total distance from start to end.
Last month, you saw J. Woolley's technique to run command files from Excel hyperlinks. He created a SuperLink function too, that is better than Excel’s HYPERLINK function. Now he's sharing a new technique, with better hyperlinks for Excel sheets.
Continue reading "Better Hyperlinks for Excel Sheets"
When you create a pivot table, a default PivotTable Style is automatically applied. You can change to a different style, and you can even create custom pivot table styles. To help you keep track of the styles that you have, here's a List All Pivot Table Styles macro.