Annualize data on entire sheet

[cherylv]

Hello there - I have a financial report (exported to excel) that runs from Jan 1st - Sept 30. For budgeting purposes, I need to 'annualize' this data to project what our income/expenses will be thru Dec 31. How do I apply the divide by 9 then multiply by 12 formula across all cells on my spreadsheet?

 

[Scott R]

enter =12/9 in a cell.
copy that cell and Paste Special, Values, Multiply on whatever cells needs to be upsized.