In my annual budget spreadsheet, I have a column of calculated final annual numbers of all the entries for each various line item. Is there a way to copy that column of final annual numbers with the calculating formulas stripped out? I like to paste those into the next year's budget.
MacBook Air (2020 or later)
Hi dtryon,
Select and copy the column. Go to next year's budget (on another sheet or in a new document) and Menu > Edit > Paste Formula Results. The data will be pasted as actual values without the formulas.
Regards,
Ian.
Hi dtryon,
Select and copy the column. Go to next year's budget (on another sheet or in a new document) and Menu > Edit > Paste Formula Results. The data will be pasted as actual values without the formulas.
Regards,
Ian.
How to Copy a column of calculated numbers with out the formulas?
