filter

[Sam]

I want to filter a worksheet based on one column, and have the data in all
other columns remain with their records.

 

[Dave Peterson]

That's the way data|filter should work.

Is something else happening?

 

[JLatham]

Data | Auto Filter is probably the fastest way to do this.

Are you sure you mean filter, or do you perhaps mean Sort?