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.
In this example, the data is on Sheet1, and will be copied to Sheet2. 1  Go to Sheet2. 2  Select a cell in an unused part of the sheet (cell C4 in this example). 3  On the Excel Ribbon's Data tab, click Advanced. 4  Choose Copy to another location. 5  Click in the List Range box. 6  Select Sheet1, and select the database.. Apply the Excel Advanced Filter. 1  Select a cell in the database. 2  On the Excel Ribbon's Data tab, click Advanced, to open the Advanced Filter dialog box. 3  You can choose to filter the list in place, or copy the results to another location. 4  Excel should automatically detect the list range.