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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com