How did you... (excel related)

Toucan311 Posted: Jun 13, 2008 02:51 PM

How did you... (excel related)

Do your guest list on excel? Did you just make a few rows of boxes and put in the addresses or is it more complicated than that?

Browneyesncute Posted: Jun 13, 2008 02:52 PM

Re: How did you... (excel related)

that all i did

name address city state zip

Toucan311 Posted: Jun 13, 2008 02:53 PM

Re: How did you... (excel related)

Are you also using it as a check list? Like, shoudl I make a mini column for yes/no/number of guests or something?

bigrd37 Posted: Jun 13, 2008 02:53 PM

Re: How did you... (excel related)

i have it in an excel file and when i tried to print, it came out on 6 pages b/c it printed all the info across the pages. is there a better way to do that?

Browneyesncute Posted: Jun 13, 2008 02:57 PM

Re: How did you... (excel related)

Posted by Mimacat

Are you also using it as a check list? Like, shoudl I make a mini column for yes/no/number of guests or something?

hmm fh is the excel expert but mine has a yes and no column, fh set it up so it adds it self up. sorry i'm no help with that lol

futuremrsfab Posted: Jun 13, 2008 02:57 PM

Re: How did you... (excel related)

I have everything separated out into columns
Mr./Ms., First Name, Last Name, Guest First, Guest Last, Street Address, Town, State, # invited, who they are a guest of & then a column for response.

It helped when I needed to get the envelopes printed- I just sent the invite lady the spreadsheet and everything was all there.

beachbum05 Posted: Jun 13, 2008 02:59 PM

Re: How did you... (excel related)

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.

Wedding999 Posted: Jun 13, 2008 03:01 PM

Re: How did you... (excel related)

i actually did mine online through my website (wedding channel) and then you can covert it to excel (thats what i did to print labels)

TrueLoveIn2008 Posted: Jun 13, 2008 03:02 PM

Re: How did you... (excel related)

Posted by Mimacat

Are you also using it as a check list? Like, shoudl I make a mini column for yes/no/number of guests or something?

This is what I did. I made a '# of Guests' column and put 2, 1, etc in that column so that I could make a SUM at the end. I think I also did a 'Will Come?' column, which I had originally put 'Yes' or 'No' in - all speculative of course, so I could get an idea of how many would come - but I then changed it to how many people I thought would come out of that party, so I could also do a sum.

And, I have a 'STD sent?' column (with yes or no in the column, just to keep track of who was sent one and who wasn't - mostly sent to OOTers and close, close family, this way if someone has to be taken off the list I will know who got an STD and who didn't) and a 'Shower?' column to indicate who I would like / expect at the shower, should my mom ask for a list ....

I went all out.

Toucan311 Posted: Jun 13, 2008 03:04 PM

Re: How did you... (excel related)

Oh now my head hurts

emomma17 Posted: Jun 13, 2008 03:07 PM

Re: How did you... (excel related)

I downloaded something from www.weddingnsw.com for free it gave me an excel sheet with a check list, planner, guest tracker and table seating charts.

Toucan311 Posted: Jun 13, 2008 03:22 PM

Re: How did you... (excel related)

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

missliss Posted: Jun 13, 2008 03:26 PM

Re: How did you... (excel related)

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.

I heart excel too. And my list was just as OCD But I always had all my info at the click of a mouse so it was perfect.

Browneyesncute Posted: Jun 13, 2008 03:30 PM

Re: How did you... (excel related)

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

right click on that box hit format cell than click the tab that says alignment than click wrap text

Toucan311 Posted: Jun 13, 2008 03:43 PM

Re: How did you... (excel related)

Ooo thank you!

Toucan311 Posted: Jun 13, 2008 03:49 PM

Re: How did you... (excel related)

Ok, but if I'm entering the first line of the address... Mr. & Mrs. Mima... how do I get to type the 2nd line? It just seems to take me to the next box.

xXxNovember08xXx Posted: Jun 13, 2008 03:51 PM

Re: How did you... (excel related)

i have mine...
attending (y/n) / mr & mrs... / address / city / state / zip / egift /shower gift / wedding gift

each in a single row.

EK52508 Posted: Jun 13, 2008 03:52 PM

Re: How did you... (excel related)

I am obsessed with excel this is what i put there i first a column with all of the guest names, then i had there table numbers next to their name (which added amount of people for final count) i had a third column for the gifts i recieved