Xtromintro

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 of Excel 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. First, duplicate the worksheet (to a new workbook) to avoid losing the data in the original workbook. Right-click the sheet in the worksheet tab and select Move or Copy on the action menu. Select (new book) in the “To book” drop-down menu and check the Create a copy tickbox. Select OK to close the dialog box. Excel will duplicate the sheet into a new workbook. Proceed to the next step to remove the formulas in the duplicate ...