Expense Sheet

[TheOneBillyX]

Hello Everybody

I use to make my own expense/budget sheets with Excel 2003 and back then, when I entered the category information for A1-A6, Excel would ask me if I'm using (I think the name of it was) Autolist. I remember really loving autolist but now I have Excel 2011 on my mac and that option is not automatically coming up.

So I need your help. I'm making a expense/budget sheet (see attached picture). Basically, I have it to show which categories I want but is there a way I can make the last line (the blue area in my picture) a permanent "total" bar. I want to find a way to make it a permanent reference point and to stop cutting and pasting it when I have to create new lines.

I hope this makes sense. Please help

[TheOneBillyX]

Oh wait, nevermind, I figured it out!

[royUK]

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.


How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save