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...

Do you want your text always to be bold, or red or any other formatting automatically as you type. A great, quick way to do this is to set up Conditional Formatting that kicks in if the user enters...