I believe your data is "grouped". You didn't specify the version of excel
you were using. In 2007, left click in the top left cell (where row and
column meet) to select the whole table. Then, select
TableTools\Outline\ungroup" from the ribbon.
The grouping columns should disappear.

Good luck.

"Pat" wrote:

HELP!!! I imported data and the resulting excel sheet has a gray area along
the left side with little buttons at the top "1" "2" "3" and vertical lines
going down from there. There's little "x"s here and there, and when I click
on either the "1" or the "x" multiple rows of data disappear (or reappear).
Also, the data rows cannot be sorted. What is this and how can I make it go
away?

The first column of data has ID numbers that link to several of the
following rows, and these are rows that appear or disappear when the "x" is
clicked. It is set up to add the number of rows in each group of rows. I
don't want all this fancy stuff, just want the data.