Nov 4, 2012
In Excel 2007 and above, it’s easy to shade alternate rows by creating a Table. However in earlier versions it was necessary to use a combination of conditional formatting and the MOD function. Note that this method will work in 2007 and above as an alternative...
Jun 6, 2012
**Download this tutorial (zipped PDF)** A common problem that many people have is where they have a spreadsheet where data in a single column needs to be split into multiple columns. For example a list of employee names where both First Name and Surname are in the...
