[mso] Re: Excel 2000 autofill

I just love workarounds....and we've seen a bunch suggested here...all of
them more "elegant" than my original one....but I was in a hurry!! LOL

But, I think the best one is to just enter Q1 Q2 Q3 Q4 Q5 and THEN use
autofill, so Ray wins (not sure what he won tho 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 Wilson Baptista Junior
Sent: Friday, May 28, 2004 9:56 AM
To: mso@xxxxxxxxxxxxx
Subject: [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


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