When I write one into one cell (B1) and two into the cell below of it (B2) like the shape 1, and select both from up to down and then pull the fill handle of the lower right corner until B7, I expect these cells are filled from one through seven. But it just copies those one and two.

enter image description here

When I pull the fill handle by right clicking, the Fill Series is grayed out in right click options! As well as, the Series dialog box (Home > Editting group > Fill drop-down list > Series) seems normal.

enter image description here

What is the problem? Why fill handle doesn't work please?

  • Try if it works with months' names, those work fine in German while the german number's names don't work either. – TheUser1024 Jun 23 '14 at 6:19

You can create a custom list of values. Go to the Excel Options > Advanced and scroll down to find the button Edit Custom Lists.

Enter the list values into the box for new lists, each value on a new row. You can also import lists from a text file. In the other box you can see that the month names are also custom lists that come as default Excel settings. No magic.

Once the custom list has been defined, it will be used by the fill handle. See the 'sieben' in the tool tip in the screenshot.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.