Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

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