Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill
Hi I am using autofill and have some values with text. Example: G11774,
G11775 and G11776. This is just in general format and has now stopped working when I try to fill it down using the AutoFill handle I am getting G11777 over and over again - I need it to increment to G11778, G11779 etc. Can anyone help. I am using 2000 (sorry but the company won't change)!! Thanks -- Kind regards Ann Shaw |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill
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 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Annie" wrote: Hi I am using autofill and have some values with text. Example: G11774, G11775 and G11776. This is just in general format and has now stopped working when I try to fill it down using the AutoFill handle I am getting G11777 over and over again - I need it to increment to G11778, G11779 etc. Can anyone help. I am using 2000 (sorry but the company won't change)!! Thanks -- Kind regards Ann Shaw |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill
Annie,
1 way. Instead of using the text G11774 use the formula ="G"&ROW(A11774) as you drag down the number will increment. Mike "Annie" wrote: Hi I am using autofill and have some values with text. Example: G11774, G11775 and G11776. This is just in general format and has now stopped working when I try to fill it down using the AutoFill handle I am getting G11777 over and over again - I need it to increment to G11778, G11779 etc. Can anyone help. I am using 2000 (sorry but the company won't change)!! Thanks -- Kind regards Ann Shaw |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill | Excel Discussion (Misc queries) | |||
Autofill | New Users to Excel | |||
Autofill | Excel Discussion (Misc queries) | |||
Autofill | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |