Forum Discussion

Deacon_Chuck1670's avatar
Deacon_Chuck1670
Copper Contributor
Aug 26, 2023

How do I copy the exact worksheet without losing its spacing?

When I copy a spreadsheet and want to create another to a new worksheet the column spacing changes. How do I keep the spreadsheet intact as it is?
Excel
SnowMan55's avatar
SnowMan55
Bronze Contributor
Aug 27, 2023

Deacon_Chuck1670 

  1. Right-click the worksheet's tab.  In the context (popup) menu that appears, click "Move or Copy…".  A dialog like this appears: 
  2. Check the "Create a copy" checkbox.
  3. You may also change where the copy will be placed by selecting a different entry from the "To book:" dropdown list and/or clicking a row in the "Before sheet:" list.
  4. Click OK.

Those instructions are for a Windows version of Excel.  If you are running Excel on a different platform, the menu/dialog may be slightly different.

 

Resources