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
Oh wait, nevermind, I figured it out!
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
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks