Usually you don't need to select the complete sheet to autofill. You may try
the Excel help with the term "autofill", there are some good examples there
and they may apply to your specific case.

Hope this helps,
Miguel.

"kat50" wrote:

I am trying to get my rows to auto fill. Even though I am higlighting
complete sheet and selecting auto fill row it just won't do it. Help