MS Excel br How to split text into multiple columns? br br Sorting and Filtering Databr adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display and other rows will be hidden. With filtered data, you can then copy, format, print, etc., your having to sort or move it first.