how to autosort

Hi there!

I've created a very simple Excell 2011 document to help me keep track of my finances. It consists of four columns (date, description, amount and running total) and I want each item (the date, description and amount) to be ordered by date. The running total doens't move.

The thing is, every time I add a new item or alter a date on an already entered item I have to select all and sort the data. Is there anyway to make it automatic? So that whever a date is changed or added it will automatically resort?

Thanks!

Jen

Hi Marvin,

Thanks for your response. Maybe I'm not understanding but that seems to be a way to filter entires, rather than sort them. No?