Selecting columns and rows is handy when you want to move information around, delete information, or when you want to copy a row or column. Let’s take a look. To select a column in Excel, just click the letter in the column heading. You’ll see Excel immediately select the entire column. If you want to select more than one column, and the columns are together, just click a column letter and drag to expand your selection. If you want to select more than one column, and the columns are not next to one another, hold down the control key before you click. By holding down the control key, you can add as many columns to your selection as you like. Rows work the same way as columns. To select a row, click the row number. Like columns, you can click and drag to select more than one row at a time as long as the rows are together. You can also hold down the control key to add rows that are not together to your selection. Using the control key, you can even select a combination of rows and columns.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
