Freezing part of your spreadsheet…

So now you know how to build a spreadsheet from scratch.

You can see what is coming into your household every income cycle, and you know exactly where it is going after that. As each week progresses you are moving along your spreadsheet and eventually you will be able to see what is coming in and out, BUT, you can no longer see the column that lets you know what those in and out things are right?

So here is the solution: 

You need to freeze the section of the spreadsheet that contains your written data, your headings, your specific income and expenses etc.

This is called ‘Freezing Panes’ and is super easy.

First you need to work out where you want to freeze the sheet, so let’s look at one of my sample spreadsheets again:

In this example I am selecting the cell directly beneath my income section and to the right of the headings column.

1. Click on the cell which you want to be the ‘freeze point’ as illustrated above.
2. At the very top of the spreadsheet select ‘window’
3. Now select ‘freeze panes’

Now when you scroll up and down, left and right, you will always be able to see your written headings column. To unfreeze, simply select ‘window’ again and select ‘unfreeze panes’.

Too easy right?

So there you have it, everything you need to know to build your own BudgetMum spreadsheet, but there is one more thing I’d like to say…