Why can't this table be sorted?

  • Thread starter Thread starter james
  • Start date Start date
J

james

Could someone tell me why this table cannot be sorted on the energy factor
column? The sort function is greyed out.

http://downloads.energystar.gov/bi/qplist/dehumid_prod_list.xls

At first I thought because the "numbers" are text, so I created a new colum
K using =H1 and extended down, then I copy and paste the values into column
J.

Surprisingly, column J still won't sort.

Even if I manually enter some numbers into a new column, they still won't
sort. $&*%$*?
 
You have two sheets selected........see [Group] in title bar.

Ungrouped Key Efficiency Data by selecting it.


Gord Dibben MS Excel MVP
 
Gord Dibben said:
You have two sheets selected........see [Group] in title bar.

Ungrouped Key Efficiency Data by selecting it.
Click to expand...

Works!

I can't help but wonder why programmers keep using menu grey-out to replace
dialog. In this case, selecting sort should display a prompt "you have 2
sheets selected, do you wish to de-selected and sort? Yes No"

This is not just more friendly, but saves them money in support cost.
 
I agree there should be more indication than the static [Group] on the title
bar.

Not sure what would be entailed or what other indication could be employed.

Many people get burned by this.

You can get disastrous results with grouped sheets. Most everything you do
to the activesheet will be done to all sheets in the group.


Gord

Gord Dibben said:
You have two sheets selected........see [Group] in title bar.

Ungrouped Key Efficiency Data by selecting it.
Click to expand...

Works!

I can't help but wonder why programmers keep using menu grey-out to replace
dialog. In this case, selecting sort should display a prompt "you have 2
sheets selected, do you wish to de-selected and sort? Yes No"

This is not just more friendly, but saves them money in support cost.
Click to expand...
 
Back
Top