In this week’s roundup, generate random numbers, work with big data, build floating forms, get fancy with chart labels, and more.
Excel Macro Buttons on Floating Form
In the olden days (Excel 2003 and earlier), there were toolbars, and you could “float” those, and position them anywhere over the worksheet. You could also create custom toolbars, and add a few commands and macros to those. They could be moved around the worksheet too.
In the newer versions of Excel, those floating toolbars aren’t available, but you can create something similar, based on a UserForm. Build your own, or download my example, and customize it.
Excel Roundup 20160111
In this week’s roundup, number formatting trick, pivot chart layout, spreadsheet comedy, and much more.
Change Pivot Chart Layout
Recently, someone asked me why all the columns in their pivot chart were the same colour. The chart showed several months of data, for multiple regions, and every column was blue.
In the screen shot below, I’ve created a similar pivot chart, from fake sales data.
Excel Roundup 20160104
Welcome back, and I hope you enjoyed your holiday break! It’s taking most of my brain power to type 2016, instead of 2015, so this will be a short roundup, to get things rolling again. If you subscribe to my newsletter, the next issue will be sent on January 12, 2016.
Excel Christmas Tree 2015
It’s only a week until Christmas Eve, and to help you celebrate the holidays, I have updated my Scroll Bar Christmas tree. No macros are needed, but this version uses customizable icon sets that are available in Excel 2010 and later versions.
This will be my last blog post until the new year, so happy holidays, and remember to cell-ebrate safely!
Excel Roundup 20151214
In this week’s roundup, bad dashboards, new Workday function, calculation speed and much more.
Customize Weekends With Excel WORKDAY Function
If you’re trying to figure out when a project will be completed, you can use the WORKDAY.INTL function (Excel 2010 or later). It’s more flexible than the older WORKDAY function – it doesn’t assume that you work Monday to Friday any more!
Continue reading “Customize Weekends With Excel WORKDAY Function”
Excel Roundup 20151207
In this week’s roundup, KPI dashboards, pricing lookups, autofit for merged cell rows, and more.
AutoFit Merged Cells Row Height Update 20151203
Way back in June 2012, I posted some sample code for adjusting the row height in merged cells. It’s been 3-1/2 years, and people are still commenting on that article!
Apparently it is a common problem, and even though I don’t like merged cells, sometimes we just have to deal with them.
Continue reading “AutoFit Merged Cells Row Height Update 20151203”