Excel tips and tutorials
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.
In this week’s roundup, number formatting trick, pivot chart layout, spreadsheet comedy, and much more.
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.
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.
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!
In this week’s roundup, bad dashboards, new Workday function, calculation speed and much more.
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”
In this week’s roundup, KPI dashboards, pricing lookups, autofit for merged cell rows, and more.
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”
In this week’s roundup, prevent errors, break links, register for an Excel summit, download an Advent calendar, and more.