Forum Discussion
Dean_Meadorsgreenmead
Nov 24, 2022Copper Contributor
Copying formats
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 n...
dscheikey
Nov 24, 2022Bronze Contributor
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:
Dean_Meadorsgreenmead
Nov 24, 2022Copper Contributor
Thank you so much for replying. Is there a way to paste the duplicate under a new tab?