I have ran into an annoying thing in Excel 2013 for a few times now, and I can't find any reason for this behaviour. Below are the steps to reproduce the weird behaviour: the question is, is this a bug in Excel 2013 or can I prevent this somehow?
Step 1: Create new, empty Excel workbook.
Step 2: Fill the first couple of rows with a colour (or apply bold text, or probably any formatting you want; in my case this happens with colour fill).
Step 3: Type some text in a cell on the bottom row of the coloured area, so that it becomes like a "header" for a column.
After step 3, it looks like this:
Step 4: Hit 'Enter' and continue typing text in cells below the 'header', in the non-coloured area. Hit 'Enter' after each cell so that the cell in the next row below is selected.
Result: Suddenly after one or two rows, the cells pick up the colour fill from the 'header' area as I press 'Enter' (see screenshot below).
So the formatting kind of spills over from the header area into the rows below. Nothing is done except typing "foo" and pressing 'Enter' after text has been typed in. No conditional formatting rules exist in the workbook.
What is going on and how do I stop this?
Background: I tend to use a coloured 'header area' for some ad-hoc spreadsheets, in which I can put all kinds of general information and column names. It gets very annoying when the header formatting is suddenly applied on the data rows... I also suspect this happened already in Excel 2010, but I cannot check that right now.