2

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

I know I can select all cells in a column using

A:A

But how can I select all cells in a row?

This doesn't work:

1:1 // select all cells in first row
1
  • 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, 2015 at 3:40

1 Answer 1

5

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

enter image description here

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .