fill command

%3CLINGO-SUB%20id%3D%22lingo-sub-1660567%22%20slang%3D%22en-US%22%3Efill%20command%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660567%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E'in%20Excel%202016%2C%20in%20my%20worksheet%20there%20is%20a%20block%20of%20cells%20(rows%20%26amp%3B%20columns)%20that%20will%20not%20accept%20a%20%22fill%22%20instruction.%20The%20rest%20of%20the%20sheet%20above%20and%20below%20do%20just%20fine.%20Any%20advice%20would%20be%20appreciated.'%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EDoc%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1660567%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1663514%22%20slang%3D%22de-DE%22%3ESubject%3A%20fill%20command%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663514%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750875%22%20target%3D%22_blank%22%3E%40DocSmith30215%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ETo%20give%20you%20a%20quicker%20solution%20and%20to%20understand%20it%20better%2C%20please%20explain%20it%20in%20more%20detail%20and%20if%20possible%20add%20a%20file%20(without%20sensitive%20data).%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ESo%20some%20could%20offer%20you%20a%20solution%20more%20quickly.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIt%20could%20be%20something%20that%20is%20causing%20this%2C%20for%20example%20a%20macro%20or%20that%20these%20cells%20could%20be%20locked%20in%20some%20way%2C%20etc.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

'in Excel 2016, in my worksheet there is a block of cells (rows & columns) that will not accept a "fill" instruction. The rest of the sheet above and below do just fine. Any advice would be appreciated.'

Doc

1 Reply

@DocSmith30215 

 

To give you a quicker solution and to understand it better, please explain it in more detail and if possible add a file (without sensitive data). So some could offer you a solution more quickly.

 

It could be something that is causing this, for example a macro or that these cells could be locked in some way, etc.

 

Nikolino

I know I don't know anything (Socrates)