[mso] Re: Excel 2000 autofill

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
*************************************************************

Other related posts: