Excel Filters

Copper Contributor

If I want to filter just one column, how do I get all other related columns (ie name, address, phone) to be included when I filter?  I want to alphabetize but when I just filter on the last name column the other data doesn't come along when I execute the filter.

1 Reply
Create the list as a Table (select all the information on the rows/columns then press "Ctrl + T") then you may sort