Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel 2002 - Autofill options greyed out

Posted on 2002-06-29
12
Medium Priority
?
738 Views
Last Modified: 2012-06-22
I'm attempting to use Autofill in Excel 2002 to extend a range of consecutive dates.  I have used Autofill many times before in other versions of Excel but have recently upgraded to Office XP.

The problem is that when I select say, the last five dates in the range I want to extend, then drag the fill handle down the column, all Excel wants to do is repeat the list, not extend it.  If I right-click the fill handle and drag down the column, the menu that pops up only has "Copy Cells" as an option, all of the Autofill selections are greyed out.

Thanks in advance for any help you can offer.
0
Comment
Question by:thescud
  • 5
  • 3
  • 3
  • +1
12 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 7118316
Hi Jeremy M,

How are your dates formatted as text? because then it seems logical for excel to fill as repeat
If you got real dates then it should be no problem

HAGD:O)Bruintje
0
 
LVL 7

Expert Comment

by:ildc
ID: 7118414
Hi Jeremy,

the autofill only works correctly if you use only the last two dates. If you use more, than excel will make a repetitive copy of all selected dates.

Regards
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7118470
Hi ildc that's not completely true since i can do it wit 4 or more dates selected, i can drag them filling down or doing it through the menu

Brian
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 44

Accepted Solution

by:
bruintje earned 150 total points
ID: 7118493
Jeremy, have you tried to do it through the menu? it seems that excel doesn't know what to fill in and that's why it is greyed out, you can do an autofill also through

-select the range you want to fill
-the first or more cells contain the value
-then choose | edit | fill | series | make a choice | OK

just let us know
Brian
0
 

Author Comment

by:thescud
ID: 7118644
bruintje:
The dates are formatted as dd/mm/yy.  That was one of the first things that I checked.
I attempted your second suggestion also.  I selected a column of about 100 cells, the top two being 03/07/02 and 04/07/02.  When I asked Excel to fill in the column from the Edit menu, it filled every cell with 03/07/02.

ildc:
I agree with bruintje.  It doesn't matter the number of cells you select to determine your pattern.

0
 
LVL 7

Expert Comment

by:ildc
ID: 7118668
Bruintje,

You're right, I tested it with non-consecutive dates and then you get copies.
0
 
LVL 7

Expert Comment

by:ildc
ID: 7118687
Jeremy,

Try once ctrl+;  .This gives you the exact date of today no matter the formatting of your system. If you copy it down and you still get the same problem, than I'm out of answers.

Regards
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7118689
one other thing to check is to see that you have Calculation as automatic

Tools --> Options --> Calculation --> Calculation: automatic

if it is non automatic it could hold up your fill down
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 7119196
A sure way to make sure your cells are truly formatted as dates:

Put a one in any blank cell. Copy that cell.
Select one of your date cells. Hit Edit-Paste special, Multiply.
Today's date would return 37436. If it returns anything else, it's not formatted as a date.

Let us know if you need help converting text to a date.

~Dreamboat
www.TheWordExpert.com
0
 

Author Comment

by:thescud
ID: 7119453
I was finally able to get Autofill to work properly, though the fix wasn't one of those offered.  The particular worksheet that I was using had a frozen pane, across row 12.  The range of dates that I was trying to extend ended around row 330.  This time I selected the entire range of dates and dragged the fill handle and it filled in the series properly.

Since then I've experimented with Autofill and it works as it should everytime, whether I select the entire range of dates or just a few.

This is an odd one.  I've been using Excel for 8 years so it wasn't a newbie error.  

Thanks everyone for your suggestions.  I hate to leave this question open so I'll award the points to bruintje.  Early bird gets the worm.
0
 

Author Comment

by:thescud
ID: 7119458
This was frustrating.  Maybe a bug?
Microsoft can't pass this one off as a "feature".
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7119629
thanks but next time just ask for a refund and let Customer Support close this question as a PAQ, you solved this yourself and that's a solution too

i always comment to let the asker choose, but please don't give the C grade because it's ruining my record

rather get no points then a C
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question