Autor relleno

%3CLINGO-SUB%20id%3D%22lingo-sub-2090159%22%20slang%3D%22es-ES%22%3EStuffed%20author%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090159%22%20slang%3D%22es-ES%22%3EI'm%20having%20trouble%20using%20the%20stuffed%20author.%20When%20you%20dragged%20the%20formula%20to%20the%20right%20it%20succeeds%20but%20when%20I%20double%20click%20to%20perform%20autofill%20down%20on%20multiple%20columns%20it%20does%20not%20work%20and%20I%20have%20enabled%20that%20function%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2090159%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2092890%22%20slang%3D%22en-US%22%3ERe%3A%20Autor%20relleno%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092890%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F940129%22%20target%3D%22_blank%22%3E%40Nathalyaphow%3C%2FA%3E%26nbsp%3BPerhaps%20you%20mean%20this.%3C%2FP%3E%3CP%3EThe%20auto%20fill%20will%20NOT%20work%20when%20you%20select%20cells%20like%20in%20the%20picture%20below.%20Active%20cell%20is%20B2%20where%20I%20dragged%20the%20number%20from%20towards%20the%20right.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-01-25%20at%2008.01.14.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249057i1061696F6A90148A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-01-25%20at%2008.01.14.png%22%20alt%3D%22Screenshot%202021-01-25%20at%2008.01.14.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20selecting%20C2%3AE2%20and%20double-click%20the%20%22fill%20marker%22%20(bottom%20right-hand%20corner%20in%20E2)%2C%20then%20it%20will%20work.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-01-25%20at%2008.01.29.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249058i17EA64EFDE674487%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-01-25%20at%2008.01.29.png%22%20alt%3D%22Screenshot%202021-01-25%20at%2008.01.29.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-01-25%20at%2008.01.47.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249059iB4298E8F72619770%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-01-25%20at%2008.01.47.png%22%20alt%3D%22Screenshot%202021-01-25%20at%2008.01.47.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Tengo problemas para usar el autor relleno. Cuando arrastró la fórmula hacia la derecha se realiza correctamente pero cuando doy doble clic para realizar el autorrelleno hacia abajo en varias columnas no funciona y tengo habilitada dicha función
2 Replies

@Nathalyaphow Perhaps you mean this.

The auto fill will NOT work when you select cells like in the picture below. Active cell is B2 where I dragged the number from towards the right.

Screenshot 2021-01-25 at 08.01.14.png

 

But selecting C2:E2 and double-click the "fill marker" (bottom right-hand corner in E2), then it will work.

Screenshot 2021-01-25 at 08.01.29.pngScreenshot 2021-01-25 at 08.01.47.png

@Nathalyaphow 

Another option:

- stay on B2

- select entire range to copy, e.g. B2:H100

- Ctrl+D

- Ctrl+R