To paste data in the opposite direction in Excel:

1. Copy the data you want to transpose from cells A1:A5.
2. Select the range of cells where you want to paste the transposed data, which in this case is B1:B5.
3. Right-click on the selected range and choose "Paste Special" from the context menu.
4. In the Paste Special dialog box, check the "Transpose" option and click OK.
5. The data from cells A1:A5 will now be pasted in cells B1:B5 in the opposite direction, with the data from cell A5 in B1, A4 in B2, A3 in B3, A2 in B4, and A1 in B5.

That's it! Using the Transpose feature is a quick and easy way to paste data in the opposite direction in Excel.