One quick workaround for this is to right-click the tabname at the
bottom of the screen, and select "Move or Copy". Select "Create Copy"
and highlight the relative tab location you prefer. This will make an
exact duplicate of a sprdsht, maintaining all formats, column widths,
headers, footers, etc. You'll need to delete data, tho. Hope this is
useful for you!