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

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

"Sam" wrote:

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