C
CGB
I'm using Office 2003 and the Excel module.
I have a spreadsheet with 3 columns. Columns A and C include names and
phone number of people. Column B is just a blank divider.
If I have the sheet alphabetized, with 10 names and numbers in column A and
10 in column B, I occasionally will go to the sheet and add someone else's
name. I add it either at the bottom of column A or C. I then highlight A
and C and ask to have it sorted alphbetically. Can't do it!!
Only thing I've been able to do is "cut" the 10 names from column C and
paste them under the 10 names in column A, add any names I want, sort column
A and then cut the bottom portion (at halfway point) of column A and paste
it to the top of column C. I then have my two-column list of
people/phones, alphabetized A1-10 and C1-10. (i.e. alphabetical list starts
at top of A and goes down column A until reaches half of the entries and
then jumps up to top of C and progresses, alphbetically down to the end.)
There's gotta be a better way!!!
Thanks.
Chet
I have a spreadsheet with 3 columns. Columns A and C include names and
phone number of people. Column B is just a blank divider.
If I have the sheet alphabetized, with 10 names and numbers in column A and
10 in column B, I occasionally will go to the sheet and add someone else's
name. I add it either at the bottom of column A or C. I then highlight A
and C and ask to have it sorted alphbetically. Can't do it!!
Only thing I've been able to do is "cut" the 10 names from column C and
paste them under the 10 names in column A, add any names I want, sort column
A and then cut the bottom portion (at halfway point) of column A and paste
it to the top of column C. I then have my two-column list of
people/phones, alphabetized A1-10 and C1-10. (i.e. alphabetical list starts
at top of A and goes down column A until reaches half of the entries and
then jumps up to top of C and progresses, alphbetically down to the end.)
There's gotta be a better way!!!
Thanks.
Chet