Excel Tip - Selecting a portion of a column
To quickly select a large portion of a column, click on the first cell to be selected then press ctrl+shift+down arrow. This is helpful if you need to select a column of data without the column name in the top row.