Can I write "=AVERAGE(B51:B65005)"

[Guest]

Hi
1. I want average from cell B 51 to the last cell of column B. can I write
=AVERAGE(B51:B65005)

2. How can I format cell B 51 to the last cell of column B

Thanks
Daniel

 

[Guest]

Becasue AVERAGE ignores blanks, it is o.k. to use:

=AVERAGE(B51:B65536)