The flexibility of Excel is a lot of its value. If it wasn’t flexible like this then how could it be so widespread as a general purpose business tool?
Excel allows and embraces whatever mess you want to make.