I didn't think that was true for Auto Filters. I thought they maintained
integrity. But I can't find documentation saying so. Anne M

"Andy" wrote:

Hi

If you select a single column and sort it, only that column will be sorted.

Andy.

"annem" wrote in message
...
I have this problem also. A spreadsheet with multiple rows and columns has
been working fine until the past 3 days. I have been using the Auto
Filter
to filter and then sort for weeks and now - If I Sort using the Auto
Filter,
it only sorts that column. There is no carry over in cells - it is
actually
sorting ONLY that column. Is this a bug? Do I have a corrupted
spreadsheet?
What should I do. I certainly can't turn the spreadsheet over to my users
with it doing this !! Anne M

"CLR" wrote:

AutoFilter deals with entire rows, and should not re-sort any columns
with
reference to another.....one thing you might check is if the data you
have in
each cell is actually in that cell rather than being "carried over" from
the
cell to the left of it, and actually nothing is in the cell itself....ie
with
Modelnum 11311 in cell A1 and nothing in B1, then it can appear that
Modelnum
is the only thing in A1 and 11311 is actually in B1, but of course Excel
knows it's all in A1 and will filter accordingly....

hth
Vaya con Dios,
Chuck, CABGx3



"soteman" wrote:

I have a group of about 6 columns and many rows for a issues list. I
highlighted the group of information and selected the autofilter. But
when I
try to filter is just filters that column and does not move around the
rest
of the columns. So now the information in each of the columns is not
matched
up correctly. Any suggestions?

--
Rob