Nov 24 2022 10:39 AM
I built a single-page Excel spreadsheet that I use repeatedly. It has varying column widths, type fonts, and line sizes. The format works great for me, but candidly, it’s a real pain to re-format a new spreadsheet every few days. I have a PC running Windows 11. The Excel version is whatever comes with Microsoft 365.
I admit to not being tech savvy. I tried simple copying and pasting to a new sheet, but none of the “paste” options duplicated my formatting. I tried “save as” but couldn’t get that to replicate on a new spreadsheet. I’m missing something…can anyone help solve my problem? Thanks!
Nov 24 2022 10:51 AM
You can duplicate the worksheet. Simply right-click on the worksheet tab and select Duplicate. This copies your sheet 1:1 with all formatting.
Screenshot example of Excel for the web:
Nov 24 2022 01:53 PM
Thank you so much for replying. Is there a way to paste the duplicate under a new tab?
Nov 24 2022 02:01 PM
Nov 25 2022 03:19 AM