Now that we have some test dummy data on our spreadsheet we can go ahead and reformat the column widths. You can add more data if you would like or even use an already existing spreadsheet. The choice is completely up to you; however the steps to reformat the column widths are all the same as you will soon see. The next step is to highlight the columns that you want to reformat. To reformat the columns we are using in our example, using the month names, you need to click on the column header labeled ”A”. Now hold down the ”shift” key and click the column header labeled ”L”. In other words you are clicking the first column and the last column. If you chose to use your own spreadsheet, your columns that you use may be different. You could also click on column header ”A” and holding down the left mouse button, drag the cursor over top of the final column, in this case ”L”, and let go of the mouse button. Either way is fine.
The regular payments you have so far found will form the core of your household budget. You can now turn those into a formal list, either on paper or on a spreadsheet, and put the amounts into the next column, with a heading notifying the month. Before moving on to the next phase, add a further 11 columns on the paper or spreadsheet, with the headings changed to appropriate months until you have a column for each calendar month for a year. I have prepared an example budget spreadsheet to help you.