Change Calendar Year to Financial Year

[kimgourlay]

I am trying to find out if there is a way to get Excel to recognise a financial year instead of the calendar year.

The answers that I've come up with so far are:
- Start the autofill with the first month
of the financial year
- Create my own autofill list

Any other suggestions?

 

[Qroozn]

customise your own list in excel. I'm just trying to remember how to add your own.

 

[Qroozn]

Tools/options/custom lists.