Forum Discussion
giota12345
Jan 21, 2021Copper Contributor
Fill Handle in Excel
Greetings community! I am a beginner in Excel, using 2007 version. I'm trying to fill the column with days and it doesn't. Why?? I think I tried everything, and the settings from the file menu are al...
giota12345
Jan 22, 2021Copper Contributor
mathetesI understand.. I will search the settings better then.. Otherwise I will update it. Thank you very much for your time and effort.
mtarler
Jan 22, 2021Silver Contributor
giota12345 just as a diagnostic check did you fill the cells in col. B using the fill handle? if not, maybe confirm the fill handle works on basic numbers.
It sounds like you are just trying things out but you could create/use a formula to do the "same" thing. This formula is based on the ROW() it is in and just fill down:
=TEXT(ROW()+1,"DDDD")
- giota12345Jan 22, 2021Copper Contributor
mtarlerYou are not going to believe what was the problem... my days and months list is in Greek.. and fill handle options were for Greek words, so I imported new lists in English. Thank you any way ; )