How to Make an Excel Spreadsheet Roll Over to the Next Year for Calculations. Accounting for a small business using Microsoft's Excel often requires the use of figures from one year as part of the ...