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:

 

SanDisk 128GB Ultra Tarjeta de Memoria microSDXC con Adaptador SD, hasta 140 MB/s, Rendimiento de apps A1, UHS-I Clase 10, U1

(14535)

13,62 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)

Cable HDMI USB C HDMI 4K HDMI,2M Cable USB C A HDMI Cable Displayport A HDMI Compatible con Thunderbolt 3/4 a HDMI para IPhone SE/6/7,Air/Mini,Huawei Maimang 5,Vivo X9,Xiaomi 5S Plus,Samsung S8 etc.

(57)

9,16 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)

Blackview Lápiz para Tablet Universal, Punta de Disco de Alta sensibilidad para Tab8WiFi/Tab12Pro/Tab11SE/Tab7Pro y Otras Pantallas táctiles

(1)

13,99 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)

Woetale Tarjeta Memoria 512GB High Speed Tarjeta SD Card Tarjeta SD 512GB Impermeable Tarjeta de Memoria SD Card para Cámaras, Ordenadores y Drones

(22)

26,99 € (a partir de 5 junio, 2023 06:54 GMT +02: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 Router Wi-Fi 6 AX3000 - Doble Banda 2.4Ghz/5Ghz, 1xWAN/3xLAN Puertos Gigabit 5 Antenas de 6dBi WiFi+ Mesh, Soporta VPN WPA3 WPS Modo Repetidor RX12 Pro

(623)

59,99 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)

Brother Tinta Negra AC 6720/6920

(35)

34,21 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)

WENIG Mochila Antirrobo Impermeable,Mochila Portatil 15.6 Pulgadas Mochila Hombre con Puerto de Carga USB,Mochila Backpack para el Laptop para Ordenador del Negocio Trabajo Diario Viaje-Negro

(15674)

39,70 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)

Mini PC Windows 11 Pro, Blackview MP60 16GB DDR4/512GB SSD Mini Ordenador, Intel Celeron N5095, 4K HD Doble HDMI, Dual-Band 2.4G+5G WiFi, Gigabit Ethernet de Cuatro Núcleos Mini Computer Empresarial

(144)

349,99 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)

Antika Grabadora de DVD/CD Externa USB 3.0 Portátil Diseño Ultra Delgado, Lector de DVD/CD con Capacidad de Corrección de Errores, Compatible con WIN98/XP/WIN7/WIN8/WIN10/XP/Mac OS 8.6

(3850)

23,99 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)

D-Line Caja de cables EU/CTUSMLC/SW, caja de gestión de cables para ocultar cables con desorden de cables - pequeña, azul

(29789)

15,99 € (a partir de 5 junio, 2023 06:54 GMT +02: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.)