Set a new tab or sheet

Occasional Contributor

When I copy and paste my original worksheet into a new tab, is there a way to get the formatting the same so I don't have top go and mess with all of the column widths, etc. on the new tab?

1 Reply


Why don't you copy the worksheet itself?

  • Right-click the sheet tab of the source sheet.
  • Select 'Move or Copy...' from the context menu.
  • Tick the check box 'Create a copy'.
  • Specify where you want the copy.
  • Click OK.