2

How does Excel choose which color a newly added text will be? I makes no sense to me, look...

To be sure there isn't any invisible formatting on the cells, start with a fresh sheet and add some values:

screenshot

Then make them gray, only the actual values:

screenshot

Now try to add a new, black, value:

screenshot

So, in the columns with three values, I have to keep a distance of at least three cells to get a black value. But in the columns with just two or a single value I don't have to keep any distance at all? Or is the logic completely different and I just don't see it?

I tried clearing formats, clearing everything, creating new columns and re-typing the data into them, I can't get consistent behavior.

4
  • Is this effect true for you on any new worksheet? Try a full Repair of Office (Programs and Features, select Office and Change). If that fails, try Excel in a different Windows User Name.
    – John
    Jul 13, 2020 at 12:12
  • @John I have tested it also. It is the same as the OP. using 365. Jul 13, 2020 at 12:15
  • I am using Office 365 here and my new cells are always black. Vanilla setup and formatting.
    – John
    Jul 13, 2020 at 12:18
  • Office 2019 : Always black. Try maybe to disable all add-ons.
    – harrymc
    Jul 13, 2020 at 12:57

1 Answer 1

1

I got the answer from here and here. It is a normal behavior of Excel not bug as stated here:

We may notice that if we enter some cells with background color continuously, when you enter a value in the next adjacent cell, the cell is filled with background color as well.

To stop it, go to File -> Options. In the Advanced section, uncheck "Enable data range formats and formulas". Click OK.

IMG:

When you go back to your worksheet, the auto fil color format will not extend to the other cells.

With the option checked

IMG:

With the option unchecked

IMG:

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .