The Excel text to columns function is one great way to split simple cell content such as address line data or first names and last names to multiple cells to enable you to analyse or sort your data...
Recent Posts
You can create or mimic a 'watermark' in Excel quickly and easily. Strictly speaking you can't actually insert a watermark as you can in MS Word, but it is possible to insert an image into the...
As we have already discussed in an earlier post, it is always good practice to know exactly what is going on with your data and formulas as well as knowing what any errors mean. There are a few ways...
If like me, you create a substantial amount of worksheets in the the one workbook, for certain tasks then a good way to # 1 help users of the spreadsheet to to navigate your workbook # 2 give...
Having trouble with Pivot Tables, this will make your day!. Can you do any better than this?
There are two ways in Excel to wrap your text in cells. One automatically and the other manually. Either way it is a great tool to allow more control over the look and feel of your labels and...