Sort Help
 

I am having problems sorting my spreadsheet, I have never seen Excel act like
this before. I have a spreadsheet listing Building and Department Name. I
want to sort by building then Department name.

Excel is keeping the buildings together East and West but the Department
names are not in alpha order.

Sort Help
 

It sounds as if there's a blank column in your table or the table range is
incorrect.

Try manually selecting all the data in the table and sorting.
--
Kevin Backmann


"Erika" wrote:

I am having problems sorting my spreadsheet, I have never seen Excel act like
this before. I have a spreadsheet listing Building and Department Name. I
want to sort by building then Department name.

Excel is keeping the buildings together East and West but the Department
names are not in alpha order.

Sort Help
 

If I sort just by Department, it sorts perfectly. So what does that tell me?

"Kevin B" wrote:

It sounds as if there's a blank column in your table or the table range is
incorrect.

Try manually selecting all the data in the table and sorting.
--
Kevin Backmann


"Erika" wrote:

I am having problems sorting my spreadsheet, I have never seen Excel act like
this before. I have a spreadsheet listing Building and Department Name. I
want to sort by building then Department name.

Excel is keeping the buildings together East and West but the Department
names are not in alpha order.