+ Reply to Thread
Results 1 to 8 of 8

Fill Series not working

  1. #1
    Registered User
    Join Date
    07-18-2017
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2

    Fill Series not working

    I'm working in Excel 2013. Since Monday morning, I've begun having a problem with the fill series function. No matter what I do - holding down shift or control keys while dragging, just dragging using fill handle - I can't get the numbers in a column to advance. The program just copies the same number into each cell. If I want to advance the numbers, I have to type in each number by hand, which can get time-consuming. Also, while last week dragging with the fill handle resulted in an Autofill box, this week all I get is the Quick Analysis tool box. I've tried restarting the program, turning off QA, and turning the Enable Fill Handle off and back on. None were successful. Has anyone else had this issue? If so, how did you fix it?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Fill Series not working

    Sounds like the value in the cell is text not a number.

    Create a new blank sheet. Type 1 into a blank cell.
    Hold down Ctrl and when the bottom right of the cell turns to a black cross drag it down. The numbers should increase by one.

    Now use the same process on your data.
    If it copies the same cell then the value is text.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    07-18-2017
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2

    Re: Fill Series not working

    No, the column in question was formatted for numbers, not text. My ding-bat mistake was that I had forgotten that I had filtered the worksheet on another column.

    Thanks for answering.

    Regards,

    Pschristmas

  4. #4
    Registered User
    Join Date
    07-27-2015
    Location
    Pittsburgh, PA USA
    MS-Off Ver
    Office 2013
    Posts
    9

    Re: Fill Series not working

    I just had to troubleshoot this issue and found a solution that may work for you.

    If sheet you are experiencing the issue on currently has a filter applied, you won't be able to use the Fill Series feature. It will only copy the top value down.

    I don't have enough reputation on this site to post a link to the site I credit for the answer, but you can Google: repairmsexcel resolve-excel-fill-handle-not-working-issue

  5. #5
    Registered User
    Join Date
    10-06-2019
    Location
    Earth
    MS-Off Ver
    2019
    Posts
    1

    Re: Fill Series not working

    Quote Originally Posted by bsacheri View Post
    I just had to troubleshoot this issue and found a solution that may work for you.

    If sheet you are experiencing the issue on currently has a filter applied, you won't be able to use the Fill Series feature. It will only copy the top value down.

    I don't have enough reputation on this site to post a link to the site I credit for the answer, but you can Google: repairmsexcel resolve-excel-fill-handle-not-working-issue
    THANK YOU! This is what caused the numbers not to auto fill series, its the bloody FILTER.

    So in order to enable or re-enable autofill series or numbers by clicking on the bottom corner right of the cell and dragging it down/across, remove whatever filter there is at the top of its table.

    Otherwise you might keep getting stuck with a Quick Analysis pop up option which wont help the autofill even if you remove it from options.

    Once again, thank you bsacheri!


  6. #6
    Registered User
    Join Date
    10-18-2019
    Location
    Kansas City
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Fill Series not working

    Quote Originally Posted by pschristmas View Post
    No, the column in question was formatted for numbers, not text. My ding-bat mistake was that I had forgotten that I had filtered the worksheet on another column.

    I have made this mistake at least twice. I ended up finding this thread, and forum, via a google search. Thanks for the help. Hopefully I will be able to help someone else.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,807

    Re: Fill Series not working

    Bob, thanks for the feedback
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Registered User
    Join Date
    09-14-2012
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Fill Series not working

    One other reason this might be happening is if you have Calculation Options set to "Manual" (Formulas -> Calculation Options -> Automatic |Automatic except for Data tables |Manual)
    I've just found it's accidentally possible to turn this to Manual from the default Automatic by hitting Alt - M - X - M, and I was tearing what little remains of my hair out retyping formulae to get them to work.
    Hope this helps someone else save some hair.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] fill between two date according to working day and non working day , holidays
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-24-2017, 01:39 PM
  2. Auto fill / flash fill not working with formulas?
    By mhorga in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-18-2016, 12:54 PM
  3. need to fill series. three different series adjacent to each other
    By ajainwa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2013, 04:48 PM
  4. Fill down will a series 1 2 2 3 3 3 etc
    By andrewljones2000 in forum Excel General
    Replies: 8
    Last Post: 03-20-2009, 07:14 AM
  5. Replies: 1
    Last Post: 07-13-2007, 10:59 AM
  6. [SOLVED] Edit Fill Series - How do I fill using minute increments
    By IUnknown in forum Excel General
    Replies: 1
    Last Post: 01-29-2006, 08:55 AM
  7. [SOLVED] Filling in a Date Series using the Fill | Series menu command
    By Bob C in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2005, 08:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1