Right-click the sheet tab and choose "Move or Copy." Choose "new book", and
check "Create a copy," then click OK. You will be in the new book. Click the
rectangle at the intersection of row and column headers, to select all, then
Edit> copy followed by Edit> Paste Special> Values. Save the new file.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.