I received an Excel file today from one of my colleagues that contained carriage returns at the end of each line of text, these were displayed as small boxes. They were having trouble splitting out...
Category: Excel Tips& Tricks
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...
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...
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...