Create a Copy of an Excel Worksheet Without Formulas


Imagine that we have created an Excel Workbook which contains Formulas which we need to distribute to others. The only problem is that we don’t want to reveal the Formulas that our Workbook contains. In the post described below, you can learn how to copy a Worksheet to a different Workbook with only the Results to be shown and not the actual Formulas.

In the image below we can see our Worksheet with all the necessary information, and we also notice that it contains Formulas. At the Formula Bar we can see the actual Formula.


Now, for the next step we will need to Copy the actual Worksheet. We can either select the top left button at the top of the Row Numbering and at the left of the Column Lettering or we can press the combination of keys Ctrl+A on our keyboard. Either way, everything will be highlighted as shown in the image below.

Select Sheet

Then from the Home tab and the area of the ribbon named Clipboard, we select the command Copy as shown in the image below.

Copy Data

Once we have selected the command Copy and all the data is copied in our Clipboard, we then create a New Workbook. Once the New Workbook is created, from the Home tab and from the area of the ribbon Clipboard we select the arrow below the command Paste as shown in the image below. Once the drop-down menu of the Paste command appears, we locate the area named Past Values and select the first command available named Values as shown below.

Paste Values

Once the Paste Values command is selected, everything that was in our Clipboard is Pasted in our Worksheet. Everything is in place, how it is supposed to be, but if we notice and move around in the Cells of the Worksheet we will notice that no Formulas are to be seen. Only the Values are in our Worksheet and there is nowhere to find a Formula.

Pasted Without Formulas

Voila! The New Worksheet now contains only the results of the Formulas from the original Worksheet and not the actual Formulas.

With this method, we can also move Worksheets from one Workbook to another, and by using the way described above we preserve the Formulas in the original Workbook.

Below you can check out the describing How to Create a Copy of an Excel Worksheet Without Formulas.

About Smart Office - philippospan

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on December 6, 2016, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Create a Copy of an Excel Worksheet Without Formulas.

Comments are closed.