2. Click into the first cell that does not need to be frozen. For this exercise, it would be cell
H2. Find the “View” tab, select “Freeze Panes” to open the drop-down menu, and click
Freeze Panes. All columns from H and rightward will scroll with the rest of the page.
Step 8:
Once the panes have been frozen, scroll to the right to the “FY 20XX Current” column (Column N
in the example).
This column contains the current dollars in the system tied to each of those line items. Without
action in the “FY 20XX Adjustment” (Column O in the image) in the form of added (positive) or
subtracted (negative) dollars, nothing will be changed by the adjustment. Individual dollar
amounts can be entered into this column to add or subtract to the existing values.
For more advanced tools for Excel, Step #9 shows the use of formulas to augment existing budget
data.
Step 9:
With Objects 09 and 10 selected, go to the “FY 20XX Adjustment” column and click into the very
top empty cell. As a tool, Microsoft Excel can grab data from one cell and manipulate it in another
cell, called a “formula.” This walkthrough will create two sample formulas.
Placeholder for Inflation
1. Click into that top-most empty cell in the “FY 20XX Adjustment” column in Column O. For
the example above, that is cell O41.