I want to do my invites in an excel spreadsheet alphabetized. Do I put the Mr. and Mrs in the same column as the names? Then it will alphabetize by the Mr's I think. HELP!!!!
SomethingBlu
Posted:
Member since
Re: Question on invite addressing?
Titles go on their own column. When sorting, sort by last name, thus avoiding the title sort.
melijane
Posted:
Member since
Re: Question on invite addressing?
OK bUt if I sort title, first names and last names in different columns how will I get it to print correctly. TIA I am a bit slow on the finer points of Excel!!
SomethingBlu
Posted:
Member since
Re: Question on invite addressing?
Posted by melijane
OK bUt if I sort title, first names and last names in different columns how will I get it to print correctly. TIA I am a bit slow on the finer points of Excel!!
WHen you sort by 'last name' it knows that the entire line goes together, so it keeps the title and first name with the last name. Make sure you highlight your entire spreadsheet, then do 'File', 'Print Area' and then 'Set Print Area'...this guarantees that the document you're working on will be kept together. To sort, do 'Data', 'Sort' and then choose the column you want to sort by. Make sue you name your columns like 'Title', 'First Name', 'Last Name', etc so that sorting will be easier, if not do 'A', 'B', etc. based on where the info you want sorted lies.
Hope this makes sense.
melijane
Posted:
Member since
Re: Question on invite addressing?
Thank you! I do know what you mean
melijane
Posted:
Member since
Re: Question on invite addressing?
Sorry one more ! What about and guest what column does that go in?
