However, this article focuses specifically on investment in financial assets. In finance, the benefit from investment is called a return. The return may consist of capital gains or investment income, including dividends, interest, rental income etc., or a combination of the two.
Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.
1 In Excel, click Paste Special on the Edit menu, click Paste, select Text, and then click OK. 2  Select the cells that contain the data that you want to transpose. 3  On the Edit menu, click Copy. 4  Select the upper-left cell of the paste area. 5  Choose a blank area of your Excel worksheet.