When I sort an excel spreadsheet the data disappears.

[Guest]

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.

 

[Guest]

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
here:

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