Best way to streamline rent/utilities spreadsheet

Hi everyone,
I'm in charge of all expenses for my college apartment (6 guys), and I just got into Excel to streamline the whole rent/utilities/Costco run experience.

Right now, I have a basic spreadsheet which requires a lot of input on my end, and I was just wondering if there was a better way to organize the spreadsheet.

The basic things I need on it are:
> Rent (No calculation needed)
> Utilities (divided 6 ways)
> I have total utilities in one row, and under each Roommate column I have that total utilities cell / 6. (Oddly enough, I can't seem to create a formula for multiple cells at once - I have to copy and paste the formula into each individual cell)

> Food
> Some are divided 6 ways, which I assume is the same as Utilities
> Some are divided in other ways, so I assume I have to do them manually

> Total for everyone


I know it's a lot to ask, but I was just wondering if I could get some input on it...I'm at my wit's end trying to find a faster way of doing all this!

Thanks!

Thanks for the links, but all the templates I found are way too complicated for what I need. Basically, I just want to be able to calculate expenses for each roommate, which typically entails a Total in Column B divided by 6, and that solution transferred to all the roommates.

I guess the main problem I'm having now is not being able to put a formula in multiple cells at the same time. I tried highlighting and pasting, and it just says that the clipboard item isn't the same size as the cell.