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!

  • Better you upload both Screen Shots before and after you inserted new Columns along with Formats, help us to suggest the solution. – Rajesh S Apr 14 '18 at 12:01

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.