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.
Then from the Home tab and the area of the ribbon named Clipboard, we select the command Copy as shown in the image below.
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.
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.
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.
Posted on December 6, 2016, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged Clipboard, Column Lettering, Copy, Ctrl+A, Formula Bar, Formulas, How to Create a Copy of an Excel Worksheet Without Formulas, Microsoft Excel 2016, Microsoft Office 2016, New Workbook, Office Smart, Office System, Past Values, Results, Row Numbering, Smart Office, Values. Bookmark the permalink. Comments Off on Create a Copy of an Excel Worksheet Without Formulas.