I have a spreadsheet in Excel with a few columns that have a different format from the rest of the sheet.
I inserted some new cells (old ones moved to the right). None of the old cells had this special format. The column to the left of the inserted cells does not have this format. When I type in the newly created cells, they get the special format, though. I have to go back and manually return anything I type to default formatting. I can't figure out why.
Copying the default format onto the cells in question before typing doesn't help. I never set any conditional formatting rules set, but just to be sure, I cleared all formatting rules from the sheet. Still happens.
Any ideas for other things I can try? Thanks!