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