This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have created a template and it has data on it. But I want to copy and paste the template onto another sheet in the same workbook without the data. How to do it? I have tried to use Move and Copy but it does not work for me. All it did was create a copy of my current template that has the data I have entered. Any suggestion? Just to be clear, I am using M1 Macbook Air.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Edit> Paste Special> Formats
You may want to use some of the other options as well.
If you need to do this frequently, keep one sheet without the data the use Move or Copy to replicate that sheet when needed.