Thread: Autofill
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Autofill

Luke

I prefer to enter just G11776 then right-click and drag.

Release button and "Fill Series"

Saves typing<g


Gord Dibben MS Excel MVP


On Thu, 25 Jun 2009 07:11:01 -0700, Luke M
wrote:

Before you Autofill, make sure you select 2 sequential cells so XL can see
what pattern you are looking for.

In your scenario, you would need to select both G11776 and G11777