Forum Discussion

kaytlovelacegmailcom's avatar
kaytlovelacegmailcom
Copper Contributor
Jul 23, 2022

Formulas to values

I need to change all cells in a worksheet from formulas to values rather than go cell by cell throughout the entire worksheet.  Can I do this?

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor
    Highlight the whole (populated section of the) spreadsheet, and do the Copy....Paste Special...Values and Formats sequence.