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.
Step 1. Open Excel and add a new column to the left of the data range you want to convert to a single column. Do this by selecting the far left column, clicking on it and then clicking âInsertâ in the menu that appears. Step 2. Select and name the multiple column data table you want to convert to a single column.tep 5. Select âRunâ on the VBA menu, select âRun Sub/user Formâ or press âF5â on your keyboard and go to the Excel program. Copy the data that appears in column âA1â and open your Word program. Right click on the blank page that appears and select âPaste.â Your single column list is completed.