Some how I flipped the layout of my whole excel books, I tried closing then open a new one. so everything is on the right and not the left
If this happens for all new workbooks, then the default direction of the worksheets may be changed somehow from left-to-right to right-to-left!
To revert it back to left-to-right, please check out this link.
But if this happens only for a specific workbook, please go to:
Page Layout >> Sheet Options
Then click the Sheet Right-To-Left button.
Hope that helps