Select all cells in a row

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

sazr

Posted 2015-03-02T01:48:13.920

Reputation: 309

21:1 is the correct format. Are you able to provide an example of the formula you're trying to get running? – Silas B – 2015-03-02T03:40:26.733

Answers

5

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

enter image description here

Gman Smith

Posted 2015-03-02T01:48:13.920

Reputation: 1 681

Just had to up vote this because it directly answer the question :) – Nelson – 2015-03-02T05:57:35.207