Comments on: How to use AutoFill in Excel - all fill handle options

This post looks at the AutoFill Excel feature. You will learn how to fill down series of numbers, dates and other data, create and use custom lists in Excel. This article also lets you make sure you know everything about the fill handle, cause you may be surprised how powerful this tiny option is. Continue reading →

Comments page 2. Total comments: 76

  1. excellent help rendered to me. thankyou.

  2. wonderful I cant imagine. The best help I received when I had requested to solve my problem regarding excel dragging of cells down word and so.

  3. wonderful I cant imagine

  4. Hi,
    I am using excel 2010, i am trying to put together a formula for when i populate a number in column b, column d populates with the name of the item in b. Is there any way to do this and how?
    Thanks,

    1. Hello, Leeroy,

      Please copy down column D в the following formula: =B1

      This should solve your task.

  5. Hi All,

    I am trying to create a spreadsheet to show sales of particular items. What I want to achieve is to automatically bring up the cost of an item if I select it from a drop down list. So for example, if I select Honey in column B, I want column C to automatically show £1.99, and something else in column D. Is this doable?

    Thank you!

  6. I am using excel 2010 and trying to use the flash fill function. Neither of the ways you listed above are working for me. When I right clock and drag my menu does not have flash fill at all; it is not even a faded option that's unclickable. It just is not there. When I try the other way, my options are only to copy cells, fill formatting only, or fill without formatting. This also makes my first two cells, the ones that I used to set the pattern, repeat instead of following the pattern. Help??

  7. I want to enter a date in column A1 and have it auto-fill the day of the week in B1 and so forth down the sheet. Is that possible. Thanks so much. Rick

  8. Is there a way to have excel automatically update the days of the week, if you have a month and year selected from a drop down list?

  9. Is there anyway to change the default autofill behaviour to Fill Without Formatting? It's getting a bit annoying having to change it everytime!

    1. Ho Matt,

      Click on the fill handle, drag and drop it and then click on the Auto Fill Options icon. When you click on this icon you get a list with AutoFill options. Select to Fill without formatting.

  10. hamara ke from wizard me auto fill option chahi tani bata diha

    1. Hello, PK,

      Sorry, we provide answers only in English. Please send us your request in English.

  11. I have a Dropdown Box with 3 options -process a,process b, process c .
    When i select process a, i want all the rows for process a to be populated and same process b and process c.Please help

    1. Hello Ramya,

      Please describe in detail with what you want to populate, where and in what form you want to do that.

  12. I don't think this is an auto fill issue, but would like assistance. I made a table with customers on the y axis and vertical market on the x. I placed a 1 to identify what vertical market each customer represents. I used the sum feature to add each column of "1s" to see which vertical markets we're doing best in.

    Each salesperson has his/her own spreadsheet in my "book".

    Now I want to combine all the sales people's results to a separate excel sheet in the book to get the totals of each salesperson to see which vertical markets we're doing best in and which one's we're not covering well.

    How do I copy my summation values with my vertical market data? It's two rows of information. The sum and the market, per sales rep.

    1. Hello Sue,

      If my understanding is correct, our Consolidate Worksheets Wizard can help you with your task:
      https://www.ablebits.com/excel-suite/combine-sheets.php

      Perhaps, you will also need to create a Pivot Table based on the data you'll get after merging all your spreadsheets into one.

  13. Hello,

    Thank you for these excel information. I would like to know more and I hope you don't mind me asking. Example I have column B which has 5 list of data validation. How can another cell (column A) be automatically fill in as FOUND if I choose "Payment" in the drop down list?

    I greatly appreciate your help.

    Thank you in advance.

    Sincerely,
    Ann

      1. Hello Maria,

        I really appreciate your feedback. May I know if this formula is correct for several options:
        =IFS(B2="Payment","FOUND,",""),(B2=Pending approval, "Other Status",""),(B2="N/A", "Not Found","")

        Thank you in advance.

        1. Hi! Please check out the formula below:
          =IF(B2="Payment","FOUND", IF(B2="Pending approval", "Other Status", IF(B2="N/A","Not Found","")))

          Looks like this is the correct one.

          1. Hello Maria,

            Your help is really appreciated. Thank you very much.

  14. Using Excel 2013, I am not able to autofill a column of data by double clicking on the Excel Fill Handle. For example, data in column A, data in column B, put a formula in Column C to add A+B... double clicking on the Auto Fill Handle to auto-populate the formula down column C isn't working. Any ideas?

    1. FYI, I realize I can click and drag, but I'm working with 300,000+ rows of data, and that takes too long. I was able double click and auto-fill before, but can't now for some reason.

      1. Hello, Clay,

        Thank you for your comment.

        To be able to help we need to see your spreadsheet.

        I think, in your case, it would be better and faster to format your worksheet as Excel Table. To do this, just select your data and press Ctrl+T. Then enter your formula into column C and Excel will automatically copy it for the rest of the rows.

        1. HA!
          How is this "better and faster"? In previous versions of excel (before 2013) all you had to do is double click on the lower right corner and it copied your cell all the way down to the bottom of your data. No need to declare table. Just double click and move on. Another step backwards by Microsoft.

  15. First of all i want to say thank you.becouse i got a precisely answer for my quation instade of this i fill happy.i want your advice for the feutur by by.

    1. hye can u give me your email and help me how to do it when i click drop down list , all particular cell will shows based on drop down list

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)