Excel tips and tutorials
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.
In this week’s roundup, get file creation dates, plan for Thanksgiving, create icons with number formatting, and much more.
Also, I’m making a list of Black Friday (Nov 27th) and Cyber Monday (Nov 30th) sales for Excel related products. I’ll post it here on Thursday, November 26th, so we can be ready!
If you’re having a sale, and would like it included in the list, please send me the details — ddalgleish AT contextures.com
The Internet says that 15 years ago this month, I started my Contextures Excel Tips website. And since the Internet is never wrong, it must be true! The dates are a little hazy, because that was a loooong time ago, but it was definitely 2000 that I got the website up and running.
This week, I took a look back, and figured out how to get an Excel list that shows the original creation date of all my sample files. You can download a workbook with the sample code, below.
In this week’s roundup, create a rolling total, chart tricks, unmerge cells, clean data, and much more.
It’s easy to create a running total in Excel, and show the accumulated amount in each row. You can use the SUMIF function in a table, or show running totals in a pivot table.
But what if you want to show the total for a specific number of previous months – not all the previous months?
In this week’s roundup, find errors, lock slicers, plan for the holidays, use keyboard shortcuts, and much more.
My challenge this week was to show the running total in a list, but only for the current date and earlier. I wanted rows for future dates to appear empty, but have the formulas in them – ready to go. How would you solve that problem?
In this week’s roundup, prevent duplicate totals, build an Excel dashboard, formatting nit-picks, and much more.
Do you use Excel’s Subtotal command to automatically create subtotals in a list? I prefer pivot tables, but still use Subtotals in a few macros for clients. Last week, one of them asked why there were duplicate Grand Totals after applying two levels of subtotals.
Continue reading “Excel Subtotals With Duplicate Grand Totals”
