How to Share or Save Excel Workbooks Without Formulas

We’ll show you 2 different ways

Want to share a Microsoft Excel worksheet without including formulas, comments, and other cell attributes? This tutorial highlights two ways to create formula-free duplicates ofExcel documents you intend to share or distribute.

Remove Excel Formulas Using Paste Special

The “Values” paste option in Excel removes specific attributes from cells or data in your worksheet. You can use the paste option to create a formula-free duplicate of your worksheet.

Open the Excel workbook you want to share or save without formulas and follow the steps below.

Excel will duplicate the sheet into a new workbook. Proceed to the next step to remove the formulas in the duplicate worksheet/workbook.

Alternatively, selectPaste Special, chooseValuesin the “Paste” section, and selectOK.

Pro Tip:You can also use theCtrl+Alt+Vkeyboard shortcut to open the Paste Special window in Excel.

The paste value option prompts Excel to remove formulas, formatting, and data validation rules from all cells in the worksheets. Cells in the worksheet will display only their values and nothing more.

Save Worksheets Without Formulas Using VBA Code

TheVisual Basic for Application (VBA) toolcan help convert cell content in an Excel worksheet to values only. If this is your first time running VBA in Excel, ourVBA guide for beginnersis a must-read.

We recommend running the VBA code below on a duplicate worksheet to avoid losing any information/data in the original document. Open the duplicate document and follow these steps:

Sub Formulas_into_Values()

Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets

Cells.Copy

Cells.PasteSpecial Paste:=xlPasteValues

Next ws

End Sub

The VBA code removes formulas from all cells in the worksheet and converts their content to values only.

The methods above are surefire ways to create value-only Excel sheets without formulas, cell formatting, comments, and other attributes. Remember to create a backup of your Excel workbook (for reference purposes) before stripping its formulas.

Sodiq has written thousands of tutorials, guides, and explainers over the past 4 years to help people solve problems with Android, iOS, Mac, and Windows devices. He also enjoys reviewing consumer tech products (smartphones, smart home devices, accessories, etc.) and binge-watching comedy series in his spare time.Read Sodiq’s Full Bio

Your email address will not be published.Required fields are marked*

Comment*

Name*

Email*

Website

Welcome to Help Desk Geek- a blog full of tech tips from trusted tech experts. We have thousands of articles and guides to help you troubleshoot any issue. Our articles have been read over 150 million times since we launched in 2008.

HomeAbout UsEditorial StandardsContact UsTerms of Use

How to Share or Save Excel Workbooks Without Formulas#

Remove Excel Formulas Using Paste Special#

Save Worksheets Without Formulas Using VBA Code#

Create and Share Formula-Free Excel Sheets#