Forum Discussion
Problem with Excel fill handle
Hi. I've been trying to use the fill handle to fill the remaining months (in Finnish) but it just copies them. Any solutions? I have checked the options and it is enable for sure.
This is the other result if I try different filling options
It works with numbers and sometimes it works.
2 Replies
Whether Excel recognized month names depends on the region you have set in Windows Regional settings.
To find out which the month names are, enter a date like 1-1-2025 in a cell and drag this cell down using the RIGHT mouse button. Drag down 12 cells and when you release the mouse you can choose Fill months. Now format these cells to show month names in text, like mmm to show three letter abbreviations or mmmm to show the months in full. Your months must be spelled precisely like this.
If Excel shows a different spelling (language) of month names, you can either go change it in the Windows settings, or you can add the list of month names you want it to use as a custom list. Write all twelve month names into a column, then open File, Options and locate the Custom lists button on the Advanced tab close to the bottom. There is a box there to select a range of cells.
Hi. I figured it out but thanks anyway. Yes this was the problem. My PC's language is set to English so even though my Excel is in Finnish it doesn't change the recognition to Finnish so I had to manually add Finnish versions of them. That also explains why sometimes it worked that it must have been on a PC which language was set to Finnish.
