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:

 

Scanfield Organizador Cables Escritorio Set 2, Bandeja Organizador Escritorio, Bandeja Cables para Escritorios Robusto y Espacioso, Evita Sobre Calentamiento, Estante Modular para Ordenar Cables

(53)

14,99 € (a partir de 2 febrero, 2023 06:56 GMT +01:00 - Más informaciónProduct 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.)

TECLAST M40 Pro Tablet Android 12 8GB RAM+128GB ROM 10.1 Pulgadas, 4G LTE, 5G WiFi, (1TB TF), Octa Core 2.0GHz, 7000mAh/SIM+TF/BT5.0/Face ID/FHD1920*1200/Dobles Cámaras/GPS/OTG/Type C/4 Altavoz/Metal

(1352)

(a partir de 2 febrero, 2023 05:32 GMT +01:00 - Más informaciónProduct 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.)

TECLAST Tablet 10.1 Pulgadas Android 12 P30S, 5G WiFi, 4GB RAM+64GB ROM, 2.0GHz/1TB Expandible/Bluetooth 5.0/GPS/Dobles Cámaras/SD/Octa Core/Type C/OTG/Face ID/Metal

(102)

118,99 € (a partir de 2 febrero, 2023 05:32 GMT +01:00 - Más informaciónProduct 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.)

Samsung LF24T372FWRXEN – Monitor de 24" FullHD (1920x1080 , IPS, 75 Hz, 5 ms, AMD FreeSync, Flicker Free) Negro

(88)

109,00 € (a partir de 2 febrero, 2023 06:56 GMT +01:00 - Más informaciónProduct 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.)

Toshiba DTB420 Canvio Basics, Disco Duro portátil externo, 1, Negro

(133206)

61,36 € (a partir de 2 febrero, 2023 06:56 GMT +01:00 - Más informaciónProduct 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.)

Amazon Basics - MicroSDXC, 128 GB, con Adaptador SD, A2, U3, velocidad de lectura hasta 100 MB/s

(27337)

18,29 € (a partir de 2 febrero, 2023 03:51 GMT +01:00 - Más informaciónProduct 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.)

upHere Ventilador con Carcasa de PC de 120mm y 3 Pines, Ventilador silencioso de Alto Rendimiento para refrigeración de PC, NT12043-3

(305)

(a partir de 2 febrero, 2023 06:56 GMT +01:00 - Más informaciónProduct 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 NV2 NVMe PCIe 4.0 SSD 1000G M.2 2280 -SNV2S/1000G

(1263)

72,32 € (a partir de 2 febrero, 2023 05:32 GMT +01:00 - Más informaciónProduct 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.)

Acer Aspire 3 A315-58 - Ordenador Portátil 15.6” Full HD LED, Laptop (Intel Core i3-1115G4, 8 GB RAM, 256 GB SSD, Intel UHD Graphics, Windows 11 Home), PC Portátil Color Plata, Teclado QWERTY Español

(176)

359,00 € (a partir de 2 febrero, 2023 06:56 GMT +01:00 - Más informaciónProduct 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.)

Tenda SG105 Switch Ethernet Gigabit, 5 x 10/100/1000 Mbps puertos, RJ45, IEEE 802.3X, juegos ininterrumpidos, transmisión HD, MDI/MDIX automático, no se requiere configuración, plug and play, negro

(2301)

10,99 € (a partir de 2 febrero, 2023 06:56 GMT +01:00 - Más informaciónProduct 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.)