[mso] Re: Excel 2000 autofill

Hi Green, and Linda,
I tested it in Excel2000 and the problem does seems to be with the letter 
"Q", which is interpreted as Quarter, as Linda surmised.
A quicker workaround would be to use another letter instead of Q to start 
the series (for example, X). The range will be filled correctly (X1, X2, 
X3, X4, X5 and so on). Then you just select the filled range and go to the 
Edit-->Replace menu, and on the Find What box type the letter X, then in 
the Replace With box type the letter Q. Now you have the range correctly 
filled without needing to work with another column.
Wilson

At 00:30 28/5/2004, Linda F. Johnson wrote:
>I just tried it here and for some reason, it fills to Q4 but then goes back
>to Q1...so I don't get Q1 Q2 Q3 Q1 Q2 Q3, I get Q1 Q2 Q3 Q4 Q1 Q2 Q3
>Q4...weird eh?
>
>I'm using Excel 2003, so it must do this differently, but I can't get it to
>go to Q5 Q6, etc...and I'm not sure why it's able to create Q4 but not Q5,
>Q6, Q7, unless Excel is recognizing Q1 Q2 Q3 Q4 as Quarter1, quarter2, etc.
>and knows there's only four quarters?
>
>Anyway.....Since you are in a hurry, here's a workaround....put just the
>numbers in column A and use the fill handle to fill them, 1,2,3, etc.  Then
>in B1, put this formula....
>
>="Q"&A1
>
>Then grab that formula and drag it down column B with the fill handle
>
>Then you can either hide column A or highlight column B and copy it, then go
>to Edit>Paste Special and choose "Values" and paste it right over top of
>itself so you get rid of the formulas and delete column A.
>
>That'll do what you want....or else, you can wait for someone else to come
>up with something more elegant LOL
>
>
>Linda
>Linda's Computer Stop
>http://personal-computer-tutor.com
>ABC Free Ezine ~ Free Ebooks and Tutorials
>*all outgoing mail scanned by Norton AV.  If you got a bug that looks like
>it came from me, it did NOT!
>
>-----Original Message-----
>From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
>Of Green
>Sent: Thursday, May 27, 2004 6:33 PM
>To: MSO
>Subject: [mso] Excel 2000 autofill
>
>'Lo all,
>
>I want to autofill so that if I have...
>
>A1 B1 C1
>Q1 Q2 Q3
>
>Select Q1 to Q3 and drag the +, autofill goes Q4 Q5 Q6.....
>
>At the moment it fills Q1 Q2 Q3 Q1 Q2 Q3 Q1 Q2 Q3.
>
>Does anyone know how I do that please?
>
>PS. This is fairly urgent for a report on bullying in schools.
>
>Lisa
>
>
>*************************************************************
>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
>MicrosoftOffice@xxxxxxxxxxxxxxxx
>
>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>To Unsubscribe from this group, send an email to
>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) 
>in the subject line.
>
>Or, visit the group's homepage and use the dropdown menu.  This will also 
>allow you to change your email settings to digest or vacation (no mail).
>http://www.freelists.org/webpage/mso
>
>To be able to use the files section for sharing files with the group, send 
>a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an 
>invitation with instructions.  Once you are a member of the files group, 
>you can go here to upload/download files:
>http://www.smartgroups.com/vault/msofiles
>*************************************************************


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: