How to select a row in Excel

You can watch a video tutorial here.

The format of a spreadsheet in Excel is in the form of columns and rows. You may need to select a row to format it or copy it to another location.

Option 1 – Use the row header

Step 1 – Select the row

  • Place the cursor on the row header
  • When the cursor changes to a small black arrow, click
  • The row will be selected

Option 2 – Use keyboard shortcuts

Step 1 – Position the cursor

  • Place the cursor in any cell in the row to be selected

Step 2 – Select the row

  • Press Ctrl+Shift+Right Arrow
  • The row to the right of the cursor will be selected

Note: Ctrl+Shift+Left Arrow will select the row to the left of the cursor