The new Office theme has finally hit my version of Office 365. I have begrudgingly accepted the new default font. Whatever. But I've hit a new default that I won't accept and don't know how to fix it.
I have worksheets featuring tables and some of them have user-created formatting of those tables and their colors.
When I Move/Copy a worksheet into its own workbook, the font changes to the new default (Aptos Narrow) and the table changes to a completely different color. GRRRRR! I created these tables in the colors that they are in for a reason.
In my Google searches to find a fix, somebody suggested going to Page Layout>Colors>Office 2013-2022. Great! That worked! Now my table is back to its original color again. But I do this move/copy step many times a day. I refuse to do this color changing steps every single time I move/copy that sheet into its own workbook.
Does anybody know how to stop Excel from changing any formatting when I move/copy a worksheet into its own workbook?
Screenshots of the original file and the moved sheet are attached.
Bookmarks