How to transpose. To transpose the data, start by selecting all the data you would like to transpose. Right-click with the data selected and click Copy. Alternatively, you can use the Ctrl+C shortcut ...

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.

Q: To make an Excel table fit better on a page when I print it, I frequently have to transpose it—that is, move all the data from, say, rows 1, 2 and 3 and put them into columns A, B and C. To do that ...