Auto Fill Options in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-281148%22%20slang%3D%22en-US%22%3EAuto%20Fill%20Options%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281148%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20two%20worksheets%20in%20the%20%3CSTRONG%3Esame%20spreadsheet%20file%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%3CSTRONG%3EIn%20one%3C%2FSTRONG%3E%2C%20when%20I%20type%201%2C2%2C3%2C...%20in%20a%20column%20I%20am%20able%20to%20auto%20fill%20(using%20the%20auto%20fill%20drag%20handle)%20the%20following%20cells%20in%20the%20column%20as%20a%20%22Series%22%20and%20have%20it%20create%20cells%20following%20with%204%2C5%2C6%2C%20etc.%3C%2FP%3E%3CP%3E%3CSTRONG%3EIn%20the%20other%3C%2FSTRONG%3E%2C%20typing%201%2C2%2C3%2C...%20in%20a%20column%20and%20selecting%20the%20auto%20fill%20drag%20handle%20just%20copies%20the%20pattern.%20Selecting%20the%20auto%20fill%20menu%20option%20shows%20me%20that%20the%20%22Series%22%20item%20is%20greyed%20out.%20Why%3F%26nbsp%3B%20How%20can%20I%20%22ungrey%22%20it%20and%20activate%20the%20auto-fill-as-a-numerical-series-option%20in%20this%20second%20spreadsheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20any%20comments%2Fhelp.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-281148%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

I have two worksheets in the same spreadsheet file.

In one, when I type 1,2,3,... in a column I am able to auto fill (using the auto fill drag handle) the following cells in the column as a "Series" and have it create cells following with 4,5,6, etc.

In the other, typing 1,2,3,... in a column and selecting the auto fill drag handle just copies the pattern. Selecting the auto fill menu option shows me that the "Series" item is greyed out. Why?  How can I "ungrey" it and activate the auto-fill-as-a-numerical-series-option in this second spreadsheet?

 

Many thanks for any comments/help.

0 Replies