Sorting across columns in Excel 2003

  • Thread starter Thread starter CGB
  • Start date Start date
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
 
If you're just keeping track of lists (no calculations), you may want to use
MSWord.

You can insert a table and format the page for multiple columns.

You can sort/insert/delete entries, too.
 
Yes, I could/should have done that I suppose. However, I didn't and I've
not been successful cutting it from Excel and pasting into Word, and still
retain borders, margins, etc.,etc. I'm hoping that there is just a couple
of quick keystrokes to do what I need to do.

Thanks.

Chet
 
CGB said:
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
Click to expand...
you should highlight columns A, B and C.
 
Highlight all three columns before sorting, as suggested. Or put a space
character somewhere in column B so Excel doesn't think it's a completely
empty column.

Bill

CGB said:
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
Click to expand...
you should highlight columns A, B and C.
 
Back
Top