MS Excel

Is there any possiblity to show the a number of rows in Excel spread sheet by writing code in formula bar(like the one we use with autofilter) and find what we want.