How to filter rows instead of columns in excel

Filtering data horizontally in Excel is not as straightforward as filtering data vertically using the built-in filter feature. However, you can achieve this by using a combination of the TRANSPOSE function and the regular filter feature.

Here's how to do it:

1. First, make sure you have enough empty space in your worksheet to accommodate the transposed data. You will need a number of empty rows equal to the number of columns in your original data and a number of empty columns equal to the number of rows in your original data.

2. Click on a blank cell where you want to start the transposed data. This cell should be located in the empty space you prepared in the previous step.
3. Type the formula in the selected cell, where "range" refers to the range of cells containing the original data that you want to filter horizontally.

   Horizontal filter in excel shortcut

4. Horizontal filter in excel shortcut
5. How to filter horizontally in excel without transpose
6. Vertical filter in excel
7. Excel filter horizontally and vertically
8. Row filter in excel

For example, if you want to transpose data from cells A1 to C5, the formula would be .

9. Press to enter the formula as an array formula. Excel will automatically surround the formula with curly braces to indicate that it's an array formula.

10. The selected range wi
    horizontal filter in excel shortcut
    how to do horizontal filter in excel