EXCEL 功能一問

1) It's not possible to do 橫向 filtering.

2) You could copy the whole column or whole row, and then right click choose PASTE SPECIAL.Just check the box called "transpose" and OK.

For example if you copy data in Column A (data from A1 through A10) , just copy and paste special and transpose the data in Cell A1, the data will paste from Cell A1 to Cell J1.

You can just the transpose function to change how to present the data.



I hope that helps. Let me know if there's any problem.=)