Select an entire row or column

You may sometimes need to select an entire row or column at once. Luckily, there are a few shortcuts that can help with this.

• To select an entire row , click the row number or press Shift+spacebar on your keyboard.
• To select an entire column , click the column letter or press Ctrl+spacebar .
• To select multiple rows or columns , click and drag over several row numbers or column letters.

These shortcuts can save you a lot of time if you need to add formatting to your spreadsheet, add or delete rows, or complete other tasks in Excel.

Watch the video below to see these shortcuts in action.