{"id":11853,"date":"2022-08-09T00:08:21","date_gmt":"2022-08-09T00:08:21","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=11853"},"modified":"2023-12-06T16:05:27","modified_gmt":"2023-12-06T19:05:27","slug":"seleccionar-celdas-en-blanco","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/","title":{"rendered":"SELECCIONAR CELDAS EN BLANCO"},"content":{"rendered":"<p style=\"text-align: center;\"><strong>Siguiendo el hilo de las entradas anteriores, hoy aprenderemos c\u00f3mo seleccionar celdas en blanco con tan s\u00f3lo algunos clics.<\/strong><\/p>\n<p style=\"text-align: center;\"><span style=\"color: #339966;\"><strong>PARTE TRES: SELECCI\u00d3N DE CELDAS EN BLANCO<\/strong><\/span><\/p><div id=\"excel-124872182\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>En ocasiones, dentro de una columna o rango de datos nos interesa seleccionar celdas en blanco; en lugar de seleccionar celda por celda, podemos hacerlo de forma masiva y utilizando comandos mas r\u00e1pidos.<\/p>\n<ol>\n<li><strong>SELECCION DE CELDAS EN BLANCO DENTRO DE UN RANGO DE DATOS. <\/strong><\/li>\n<\/ol>\n<p>Debemos empezar por seleccionar el rango que contiene las celdas vac\u00edas.<\/p>\n<p>En la pesta\u00f1a <em><strong>Inicio<\/strong><\/em>, hacemos clic en el bot\u00f3n <em><strong>Buscar y Seleccionar<\/strong><\/em> del grupo <em><strong>Edici\u00f3n.<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11861 \" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/ir-a-e1659902970752-1024x529.png\" alt=\"\" width=\"670\" height=\"346\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/ir-a-e1659902970752-1024x529.png 1024w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/ir-a-e1659902970752-300x155.png 300w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/ir-a-e1659902970752-768x397.png 768w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/ir-a-e1659902970752.png 1366w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/p>\n<p>Se abrir\u00e1 entonces una ventana de opciones llamada <em><strong>Ir a Especial<\/strong><\/em>, donde podemos escoger qu\u00e9 queremos seleccionar. Aqu\u00ed, elegimos la opci\u00f3n <em><strong>Celdas en blanco<\/strong> <\/em>que aparecer\u00e1 en la columna de la izquierda.<\/p>\n<p style=\"text-align: center;\">\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11863 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/celdas-en-blanco.png\" alt=\"\" width=\"459\" height=\"327\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/celdas-en-blanco.png 459w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/celdas-en-blanco-300x214.png 300w\" sizes=\"auto, (max-width: 459px) 100vw, 459px\" \/><\/p>\n<p>Al pulsar <em><strong>Aceptar<\/strong><\/em> se seleccionar\u00e1n las celdas en blanco dentro del rango seleccionado previamente.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11864 \" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/rango-seleccionado.png\" alt=\"\" width=\"647\" height=\"411\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/rango-seleccionado.png 811w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/rango-seleccionado-300x191.png 300w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/rango-seleccionado-768x488.png 768w\" sizes=\"auto, (max-width: 647px) 100vw, 647px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong><em>Tip:<\/em> <\/strong><\/span>Otra manera de abrir el cuadro de di\u00e1logo <em><strong>Ir a Especial<\/strong><\/em> es oprimiendo <em><strong>F5<\/strong><\/em> o con la combinaci\u00f3n de teclas <em><strong>CTRL+I<\/strong><\/em><\/p>\n<p><strong>2. SELECCION DE TODAS LAS CELDAS EN BLANCO.<\/strong><\/p>\n<p>Para seleccionar todas las celdas en blanco de nuestra hoja de c\u00e1lculo, realizaremos el mismo procedimiento, pero en este caso no seleccionaremos previamente nuestro rango de datos, sino que lo haremos sin tener en cuenta ninguna selecci\u00f3n.<\/p>\n<p>De esta forma, se seleccionan todas las celdas que han quedado vac\u00edas y que se encuentran fuera de nuestra regi\u00f3n de trabajo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11865 \" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-todas-las-celdas-en-blanco-1024x392.png\" alt=\"\" width=\"687\" height=\"263\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-todas-las-celdas-en-blanco-1024x392.png 1024w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-todas-las-celdas-en-blanco-300x115.png 300w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-todas-las-celdas-en-blanco-768x294.png 768w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-todas-las-celdas-en-blanco.png 1338w\" sizes=\"auto, (max-width: 687px) 100vw, 687px\" \/><\/p>\n<p style=\"text-align: center;\"><strong>Como hemos visto en estas tres entradas, seleccionar celdas es una habilidad importante. Casi toda la informaci\u00f3n en Excel es guardada en una celda o rango de celdas, as\u00ed que antes de ingresar, editar o dar formato a nuestros datos, es necesario saber c\u00f3mo seleccionar una celda o rango de celdas.<\/strong><\/p>\n<ul>\n<li><strong>Tambi\u00e9n te puede interesar:<\/strong> <a href=\"https:\/\/excelfull.com\/excel\/la-celda-en-excel\/\">\u00bfQu\u00e9 es una celda en Excel?<\/a><\/li>\n<\/ul>\n<p>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <a href=\"https:\/\/www.facebook.com\/excelfull7\"><span style=\"color: #3366ff;\">Facebook<\/span><\/a> e <a href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><span style=\"color: #ff00ff;\">Instagram<\/span><\/a>.<\/p>\n<p>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/excelfull.com\/\">Curso de Excel Online<\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Siguiendo el hilo de las &#8230; <a title=\"SELECCIONAR CELDAS EN BLANCO\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/\" aria-label=\"Leer m\u00e1s sobre SELECCIONAR CELDAS EN BLANCO\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":11858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"quote","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[757,328,346,486],"tags":[347,348],"class_list":["post-11853","post","type-post","status-publish","format-quote","has-post-thumbnail","hentry","category-celdas","category-excel","category-excel-basico","category-operaciones-basicas","tag-excel-basico","tag-seleccionar-celdas","post_format-post-format-quote","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SELECCIONAR CELDAS EN BLANCO - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"En ocasiones, nos interesa seleccionar celdas en blanco dentro de un rango de datos, hoy aprenderemos a hacerlo con unos cuantos clics.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SELECCIONAR CELDAS EN BLANCO - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"En ocasiones, nos interesa seleccionar celdas en blanco dentro de un rango de datos, hoy aprenderemos a hacerlo con unos cuantos clics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-09T00:08:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T19:05:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1345\" \/>\n\t<meta property=\"og:image:height\" content=\"681\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"SELECCIONAR CELDAS EN BLANCO\",\"datePublished\":\"2022-08-09T00:08:21+00:00\",\"dateModified\":\"2023-12-06T19:05:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/\"},\"wordCount\":354,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png\",\"keywords\":[\"excel b\u00e1sico\",\"seleccionar celdas\"],\"articleSection\":[\"Celdas\",\"Excel\",\"Excel B\u00e1sico\",\"Operaciones B\u00e1sicas\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/\",\"url\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/\",\"name\":\"SELECCIONAR CELDAS EN BLANCO - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png\",\"datePublished\":\"2022-08-09T00:08:21+00:00\",\"dateModified\":\"2023-12-06T19:05:27+00:00\",\"description\":\"En ocasiones, nos interesa seleccionar celdas en blanco dentro de un rango de datos, hoy aprenderemos a hacerlo con unos cuantos clics.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png\",\"width\":1345,\"height\":681,\"caption\":\"seleccionar celdas en blanco\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SELECCIONAR CELDAS EN BLANCO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SELECCIONAR CELDAS EN BLANCO - EXCELFULL.COM","description":"En ocasiones, nos interesa seleccionar celdas en blanco dentro de un rango de datos, hoy aprenderemos a hacerlo con unos cuantos clics.","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:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/","og_locale":"es_ES","og_type":"article","og_title":"SELECCIONAR CELDAS EN BLANCO - EXCELFULL.COM","og_description":"En ocasiones, nos interesa seleccionar celdas en blanco dentro de un rango de datos, hoy aprenderemos a hacerlo con unos cuantos clics.","og_url":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2022-08-09T00:08:21+00:00","article_modified_time":"2023-12-06T19:05:27+00:00","og_image":[{"width":1345,"height":681,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"SELECCIONAR CELDAS EN BLANCO","datePublished":"2022-08-09T00:08:21+00:00","dateModified":"2023-12-06T19:05:27+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/"},"wordCount":354,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png","keywords":["excel b\u00e1sico","seleccionar celdas"],"articleSection":["Celdas","Excel","Excel B\u00e1sico","Operaciones B\u00e1sicas"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/","url":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/","name":"SELECCIONAR CELDAS EN BLANCO - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png","datePublished":"2022-08-09T00:08:21+00:00","dateModified":"2023-12-06T19:05:27+00:00","description":"En ocasiones, nos interesa seleccionar celdas en blanco dentro de un rango de datos, hoy aprenderemos a hacerlo con unos cuantos clics.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/seleccionar-celdas-en-blanco.png","width":1345,"height":681,"caption":"seleccionar celdas en blanco"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/seleccionar-celdas-en-blanco\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"SELECCIONAR CELDAS EN BLANCO"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/11853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=11853"}],"version-history":[{"count":15,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/11853\/revisions"}],"predecessor-version":[{"id":13713,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/11853\/revisions\/13713"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/11858"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=11853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=11853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=11853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}