Remove Formulas For Entire Workbook

  • Hello everyone,

    I would like to remove formulas for an entire workbook at once instead of copying and pasting values sheet by sheet.

    thanks in advance for the assistance.


  • Re: Remove Formulas For Entire Workbook

    Hi watters2,

    There are already a number of posts on this topic in the forum.
    To be more accurate, you are wanting to save the workbook as "Values Only"

    Do a forum search using the terms Save Workbook Values Only.

    If you don't have a large number if sheets to work through and this is a one time activity, you can just select the entire sheet using the global selection button (at the interesect of Excels row and column headers and below the cell address indicator). With the entire sheet still selected do a Copy and Paste Special, Values Only.