Deshabilitar el autor relleno de fórmulas en una tabla

%3CLINGO-SUB%20id%3D%22lingo-sub-1480843%22%20slang%3D%22es-ES%22%3EDisable%20the%20formula-filled%20author%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480843%22%20slang%3D%22es-ES%22%3EGood%20morning%2C%20I%20have%20several%20sheets%20with%20the%20same%20column%20structure%2C%20and%20only%20one%20changes%20which%20tells%20me%20what%20type%20of%20variable%20is%2C%20example%3A%20sale%2C%20units%20and%20price.%20In%20order%20to%20connect%20the%20three%20bases%20using%20PivotTable%20I%20must%20convert%20these%20ranges%20into%20tables.%20The%20problem%20is%20that%20when%20working%20with%20tables%2C%20if%20I%20want%20to%20edit%20the%20information%2C%20and%20I%20enter%20a%20formula%20into%20a%20cell%2C%20when%20pressing%20Enter%2C%20it%20is%20auto-populated%20or%20replicated%20for%20the%20whole%20column%2C%20modifying%20the%20other%20records%2C%20a%20fact%20that%20I%20want%20to%20avoid%20or%20disable.%20Is%20this%20possible%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1480843%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1490719%22%20slang%3D%22en-US%22%3ERe%3A%20Deshabilitar%20el%20autor%20relleno%20de%20f%C3%B3rmulas%20en%20una%20tabla%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1490719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706707%22%20target%3D%22_blank%22%3E%40Julin_Ibarra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESi.%20Veta%20a...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFile%20%26gt%3B%20Options%20%26gt%3B%20Proofing%20%26gt%3B%20AutoCorrect%20Options%20%26gt%3B%20AutoFormat%20As%20You%20Type%20%26gt%3B%20Fill%20formulas%20in%20tables%20to%20create%20calculated%20columns%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(lo%20siento%2C%20yo%20no%20habla%20Spanish%2C%20yo%20uso%20Google)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%222020-06-25_14-45-51.jpg%22%20style%3D%22width%3A%20835px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201213i681442D5686AA58D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-06-25_14-45-51.jpg%22%20alt%3D%222020-06-25_14-45-51.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Buen día, tengo varias hojas con la misma estructura de columnas, y solo cambia una la cual me indica que tipo de variable es, ejemplo: venta, unidades y precio. Para poder conectar las tres bases utilizando tabla dinámicas debo convertir estos rangos en tablas. El problema es que al trabajar con tablas, si quiero editar la información, e ingreso una fórmula en una celda, al presionar Enter, se autorrellena o se réplica para toda la columna, modificandome los demás registros, hecho que quiero evitar o deshabilitar. Es esto posible?
1 Reply

@Julin_Ibarra 

Si. Veta a...

 

File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type > Fill formulas in tables to create calculated columns

 

(lo siento, yo no habla Spanish, yo uso Google)

 

2020-06-25_14-45-51.jpg