Thanks. I do have that button but, yes, I want it to be automatic as I have a number of custom Styles set for whole areas of the spreadsheet and don't want to fiddle around with individual cell formatting.