{"id":11826,"date":"2022-07-27T11:21:42","date_gmt":"2022-07-27T11:21:42","guid":{"rendered":"https:\/\/excelfull.com\/?p=11826"},"modified":"2022-10-10T01:57:30","modified_gmt":"2022-10-10T01:57:30","slug":"seleccionar-filas-y-columnas","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/","title":{"rendered":"SELECCIONAR FILAS Y COLUMNAS"},"content":{"rendered":"\r\n<p class=\"has-text-align-center has-medium-font-size\" style=\"text-align: center;\"><strong>Al navegar en una hoja de Excel con datos grandes, seleccionar filas y columnas es una funci\u00f3n muy com\u00fan, es una tarea muy b\u00e1sica pero importante.<\/strong><\/p>\r\n\r\n\r\n\r\n<p>En esta entrada, aprenderemos c\u00f3mo seleccionar celdas y rangos de una columna completa en Excel y c\u00f3mo seleccionar una fila completa o una tabla.<\/p><div id=\"excel-3946203414\" 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>\r\n\r\n\r\n\r\n<p class=\"has-text-align-center has-medium-font-size\" style=\"text-align: center;\"><span style=\"color: #003300;\"><strong>PARTE DOS: SELECCIONES MASIVAS<\/strong><\/span><\/p>\r\n\r\n\r\n\r\n<h6 class=\"wp-block-preformatted\" style=\"text-align: center;\"><strong>SELECCIONAR FILAS Y COLUMNAS ENTERAS<\/strong><\/h6>\r\n\r\n\r\n\r\n<p><strong><em>Utilizando el rat\u00f3n: <\/em><\/strong>Hacemos clic en el encabezado de la Fila o Columna y de esa manera seleccionamos todas las celdas que est\u00e1n incluidas de ella.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png\"><img decoding=\"async\" class=\"wp-image-11827\" src=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png\" alt=\"\" \/><\/a><\/figure>\r\n\r\n\r\n\r\n<div class=\"wp-block-spacer\" style=\"height: 44px;\" aria-hidden=\"true\">\u00a0<\/div>\r\n\r\n\r\n\r\n<p>Si queremos seleccionar varias filas o columnas, hacemos clic y arrastramos desde el primer encabezado de fila o columna hasta el \u00faltimo.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/filas-enteras.png\"><img decoding=\"async\" class=\"wp-image-11828\" src=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/filas-enteras.png\" alt=\"\" \/><\/a><\/figure>\r\n\r\n\r\n\r\n<div class=\"wp-block-spacer\" style=\"height: 44px;\" aria-hidden=\"true\">\u00a0<\/div>\r\n\r\n\r\n\r\n<p><strong><em>Utilizando el teclado: <\/em><\/strong>Aunque podemos seleccionar una columna o fila con tan solo hacer clic sobre el encabezado, en ocasiones se puede facilitar hacer la selecci\u00f3n con el teclado de la siguiente manera:<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-group is-nowrap is-layout-flex wp-container-core-group-is-layout-ad2f72ca wp-block-group-is-layout-flex\">\r\n<p><strong>May\u00fas + Barra espaciadora:<\/strong> seleccionar\u00e1 toda una fila sin importar su contenido.<\/p>\r\n\r\n\r\n\r\n<p><strong>Ctrl + Barra espaciadora<\/strong>: seleccionar\u00e1 toda una columna sin importar su contenido.<\/p>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-spacer\" style=\"height: 41px;\" aria-hidden=\"true\">\u00a0<\/div>\r\n\r\n\r\n\r\n<p>Si deseamos seleccionar las columnas o filas adyacentes, usamos <strong><em>May\u00fas + tecla flecha<\/em><\/strong> para seleccionar columnas completas a la izquierda o derecha, o filas de arriba o abajo. Podemos ir en cualquier direcci\u00f3n, pero no podemos seleccionar ambos lados de la columna o fila.<\/p>\r\n\r\n\r\n\r\n<p>Si deseamos seleccionar filas o columnas que no est\u00e1n unidas mantenemos presionada la tecla <strong>Ctrl <\/strong>y hacemos clic con el bot\u00f3n izquierdo en cada fila o columna que se desea incluir.<\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras-no-adyacentes.png\"><img decoding=\"async\" class=\"wp-image-11829\" src=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras-no-adyacentes.png\" alt=\"\" \/><\/a><\/figure>\r\n<\/div>\r\n\r\n\r\n<div class=\"wp-block-spacer\" style=\"height: 44px;\" aria-hidden=\"true\">\u00a0<\/div>\r\n\r\n\r\n\r\n<h6 class=\"wp-block-preformatted\" style=\"text-align: center;\"><strong>SELECCIONAR TODA UN \u00c1REA DE CELDAS<\/strong><\/h6>\r\n\r\n\r\n\r\n<p>Si necesitamos seleccionar un \u00e1rea muy grande de celdas podemos hacerlo con una sola combinaci\u00f3n de teclas. Solo debemos activar cualquier celda dentro del rango a seleccionar y pulsamos la combinaci\u00f3n <strong><em>Ctrl + E.<\/em><\/strong><\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/area-de-celdas.png\"><img decoding=\"async\" class=\"wp-image-11830\" src=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/area-de-celdas.png\" alt=\"\" \/><\/a><\/figure>\r\n<\/div>\r\n\r\n\r\n<div class=\"wp-block-spacer\" style=\"height: 44px;\" aria-hidden=\"true\">\u00a0<\/div>\r\n\r\n\r\n\r\n<h6 class=\"wp-block-preformatted\" style=\"text-align: center;\"><strong>SELECCIONAR HASTA EL FINAL<\/strong><\/h6>\r\n\r\n\r\n\r\n<p>Cuando trabajamos con una fila o columna larga, es posible que debamos seleccionar toda la columna o fila con datos para un prop\u00f3sito. Las siguientes teclas de m\u00e9todo abreviado nos ayudan a extender la selecci\u00f3n al final de la columna o fila en Excel.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-group alignwide is-nowrap is-layout-flex wp-container-core-group-is-layout-ad2f72ca wp-block-group-is-layout-flex\">\r\n<p class=\"has-text-align-center\"><strong>May\u00fas + Ctrl + \u2192<\/strong> Selecciona todas las celdas a la derecha<\/p>\r\n\r\n\r\n\r\n<p class=\"has-text-align-center\"><strong>May\u00fas + Ctrl + \u2190<\/strong> Selecciona todas las celdas a la izquierda<\/p>\r\n\r\n\r\n\r\n<p class=\"has-text-align-center\"><strong>May\u00fas + Ctrl + \u2191<\/strong> Selecciona todas las celdas hacia arriba<\/p>\r\n\r\n\r\n\r\n<p class=\"has-text-align-center\"><strong>May\u00fas + Ctrl + \u2193<\/strong> Selecciona todas las celdas hacia abajo<\/p>\r\n\r\n\r\n\r\n<p class=\"has-text-align-center\"><strong>May\u00fas + Rep\u00e1g <\/strong>: Selecciona un bloque de filas hacia arriba May\u00fas + Avp\u00e1g : Selecciona un bloque de filas hacia abajo<\/p>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-spacer\" style=\"height: 44px;\" aria-hidden=\"true\">\u00a0<\/div>\r\n\r\n\r\n\r\n<h6 class=\"wp-block-preformatted\" style=\"text-align: center;\"><strong>SELECCIONAR TODAS LAS CELDAS DE UNA HOJA<\/strong><\/h6>\r\n\r\n\r\n\r\n<p>Incluso es posible seleccionar la hoja de c\u00e1lculo de Excel completa haciendo clic en el bot\u00f3n <strong><em>Seleccionar Todo<\/em><\/strong> que se encuentra a la izquierda de los encabezados de las columnas y encima de los encabezados de las filas como se muestra en la imagen siguiente.<\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/toda-la-hoja.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11831\" src=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/toda-la-hoja.png\" alt=\"\r\n\" width=\"820\" height=\"654\" \/><\/a>\r\n<figcaption>Tambien puedes usar el atajo del teclado <em><strong>Ctrl + E.<\/strong><\/em><\/figcaption>\r\n<\/figure>\r\n<\/div>\r\n\r\n\r\n<div class=\"wp-block-spacer\" style=\"height: 53px;\" aria-hidden=\"true\"><hr \/>\r\n<p>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\r\n<p>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\r\n<p>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <span style=\"color: #008000;\"><a style=\"color: #008000;\" href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/span><\/p>\r\n<hr \/>\r\n<p>&nbsp;<\/p>\r\n<\/div>\r\n\r\n\r\n\r\n<ul class=\"wp-block-social-links is-layout-flex wp-block-social-links-is-layout-flex\"><li class=\"wp-social-link wp-social-link-facebook  wp-block-social-link\"><a href=\"https:\/\/www.facebook.com\/excelfull7\" class=\"wp-block-social-link-anchor\"><svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M12 2C6.5 2 2 6.5 2 12c0 5 3.7 9.1 8.4 9.9v-7H7.9V12h2.5V9.8c0-2.5 1.5-3.9 3.8-3.9 1.1 0 2.2.2 2.2.2v2.5h-1.3c-1.2 0-1.6.8-1.6 1.6V12h2.8l-.4 2.9h-2.3v7C18.3 21.1 22 17 22 12c0-5.5-4.5-10-10-10z\"><\/path><\/svg><span class=\"wp-block-social-link-label screen-reader-text\">Facebook<\/span><\/a><\/li>\r\n\r\n<li class=\"wp-social-link wp-social-link-instagram  wp-block-social-link\"><a href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\" class=\"wp-block-social-link-anchor\"><svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M12,4.622c2.403,0,2.688,0.009,3.637,0.052c0.877,0.04,1.354,0.187,1.671,0.31c0.42,0.163,0.72,0.358,1.035,0.673 c0.315,0.315,0.51,0.615,0.673,1.035c0.123,0.317,0.27,0.794,0.31,1.671c0.043,0.949,0.052,1.234,0.052,3.637 s-0.009,2.688-0.052,3.637c-0.04,0.877-0.187,1.354-0.31,1.671c-0.163,0.42-0.358,0.72-0.673,1.035 c-0.315,0.315-0.615,0.51-1.035,0.673c-0.317,0.123-0.794,0.27-1.671,0.31c-0.949,0.043-1.233,0.052-3.637,0.052 s-2.688-0.009-3.637-0.052c-0.877-0.04-1.354-0.187-1.671-0.31c-0.42-0.163-0.72-0.358-1.035-0.673 c-0.315-0.315-0.51-0.615-0.673-1.035c-0.123-0.317-0.27-0.794-0.31-1.671C4.631,14.688,4.622,14.403,4.622,12 s0.009-2.688,0.052-3.637c0.04-0.877,0.187-1.354,0.31-1.671c0.163-0.42,0.358-0.72,0.673-1.035 c0.315-0.315,0.615-0.51,1.035-0.673c0.317-0.123,0.794-0.27,1.671-0.31C9.312,4.631,9.597,4.622,12,4.622 M12,3 C9.556,3,9.249,3.01,8.289,3.054C7.331,3.098,6.677,3.25,6.105,3.472C5.513,3.702,5.011,4.01,4.511,4.511 c-0.5,0.5-0.808,1.002-1.038,1.594C3.25,6.677,3.098,7.331,3.054,8.289C3.01,9.249,3,9.556,3,12c0,2.444,0.01,2.751,0.054,3.711 c0.044,0.958,0.196,1.612,0.418,2.185c0.23,0.592,0.538,1.094,1.038,1.594c0.5,0.5,1.002,0.808,1.594,1.038 c0.572,0.222,1.227,0.375,2.185,0.418C9.249,20.99,9.556,21,12,21s2.751-0.01,3.711-0.054c0.958-0.044,1.612-0.196,2.185-0.418 c0.592-0.23,1.094-0.538,1.594-1.038c0.5-0.5,0.808-1.002,1.038-1.594c0.222-0.572,0.375-1.227,0.418-2.185 C20.99,14.751,21,14.444,21,12s-0.01-2.751-0.054-3.711c-0.044-0.958-0.196-1.612-0.418-2.185c-0.23-0.592-0.538-1.094-1.038-1.594 c-0.5-0.5-1.002-0.808-1.594-1.038c-0.572-0.222-1.227-0.375-2.185-0.418C14.751,3.01,14.444,3,12,3L12,3z M12,7.378 c-2.552,0-4.622,2.069-4.622,4.622S9.448,16.622,12,16.622s4.622-2.069,4.622-4.622S14.552,7.378,12,7.378z M12,15 c-1.657,0-3-1.343-3-3s1.343-3,3-3s3,1.343,3,3S13.657,15,12,15z M16.804,6.116c-0.596,0-1.08,0.484-1.08,1.08 s0.484,1.08,1.08,1.08c0.596,0,1.08-0.484,1.08-1.08S17.401,6.116,16.804,6.116z\"><\/path><\/svg><span class=\"wp-block-social-link-label screen-reader-text\">Instagram<\/span><\/a><\/li><\/ul>\r\n","protected":false},"excerpt":{"rendered":"<p>Al navegar en una hoja &#8230; <a title=\"SELECCIONAR FILAS Y COLUMNAS\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/\" aria-label=\"Leer m\u00e1s sobre SELECCIONAR FILAS Y COLUMNAS\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","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":[454,328,346],"tags":[],"class_list":["post-11826","post","type-post","status-publish","format-standard","hentry","category-el-entorno-de-excel","category-excel","category-excel-basico","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 FILAS Y COLUMNAS - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"Al navegar en una hoja de Excel con datos grandes, seleccionar filas y columnas es una funci\u00f3n muy com\u00fan, pero importante.\" \/>\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-filas-y-columnas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SELECCIONAR FILAS Y COLUMNAS - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"Al navegar en una hoja de Excel con datos grandes, seleccionar filas y columnas es una funci\u00f3n muy com\u00fan, pero importante.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/\" \/>\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-07-27T11:21:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-10T01:57:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.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=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"SELECCIONAR FILAS Y COLUMNAS\",\"datePublished\":\"2022-07-27T11:21:42+00:00\",\"dateModified\":\"2022-10-10T01:57:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/\"},\"wordCount\":506,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png\",\"articleSection\":[\"El Entorno de Excel\",\"Excel\",\"Excel B\u00e1sico\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/\",\"url\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/\",\"name\":\"SELECCIONAR FILAS Y COLUMNAS - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png\",\"datePublished\":\"2022-07-27T11:21:42+00:00\",\"dateModified\":\"2022-10-10T01:57:30+00:00\",\"description\":\"Al navegar en una hoja de Excel con datos grandes, seleccionar filas y columnas es una funci\u00f3n muy com\u00fan, pero importante.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png\",\"contentUrl\":\"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#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 FILAS Y COLUMNAS\"}]},{\"@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 FILAS Y COLUMNAS - EXCELFULL.COM","description":"Al navegar en una hoja de Excel con datos grandes, seleccionar filas y columnas es una funci\u00f3n muy com\u00fan, pero importante.","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-filas-y-columnas\/","og_locale":"es_ES","og_type":"article","og_title":"SELECCIONAR FILAS Y COLUMNAS - EXCELFULL.COM","og_description":"Al navegar en una hoja de Excel con datos grandes, seleccionar filas y columnas es una funci\u00f3n muy com\u00fan, pero importante.","og_url":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2022-07-27T11:21:42+00:00","article_modified_time":"2022-10-10T01:57:30+00:00","og_image":[{"url":"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png","type":"","width":"","height":""}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"SELECCIONAR FILAS Y COLUMNAS","datePublished":"2022-07-27T11:21:42+00:00","dateModified":"2022-10-10T01:57:30+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/"},"wordCount":506,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png","articleSection":["El Entorno de Excel","Excel","Excel B\u00e1sico"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/","url":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/","name":"SELECCIONAR FILAS Y COLUMNAS - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png","datePublished":"2022-07-27T11:21:42+00:00","dateModified":"2022-10-10T01:57:30+00:00","description":"Al navegar en una hoja de Excel con datos grandes, seleccionar filas y columnas es una funci\u00f3n muy com\u00fan, pero importante.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#primaryimage","url":"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png","contentUrl":"https:\/\/excelfull.com\/wp-content\/uploads\/2022\/07\/columnas-enteras.png"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/seleccionar-filas-y-columnas\/#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 FILAS Y COLUMNAS"}]},{"@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\/11826","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=11826"}],"version-history":[{"count":10,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/11826\/revisions"}],"predecessor-version":[{"id":15688,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/11826\/revisions\/15688"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=11826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=11826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=11826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}