Forum Discussion
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...
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:
Also, I don't have a "duplicate" option. There is one that says, "Move or Copy."
- I am surprised that your attempt to "save as" did not produce the desired result, but...
Yes, you can click the "Move or Copy..." menu item. In the dialog that appears, check the "Create a copy" checkbox (and select other options as desired). If you make the copy in the same workbook (which is the default location), the copy will probably be given a name with " (2)" appended, and that new worksheet will be activated. You can right-click its tab to rename it.
