So I'm going to create another column here. That takes a long time to select them all and then deselect them and it's not the proper way to do it.Ī better way is to create a new column. So you could go in here, click on the Action button for column A, and then Filter Table, and select every item that is in that specific month.

I want to just do February of 2017 but I see everything from when I started keeping records all the way to the present day. So you've got, here at the top, month and year. But the problem is what happens when you need to produce a monthly report. This can go and be thousands and thousands of rows long after several years. If you have three or four years worth it takes a long time to do that.Ī better way to do it is to have a spreadsheet like this where everything is in one long table. Also if you need to update these tables in someway you have to go and do it for each month.

But it's not so great when you need to relate these items across months like totals for the entire year or, you know, tracking expenses over a few months by item type. This is handy when you need to produce a monthly report, maybe PDF or printout for each month. People will have separate tables, in fact entire separate sheets, for each month of the year when keeping track of things like expenses. Video Transcript: I see this a lot in Numbers. Check out Monthly Expenses On a Single Spreadsheet at YouTube for closed captioning and more options.

Personal budget template for mac