I have forecast spreadsheets which have multiple sheets and a ton of formulas. Because executive mgmt needs to ocassionaly look at old fc's, I need to keep previous versions.
To save space, I want to copy and paste my formulas as values back into their existing cells in each worksheet.
My problem is that my worksheets contain merged cells. Therefore, when I attempt to paste special values, I get the msg:
"The operation requires the merged cells to be identically sized"
Is there a way to get around this without reformatting the worksheets?
Thank you.
To save space, I want to copy and paste my formulas as values back into their existing cells in each worksheet.
My problem is that my worksheets contain merged cells. Therefore, when I attempt to paste special values, I get the msg:
"The operation requires the merged cells to be identically sized"
Is there a way to get around this without reformatting the worksheets?
Thank you.
