I have an Excel data table (not just a plain worksheet) and I want select all data (not the header and not the rows below the data table) in a column. What's the easiest way to do this? I use mouse at the moment but it gets inconvenient when the table has many rows.
62 Answers
@Borek another easiest way is by using keyboard shortcut ctrl + space. It will select the whole column.
When you hover over the top border of the header cell, the cursor turns to a down arrow. (Same as when you hover over the column letter.) Click once and it selects the content of the table column. Click a second time and it adds the header cell.
Roy
1
