[mso] Re: Excel 2000 autofill

As a refinement of this idea, you don't even need the 1, 2, 3 bit. If
you want to autofill across a row, use this as the formula:

        ="Q" & COLUMN()

If you want to fill down a column use this:

        ="Q" & ROW()

If you're not starting in the leftmost or topmost cell, you might have
to use - say - ROW() -1 or COLUMN() -2

Ray

------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
www.grbps.com
------------------------------------


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Linda F. Johnson
Sent: 28 May 2004 04:30
To: mso@xxxxxxxxxxxxx
Subject: [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!


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