Itqualityassurance
- Can we Sort more than one column at a time in a selected range of cells?
- How do I apply multiple filters to one column in Excel?
Can we Sort more than one column at a time in a selected range of cells?
You can sort by up to 64 columns. Note: For best results, the range of cells that you sort should have column headings. Select any cell in the data range. On the Data tab, in the Sort & Filter group, click Sort.
How do I apply multiple filters to one column in Excel?
First, use the keyboard shortcut (Alt ⇢ D ⇢ F ⇢ F) to apply the filter, or you can also go to the Home ⇢ Sort & Filter ⇢ Filter. Next, you need to click on the filter dropdown of the column “type” and from there, you need to untick all the values other than “City”. After doing click OK to apply the filter.
