Fill Handle in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2083216%22%20slang%3D%22en-US%22%3EFill%20Handle%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2083216%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%20community!%20I%20am%20a%20beginner%20in%20Excel%2C%20using%202007%20version.%20I'm%20trying%20to%20fill%20the%20column%20with%20days%20and%20it%20doesn't.%20Why%3F%3F%20I%20think%20I%20tried%20everything%2C%20and%20the%20settings%20from%20the%20file%20menu%20are%20all%20properly%20selected.%20Thank%20you%20for%20your%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2083216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2083836%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20Handle%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2083836%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F937366%22%20target%3D%22_blank%22%3E%40giota12345%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20hoping%20the%20days%20will%20be%20filled%20as%20Monday%2C%20Tuesday%2C%20Wednesday...%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20so%2C%20fill%20the%20first%20two%20cells%20with%20Monday%2C%20Tuesday....and%20%3CU%3E%3CEM%3Ethen%3C%2FEM%3E%3C%2FU%3E%20drag%20the%20fill%20handle%20down.%20You%20have%20to%20give%20a%20hint%20as%20to%20what%20the%20progression%20is%20that%20you're%20expecting.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2084105%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20Handle%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2084105%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%20Yes%20I%20did%20it%20and%20copied%20Monday%20Tuesday..%20the%20options%20fill%20day%2C%20month%20etc%20are%20disable%20as%20you%20can%20see%20in%20my%20attachments%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2084301%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20Handle%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2084301%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F937366%22%20target%3D%22_blank%22%3E%40giota12345%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20somehow%20we're%20mis-communicating.%20Are%20you%20%3CU%3E%3CSTRONG%3Ecopy%3C%2FSTRONG%3E%3C%2FU%3Eing%20or%20dragging%20the%20fill%20handle%20down%3F%20What%20did%20the%20numbers%20in%20column%20B%20represent%2C%20in%20your%20first%20images%3F%20Are%20they%20in%20any%20way%20related%20to%20the%20names%20of%20the%20days%20desired%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2087250%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20Handle%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2087250%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3EI'm%20sorry%20if%20I%20wasn't%20clear%20enough.%20I%20am%20a%20beginner%20and%20do%20some%20practice%20with%20fill%20handle.%20The%20column%20B%20is%20irrelevant%20to%20column%20A.%20In%20column%20B%20I%20wanted%20to%20fill%20series%20on%20number%208%20added%208%2C%20and%20it%20was%20ok%2C%20I%20hadn't%20any%20problem.%20In%20column%20A%20I%20am%20trying%20to%20fill%20the%20days%20and%20doesn't%20work%2C%20only%20copy.%20Maybe%20is%20not%20available%20in%20Excel%202007.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 all properly selected. Thank you for your time.

10 Replies

@giota12345 

 

Are you hoping the days will be filled as Monday, Tuesday, Wednesday...?

 

If so, fill the first two cells with Monday, Tuesday....and then drag the fill handle down. You have to give a hint as to what the progression is that you're expecting.

@mathetes  Yes I did it and copied Monday Tuesday.. the options fill day, month etc are disable as you can see in my attachments .

@giota12345 

 

I think somehow we're mis-communicating. Are you copying or dragging the fill handle down? What did the numbers in column B represent, in your first images? Are they in any way related to the names of the days desired?

@mathetesI'm sorry if I wasn't clear enough. I am a beginner and do some practice with fill handle. The column B is irrelevant to column A. In column B I wanted to fill series on number 8 added 8, and it was ok, I hadn't any problem. In column A I am trying to fill the days and doesn't work, only copy. Maybe is not available in Excel 2007.

@mathetesI'm dragging the fill handle down both ways left/right click and it does nothing but copy

@giota12345 

 

Pretty sure it was available to Excel 2007. Still worthwhile to update your Excel if you are able to. There are many new and useful functions.

 

I'm afraid I'm out of diagnostic questions. It sounds as if something is set incorrectly in the FILL options, but I can't look over your shoulder. I will say that the default settings should be sufficient. I'd never even looked at that menu item until you mentioned it; the default settings have always functioned as desired. So you may have inadvertently set things to copy rather than fill.  I emphasize, though, that that is nothing but a guess.

@mathetesI understand.. I will search the settings better then.. Otherwise I will update it. Thank you very much for your time and effort.

@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")

 

@mathetesI found it!!!! In my program, days and months are in Greek... So I went in Excel options, popular, edit custom lists, and import my new English list.

@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 ; )