I found that that someone posted a different problem, but the offered
solution worked for my concern as well.

In case someone has my exact question, the solution that worked can be found
he

http://www.officearticles.com/excel/...soft_excel.htm

"janell" wrote:

When I attempt to sort a particular Excel spreadsheet, that data disappears,
except for the first cell in the column that I am sorting by. That cell
shows the number '1'.

Please offer suggestions, I appreciate it.