I am attempting to help my dad enter client addresses in Excel to be used to print envelopes, labels, etc. I used this blog post to figure out how to format the data and did the tables like he said:
http://blogs.office.com/b/microsoft.../printing-envelopes-using-excel-and-word.aspx
So my problem is that I can't get the whole row for each individual to stay together when I sort a column. It never asks me to expand selection as it would if I didn't have the tables (in my limited experience). I've been unable to find a solution, but the author obviously does it, so I'm hopeful it's possible to do.
I'm using Excel 2007. I'm an amateur, so feel free to dumb it down for me. Thanks so much for your help!
http://blogs.office.com/b/microsoft.../printing-envelopes-using-excel-and-word.aspx
So my problem is that I can't get the whole row for each individual to stay together when I sort a column. It never asks me to expand selection as it would if I didn't have the tables (in my limited experience). I've been unable to find a solution, but the author obviously does it, so I'm hopeful it's possible to do.
I'm using Excel 2007. I'm an amateur, so feel free to dumb it down for me. Thanks so much for your help!