How did you... (excel related)

im very organized i created a simple chart on word and put all the guest addresses in one column. I had another column for rsvp to check off and a third column for thank you that i can check off.

for excell i had name, table number and gift all things that needed to be added

hopes this helps

---

Posted by Mimacat

So I can't put name and address in the same box? I have to have seperate ones for name/address/city/state/etc. I'm SO computer dumb. Please help.

---

i made heading in each box and put it going across

name ] [street] [city] [state] [zip]

i set it up this way cause i did a mail merge to make my labels

---

Posted by Mimacat

So I can't put name and address in the same box? I have to have seperate ones for name/address/city/state/etc. I'm SO computer dumb. Please help.

---

i did everythign in different colums so its easier to read.. bc its all seperated...

its just easier for me and it makes my OCD happy.

for lables... my mom will figure it out...

she set this up to do the announcements.. and she was able to merge...

i dont kno how .. but im using what she set up for me.

---

Posted by beachbum05

Mine was over the top.

I have everything - names, guest names, address, email addresses, my estimate of how many people I thought would come (totalled on the bottom), my ACTUAL count (also totalled on the bottom), a column for gifts, a column for bridal shower invites and bridal shower gifts....

I heart excel though.

---

This is how mine is!

LOL total if everyone else says 'yes' and number of people who actually replied 'yes'

---

Posted by beachbum05

Mine was over the top.

I have everything - names, guest names, address, email addresses, my estimate of how many people I thought would come (totalled on the bottom), my ACTUAL count (also totalled on the bottom), a column for gifts, a column for bridal shower invites and bridal shower gifts....

I heart excel though.

---

OMG, we had the same thing. FH also came up with a formula that gave us an estimated number of guests who would be there in relation to how people were responding. We had 3 excel sheets for the whole wedding planning process. We had the guest list, budget, and deposits. FH is an excel sheet nut, but it kept us organized!

http://office.microsoft.com/en-us/templates/TC101308531033.aspx?CategoryID=CT101172641033


this is what I used until my brother created a program for me in excess. The one from microsoft is very convenient as well though.

---

Posted by Mimacat

How do I make it so that I am able to type more than one line in an excel box? I want the box to fit:

Mr & Mrs Mima
55 Mima Road
Mimaland, NY 11730

---

Are you talking about changing the size of the box?

---

Posted by Mimacat

How do I make it so that I am able to type more than one line in an excel box? I want the box to fit:

Mr & Mrs Mima
55 Mima Road
Mimaland, NY 11730

---

ok I think I know what you mean...here;s what you do. Highlight all of the cell you want to use. Then right click on it. Press Format Cells. Go to Alignment, and check the box where it says merge cells. Click Ok. That should do it. Let me know if that's what you needed.

Mine was set-up like this:

Across the top:
Invitation #
Names (Last name first)
Street address
Street address 2 (for apartments, c/o etc)
City, State, Zip
# Invited
Yes/No
Invited to Shower
Shower Gift
Shower Thank You Sent
Wedding Gift
Wedding Thank You Sent

The last few are probably more important closer to the wedding but I did it all at once. I also printed it in landscape and it was much easier to work with. Right now I actually have the whole list taped on posterboard on a table so it's all laid out. I'm keeping track of RSVP's on there. It's a pretty good system so far and very visual for me which really helps. Good luck!!! FM me if any questions!