If you ever have inserted pictures into an Excel spreadsheet then this is one tips you will want to know. A picture can go a long way to enhance your Workbook, maybe it is a logo or informational...

From Excel 2007 onwards it is really easy to identify duplicate values in an Excel range of cells with just a few clicks and a bit of conditional formatting. Select the range of cells you...

Do you need to have your columns widths static, so when you refresh your Pivot Table it remains just as you want it it to?. This is really easy in Excel and something I use all of the time when I...

If you live in the Euro zone or have to represent the Euro Symbol in your Excel work you may notice that it is not always displayed as being available on your keyboard. Depending on your keyboard it...

Merged cells, they cause havoc with a spreadsheet.  The Effects can be far reaching and sometimes not appear at the time of development.  If you do use merged cells you will run the risk of the...