find the no of non empty rows in excel sheet

Question

i want to find out the no.of non-empty rows in the excel sheet what can we do

i want append the data at the end of the already contain record