{"id":20965,"date":"2024-01-25T12:30:00","date_gmt":"2024-01-25T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=20965"},"modified":"2025-04-02T01:12:46","modified_gmt":"2025-04-02T06:12:46","slug":"celdas-con-numeracion-automatica","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/","title":{"rendered":"Numeraci\u00f3n autom\u00e1tica en Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-numeracion-automatica-en-excel-con-prefijo-personalizado-2-metodos\">Numeraci\u00f3n Autom\u00e1tica en Excel con Prefijo Personalizado (2 M\u00e9todos)<\/h2>\n\n\n\n<p>La <strong>numeraci\u00f3n autom\u00e1tica en Excel<\/strong> es una herramienta esencial para organizar datos de manera eficiente. Ya sea que trabajes con facturas, listas de productos o cualquier otro tipo de registros, automatizar la numeraci\u00f3n te ahorrar\u00e1 tiempo y reducir\u00e1 errores. En este art\u00edculo, exploraremos dos m\u00e9todos sencillos para lograrlo: utilizando la funci\u00f3n <strong>FILA<\/strong> y la funci\u00f3n <strong>SECUENCIA<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-provider-youtube wp-block-embed-youtube\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Celdas con Numeraci\u00f3n Autom\u00e1tica + Prefijo Personalizado (2 M\u00e9todos)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/P6uzmfntSK8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-metodo-1-numeracion-automatica-con-la-funcion-fila\">M\u00e9todo 1: Numeraci\u00f3n Autom\u00e1tica con la Funci\u00f3n FILA<\/h2>\n\n\n\n<p>La funci\u00f3n <strong>FILA<\/strong> es compatible con Excel desde la versi\u00f3n 2010, adem\u00e1s de estar disponible en Excel para la web y Google Sheets. Su principal ventaja es que se adapta al movimiento de la tabla, asegurando la numeraci\u00f3n autom\u00e1tica en Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pasos para usar la funci\u00f3n FILA<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"d6ddea\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"545\" height=\"274\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-3-png.avif\" alt=\"\" class=\"wp-image-24645 has-transparency\" style=\"--dominant-color: #d6ddea; width:461px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-3-png.avif 545w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-3-300x151.avif 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Convertir el rango en una tabla<\/strong>: Presiona <code>Ctrl + T<\/code> o dir\u00edgete a <strong>Insertar &gt; Tabla<\/strong>.<\/li>\n\n\n\n<li><strong>Aplicar la funci\u00f3n FILA<\/strong>: En la primera celda de la columna donde deseas la numeraci\u00f3n, ingresa:<code>=FILA()-FILA(Encabezado)<\/code>Esto ajustar\u00e1 la numeraci\u00f3n para que inicie desde 1.<\/li>\n\n\n\n<li><strong>Agregar un prefijo<\/strong>: Si deseas un identificador personalizado, usa la concatenaci\u00f3n con <code>&amp;<\/code>:<code>=\"FACT-\" &amp; (FILA()-FILA(Encabezado))<\/code><\/li>\n\n\n\n<li><strong>Iniciar desde un n\u00famero espec\u00edfico<\/strong>: Si deseas que la numeraci\u00f3n inicie en 300, simplemente suma 300 al resultado:<code>=\"FACT-\" &amp; (FILA()-FILA(Encabezado) + 300)<\/code><\/li>\n<\/ol>\n\n\n\n<p>Cada vez que agregues una nueva fila a la tabla, la numeraci\u00f3n se actualizar\u00e1 autom\u00e1ticamente para un manejo pr\u00e1ctico de la numeraci\u00f3n autom\u00e1tica en Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9todo 2: Numeraci\u00f3n Autom\u00e1tica con la Funci\u00f3n SECUENCIA<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"d5dce9\" data-has-transparency=\"true\" decoding=\"async\" width=\"545\" height=\"267\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-4-png.avif\" alt=\"\" class=\"wp-image-24646 has-transparency\" style=\"--dominant-color: #d5dce9; width:467px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-4-png.avif 545w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-4-300x147.avif 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/figure>\n\n\n\n<p>La funci\u00f3n <strong>SECUENCIA<\/strong> es una opci\u00f3n m\u00e1s moderna y eficiente, disponible en Excel 2021 en adelante, Excel para la web y Google Sheets. Es especialmente \u00fatil para realizar numeraci\u00f3n autom\u00e1tica en Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pasos para usar la funci\u00f3n SECUENCIA<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"d2dae8\" data-has-transparency=\"true\" decoding=\"async\" width=\"602\" height=\"283\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-5-png.avif\" alt=\"\" class=\"wp-image-24647 has-transparency\" style=\"--dominant-color: #d2dae8; width:521px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-5-png.avif 602w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-5-300x141.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/image-5-600x282.avif 600w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Definir la cantidad de filas<\/strong>:<code>=SECUENCIA(10)<\/code>Esto generar\u00e1 una lista del 1 al 10.<\/li>\n\n\n\n<li><strong>Contar la cantidad de filas din\u00e1micamente<\/strong>: Para hacer la numeraci\u00f3n autom\u00e1tica seg\u00fan el n\u00famero de filas ocupadas:<code>=SECUENCIA(CONTARA(A:A))<\/code>Donde <code>A:A<\/code> es la columna que contiene los datos.<\/li>\n\n\n\n<li><strong>Iniciar desde un n\u00famero espec\u00edfico<\/strong>:<code>=SECUENCIA(CONTARA(A:A), 1, 300, 1)<\/code>Esto har\u00e1 que la numeraci\u00f3n inicie desde 300 para tus necesidades de numeraci\u00f3n autom\u00e1tica en Excel.<\/li>\n\n\n\n<li><strong>Agregar un prefijo<\/strong>:<code>=\"FACT-\" &amp; SECUENCIA(CONTARA(A:A), 1, 300, 1)<\/code><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Importante: Evitar errores de desbordamiento<\/h3>\n\n\n\n<p>La funci\u00f3n SECUENCIA funciona con matrices din\u00e1micas, lo que significa que si hay una celda ocupada en el rango donde se expandir\u00eda, generar\u00e1 un error. Para evitar esto, mant\u00e9n organizada tu numeraci\u00f3n autom\u00e1tica en Excel:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Convertir la tabla en un rango normal<\/strong>: Ve a <strong>Dise\u00f1o de tabla &gt; Convertir en rango<\/strong>.<\/li>\n\n\n\n<li><strong>Proteger la columna con la numeraci\u00f3n<\/strong>: Selecciona las celdas que los usuarios pueden modificar, desactiva la protecci\u00f3n en ellas y luego protege la hoja (<strong>Revisar &gt; Proteger hoja<\/strong>).<\/li>\n<\/ul>\n\n\n\n<p>\ud83d\ude80 <strong>\u00a1Aprende Excel de manera f\u00e1cil y efectiva!<\/strong> Si a\u00fan pierdes tiempo con f\u00f3rmulas y tablas, este <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel<\/a><\/strong> es justo lo que necesitas. \ud83d\udcca\u2728 Dominar\u00e1s herramientas avanzadas, automatizar\u00e1s tareas y mejorar\u00e1s tu productividad en poco tiempo. \u23f3\ud83d\udca1 No dejes pasar esta oportunidad de impulsar tus habilidades. <strong>\u00a1Inscr\u00edbete ahora y lleva tu manejo de Excel al siguiente nivel!<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Estos dos m\u00e9todos permiten generar numeraci\u00f3n autom\u00e1tica en Excel de manera sencilla y eficiente. La funci\u00f3n FILA es ideal si trabajas con tablas, mientras que SECUENCIA es m\u00e1s flexible y potente si cuentas con una versi\u00f3n reciente de Excel. Adem\u00e1s, ambas opciones te permiten agregar prefijos personalizados para una mejor organizaci\u00f3n, asegurando una eficiente numeraci\u00f3n autom\u00e1tica en Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfD\u00f3nde puedo obtener Excel 2021 al mejor precio?<\/h3>\n\n\n\n<p>Si necesitas una licencia de Excel 2021, puedes adquirirla a un excelente precio en <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\">Keysfan<\/a><\/strong>. Usa el c\u00f3digo de descuento <strong>DH66<\/strong> para obtener un precio especial, y facilita tu experiencia con numeraci\u00f3n autom\u00e1tica en Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-53fba2f0 uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-0b81700d \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>1. \u00bfCu\u00e1l es la mejor funci\u00f3n para numeraci\u00f3n autom\u00e1tica en Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Si usas Excel 2021 o superior, la funci\u00f3n <strong>SECUENCIA<\/strong> es m\u00e1s eficiente. Para versiones anteriores, <strong>FILA<\/strong> es una excelente alternativa.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-6d6e87a2 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>2. \u00bfPuedo usar estas funciones en Google Sheets?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, ambas funciones est\u00e1n disponibles en Google Sheets. En este caso, la funci\u00f3n SECUENCIA se llama <code>SEQUENCE<\/code> en ingl\u00e9s.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-e737ab63 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>3. \u00bfC\u00f3mo evito errores al usar SECUENCIA?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Debes asegurarte de que no haya celdas ocupadas en el rango donde se expandir\u00e1 la matriz. Si hay datos que interfieren, recibir\u00e1s un error de \u00abdesbordamiento\u00bb.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-3298d6d6 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>4. \u00bfQu\u00e9 hacer si quiero una numeraci\u00f3n que no empiece en 1?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes sumar un valor inicial a la funci\u00f3n, por ejemplo, <code>SECUENCIA(10, 1, 300, 1)<\/code> para iniciar en 300.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-9c3a993a \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>5.\u00bfC\u00f3mo puedo hacer que la numeraci\u00f3n autom\u00e1tica se actualice al eliminar filas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Si usas la funci\u00f3n <strong>FILA<\/strong>, la numeraci\u00f3n se ajustar\u00e1 autom\u00e1ticamente al eliminar filas dentro de una tabla estructurada. En el caso de <strong>SECUENCIA<\/strong>, aseg\u00farate de usar la funci\u00f3n <strong>CONTARA()<\/strong> para contar din\u00e1micamente las filas ocupadas, de esta manera, la numeraci\u00f3n se actualizar\u00e1 en tiempo real.<\/p><\/div><\/div><\/div>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfQuieren aprender a crear celdas auto numerables en Excel? En este tutorial enfocado en la creaci\u00f3n de facturas de manera eficiente, aprender\u00e1n a utilizar las poderosas funciones de Excel, como FILA y SECUENCIA, para automatizar la numeraci\u00f3n de celdas, simplificando as\u00ed el proceso de creaci\u00f3n de facturas, adicional a esto les dar\u00e9 unos tips para que puedan adicionar un prefijo a la numeraci\u00f3n, definir el inicio de la numeraci\u00f3n e incluso evitar que  provecho a Excel.<\/p>\n","protected":false},"author":4,"featured_media":20967,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"video","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52],"tags":[561,1960,529,2819],"class_list":["post-20965","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-hojas-de-calculo","tag-keysfan","tag-sheets","tag-tutorial-excel","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Numeraci\u00f3n autom\u00e1tica en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a crear numeraci\u00f3n autom\u00e1tica en Excel con prefijos personalizados usando las funciones FILA y SECUENCIA.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Numeraci\u00f3n autom\u00e1tica en Excel de forma sencilla\" \/>\n<meta property=\"og:description\" content=\"Aprende a utilizar la numeraci\u00f3n autom\u00e1tica en Excel con m\u00e9todos sencillos que reducir\u00e1n errores en tus registros.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-25T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T06:12:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Numeraci\u00f3n autom\u00e1tica en Excel: Dos m\u00e9todos f\u00e1ciles\" \/>\n<meta name=\"twitter:description\" content=\"Descubre c\u00f3mo lograr la numeraci\u00f3n autom\u00e1tica en Excel y optimiza la organizaci\u00f3n de tus datos de manera eficiente.\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"Numeraci\u00f3n autom\u00e1tica en Excel\",\"datePublished\":\"2024-01-25T17:30:00+00:00\",\"dateModified\":\"2025-04-02T06:12:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/\"},\"wordCount\":648,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg\",\"keywords\":[\"Hojas de c\u00e1lculo\",\"Keysfan\",\"Sheets\",\"Tutorial Excel\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/\",\"name\":\"Numeraci\u00f3n autom\u00e1tica en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg\",\"datePublished\":\"2024-01-25T17:30:00+00:00\",\"dateModified\":\"2025-04-02T06:12:46+00:00\",\"description\":\"Aprende a crear numeraci\u00f3n autom\u00e1tica en Excel con prefijos personalizados usando las funciones FILA y SECUENCIA.\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg\",\"width\":500,\"height\":375,\"caption\":\"miniatura celdas auto numeradas excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Numeraci\u00f3n autom\u00e1tica en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\",\"url\":\"https:\/\/dostinhurtado.com\/site\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\/\/dostinhurtado.com\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/moderador\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Numeraci\u00f3n autom\u00e1tica en Excel - Dostin Hurtado","description":"Aprende a crear numeraci\u00f3n autom\u00e1tica en Excel con prefijos personalizados usando las funciones FILA y SECUENCIA.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/","og_locale":"es_ES","og_type":"article","og_title":"Numeraci\u00f3n autom\u00e1tica en Excel de forma sencilla","og_description":"Aprende a utilizar la numeraci\u00f3n autom\u00e1tica en Excel con m\u00e9todos sencillos que reducir\u00e1n errores en tus registros.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/","og_site_name":"Dostin Hurtado","article_published_time":"2024-01-25T17:30:00+00:00","article_modified_time":"2025-04-02T06:12:46+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Numeraci\u00f3n autom\u00e1tica en Excel: Dos m\u00e9todos f\u00e1ciles","twitter_description":"Descubre c\u00f3mo lograr la numeraci\u00f3n autom\u00e1tica en Excel y optimiza la organizaci\u00f3n de tus datos de manera eficiente.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"Numeraci\u00f3n autom\u00e1tica en Excel","datePublished":"2024-01-25T17:30:00+00:00","dateModified":"2025-04-02T06:12:46+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/"},"wordCount":648,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg","keywords":["Hojas de c\u00e1lculo","Keysfan","Sheets","Tutorial Excel"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/","name":"Numeraci\u00f3n autom\u00e1tica en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg","datePublished":"2024-01-25T17:30:00+00:00","dateModified":"2025-04-02T06:12:46+00:00","description":"Aprende a crear numeraci\u00f3n autom\u00e1tica en Excel con prefijos personalizados usando las funciones FILA y SECUENCIA.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg","width":500,"height":375,"caption":"miniatura celdas auto numeradas excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/celdas-con-numeracion-automatica\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Numeraci\u00f3n autom\u00e1tica en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel-300x225.jpg",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel-400x375.jpg",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel.jpg",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/01\/miniatura-celdas-auto-numeradas-excel-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":0,"uagb_excerpt":"\u00bfQuieren aprender a crear celdas auto numerables en Excel? En este tutorial enfocado en la creaci\u00f3n de facturas de manera eficiente, aprender\u00e1n a utilizar las poderosas funciones de Excel, como FILA y SECUENCIA, para automatizar la numeraci\u00f3n de celdas, simplificando as\u00ed el proceso de creaci\u00f3n de facturas, adicional a esto les dar\u00e9 unos tips para&hellip;","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=20965"}],"version-history":[{"count":2,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20965\/revisions"}],"predecessor-version":[{"id":24648,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20965\/revisions\/24648"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/20967"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=20965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=20965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=20965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}