En Excel las columnas aparecen con números en vez de letras. Solución

Hace unos días un cliente nos llamó con este problema: en Excel las columnas le aparecían con números como referencia, en vez de letras. Hoy os dejamos la solución.

Porque no sólo es raro, sino que también hace que no nos funcionen las referencias de las celdas creadas antes. Y, en mi opinión, crea unas referencias difíciles de entender.

Seguid los pasos del libro, eso sí, si luego abrís otro fichero que haya tenido esta configuración salvada, hay que volver a desactivarlo y guardar el fichero co el cambio.

Esperemos que os sirva.

 

Os recomendamos los siguientes productos relacionados con la informática:

 

[NUEVO]TP-Link Deco X1500(2 Pack)-AX1500 Whole Home Mesh Wi-Fi 6 System-Cobertura hasta 600 m2, 3X Puertos GigabIt por Unidad, Banda 160MHz Canal, ODFMA, 1024QAM, Color Blanco

(22016)

109,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

305XL Cartuchos de Impresora para HP 305 Cartuchos de Repuesto para HP 305 Cartuchos para HP DeskJet 2700 2710 2720e 2722e 4110e Deskjet Plus 4100 4130e Envy 6000 6010e 6020e 6030e Envy Pro 6400 6420

(41)

37,88 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Xiaomi Tablet VHU4362EU Octa Core 6 GB RAM 128 GB Gris

(320)

279,00 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Kingston NV3 NVMe PCIe 4.0 SSD Interno 1TB M.2 2280-SNV3S/1000G

(86)

59,96 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Logitech MK270 Combo Teclado y Ratón Inalámbrico para Windows, 2,4GHz Inalámbrico, Ratón Compacto, 8 teclas multimedia y de acceso directo, 2 años de batería, PC, PC Portátil, QWERTY Español - Negro

(6155)

24,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

UGREEN Revodok 105 Hub USB C HDMI 4K Adaptador USB C a USB 5 en 1 con 100W PD Carga Compatible con MacBook Pro Air M3 M2 M1, iPad Pro Air, iPhone 16 Plus Pro MAX, Galaxy S24 Plus Ultra, Surface Pro

(11940)

19,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

HP 15s-eq1040ns - Ordenador portátil de 15.6" HD (AMD Athlon 3020E, 4GB RAM, 128GB SSD, AMD Radeon Graphics, Windows 11 Home en Modo S, Microsoft 365 Personal Incluido) Plata - Teclado QWERTY Español

(634)

349,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Lenovo Tab M11 - Tablet de 11" (MediaTek Helio G88, 8GB RAM, 128GB Ampliables hasta 1 TB, 4 Altavoces, WiFi, Bluetooth, Android 13) Gris Luna - Incluye Funda y Tab Pen

(571)

211,00 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

HUAWEI Router 4G+ CPE 5, B636, Router SIM LTE, Cat 7+, DL 400Mbps/UL 200Mbps, Wi-Fi 6 AX3000, 4 Puertos Ethernet LAN, diagnóstico Wi-Fi visualizado, Cobertura de señal de Grado Industrial

(32)

89,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Unidad de disco para consolas PS5® Edición Digital (grupo de modelos slim)

(92)

290,00 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)