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?
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.
The fix is to check the "select locked cells" box in order for the feature to return, whether the sheet is protected or not.
To reference an entire column in Excel, use this syntax:
=AVERAGE(B:B)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With