+ Reply to Thread
Results 1 to 3 of 3

Unable to drag fill handle in Excel to automatically increment values

  1. #1
    Registered User
    Join Date
    12-01-2018
    Location
    Oslo
    MS-Off Ver
    2016
    Posts
    1

    Unable to drag fill handle in Excel to automatically increment values

    I have been searching on the internet for hours trying to find a solution for this.
    I have seen many similar posts but doing the suggested has not been able to fix my own problem yet.

    I want to be able to use drag-and-drop to have Excel automatically fill the lower cells in increments.

    For example I enter:
    1
    2

    When I drag the fill handle I want to get:
    1
    2
    3
    4
    5
    6

    What I get:
    1
    2
    1
    2
    1
    2

    When I right-click and drag the fill handle, I registrer that "Fill series" is greyed out. This seem to be the root of the problem.



    One method that seemed to solve the problem for many others, is to "remove the filtering and reapply it". In my case it looks like the filtering already is off, so it's not helping me in my case.

    Additional information:
    Yesterday, I was able to use the drag fill handle to automatically increment values. Today I can't, and it didn't help to reinstall Excel 2016.
    What I have tried so far:
    1. Select two cells and drag the fill handle.
    2. Hold ctrl and drag the fill handle.
    3. Went to "Excel Options", selected "Advanced" and made sure "Enable fill handle and cell drag-and-drop" was enabled.
    4. Went to "Formula" tab, selected "Calculation Options" and made sure it was set to "Automatic"
    The above have fixed the problem for other users but this has not yet fixed my own issue.

    Any additional methods would be greatly appreciated.
    Thank you.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Unable to drag fill handle in Excel to automatically increment values

    crossposted: https://www.mrexcel.com/forum/search...archid=8439229

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Unable to drag fill handle in Excel to automatically increment values

    Hi Sortebillen. Welcome to the forum.

    When you drag down (standard left mouse) a "fly out" drop down should appear down and to the right of what the results you get.
    Click that and select Fill series.

    At my end what ever was previously selected from that drop down becomes the new default.

    Does that help?
    Dave

+ 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] Disable fill-handle-drag-and-drop via VBA
    By MarmaladeLover in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2015, 07:10 AM
  2. [SOLVED] Can I make excel automatically drag-down a formula as you fill in data?
    By Yoshi64 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-16-2014, 07:28 PM
  3. Automatically expand formulas to next row without fill handle.
    By spangpang in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2013, 12:53 PM
  4. Fill Handle is not showing or unable in my excelsheet
    By ktsuraj in forum Excel General
    Replies: 1
    Last Post: 08-08-2012, 02:09 AM
  5. Replies: 1
    Last Post: 07-06-2010, 06:06 PM
  6. Fill Handle to increment sheet numbers
    By ramakavin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-19-2008, 07:03 AM
  7. [SOLVED] What is keyboard shortcut equivalent to drag the fill handle
    By JZ in forum Excel General
    Replies: 2
    Last Post: 07-31-2006, 01:30 AM

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