Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to select a whole column or row in a formula in excel? [closed]

I want to select a whole column for a formula in excel. I know I can do this, for example:

=AVERAGE(B4:B54)

which would give me the average of the cells from B4 to B54 but I want to reference the whole B column. How can I do this?

like image 784
RedHood148 Avatar asked Jun 01 '13 08:06

RedHood148


People also ask

How do you refer to an entire column in a formula?

How to reference an entire column or row in Excel. When you are working with an Excel worksheet that has a variable number of rows, you may want to refer to all of the cells within a specific column. To reference the whole column, just type a column letter twice and a colon in between, for example A:A.

Why can't I select a row or column in Excel?

The fix is to check the "select locked cells" box in order for the feature to return, whether the sheet is protected or not.


1 Answers

To reference an entire column in Excel, use this syntax:

=AVERAGE(B:B)

like image 117
Holf Avatar answered Sep 22 '22 13:09

Holf