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...
Tag: Excel Tips
Excel Pivot Table Tip-Set Stable Widths On An Excel Pivot Table
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...
Formula Friday -How to count cells with the COUNTA Excel function
Hey Excellers, yet it's Friday again, time for another instalment of Formula Friday!. Today let's look at the COUNTA function. You are probably used to Excel performing calculations with...
Hey all Excel ers it is Friday again and today we going to be a convert, yes to using the CONVERT function in Excel. This function is one really useful took that should be well and truly in your...