You have two sheets selected........see [Group] in title bar.

Ungrouped Key Efficiency Data by selecting it.


Gord Dibben MS Excel MVP

On Fri, 19 Feb 2010 14:54:02 -0800, "james" wrote:

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/q..._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. $&*%$*?