Excel’s subtotal option (Data –> Subtotal) lets you display a subtotal on any number of columns for each change in a particular column. This is useful for sheets where each day, for instance, might have multiple entries recording some bit of data, and you want subtotals for each day giving you the sum, or the…
HTML5 Converter for Adobe Captivate
I’m a fan of both Apple and Adobe, which puts me in rather an odd place at times. Apple makes the hardware and operating systems I like best. Adobe makes some software that I can’t live without. Up until now, a lot of what I create with Adobe Captivate won’t play on the iPhone and…
Where is the Excel Personal Macro Workbook Located?
[Latest update: 26 April 2019] Sometimes I blog things mostly so I can remember them and in the off chance that they might be useful to others. This post falls into that category. If you use Microsoft Excel, and you have a macro that you want to be available globally–in any open workbook–you can place…
How to Show All Files in the OS X Finder
When you’re doing development work on an OS X box and need to shuttle your files to a web server, you’ll notice that the Finder (OS X’s equivalent of Windows Explorer) hides “dot files” like the all-important .htaccess files used by many web applications. You can tell the Finder to show you all files, including…