How can I select all cells in a row in Excel / Google Spreadsheet?

I know I can select all cells in a column using


But how can I select all cells in a row?

This doesn't work:

1:1 // select all cells in first row
  • 2
    1:1 is the correct format. Are you able to provide an example of the formula you're trying to get running? – Silas B Mar 2 '15 at 3:40

Simply click on the row's tag (the grey row headers on the left)

enter image description here

  • Just had to up vote this because it directly answer the question :) – Nelson Mar 2 '15 at 5:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.