Convert dates to text in Excel: days, months, times and more

This article will look at ways to convert dates to text in Excel; that means converting dates into day names, hours, months and more. This is a really simple thing to do but it has a number of uses. As an aside, when you work with data on a daily basis, these sorts of Excel tips come up quite often, and whilst its easy enough to go and find the answers on Excel forums, I thought I would start putting them down here in one place so that I remember them myself, but also so that any interested readers Read more [...]

Unhide Multiple Sheets in Excel

I recently had a need to unhide multiple sheets in Excel (maybe you call them tabs). Whoever sent me the original file had decided to spread their data out over so many extra sheets that it would have taken almost literally minutes to unhide them all. Naturally, I wasted even more time looking for a way to automate this process. I found two pretty good ways to unhide multiple Excel tabs. Unhide Multiple Excel Sheets Using Custom Views Okay, this one doesn't require any code and is EASY. It Read more [...]