Formulas to values

Occasional Visitor

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
Highlight the whole (populated section of the) spreadsheet, and do the Copy....Paste Special...Values and Formats sequence.