{"id":15632,"date":"2024-03-05T21:50:56","date_gmt":"2024-03-06T00:50:56","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=15632"},"modified":"2024-03-05T21:52:46","modified_gmt":"2024-03-06T00:52:46","slug":"bloquear-rangos-en-una-hoja-protegida","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/","title":{"rendered":"BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #136e42;\"><strong><u>CONTROL TOTAL EN EXCEL: RESGUARDA TUS DATOS CON ESTAS ESTRATEGIAS PARA BLOQUEAR CELDAS Y RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA<\/u><\/strong><\/span><\/p><div id=\"excel-3018652520\" 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 Excel, donde la manipulaci\u00f3n de datos y la creaci\u00f3n de informes son moneda corriente, la protecci\u00f3n de informaci\u00f3n sensible se vuelve primordial. Sin embargo, en lugar de cerrar completamente el acceso a nuestras hojas de c\u00e1lculo, \u00bfqu\u00e9 tal si pudi\u00e9ramos otorgar permisos selectivos a determinados usuarios para editar solo ciertos rangos de datos? Es aqu\u00ed donde entra en juego la funci\u00f3n de bloqueo de rangos en Excel.<\/p>\n<p>En este art\u00edculo, exploraremos c\u00f3mo aprovechar al m\u00e1ximo esta caracter\u00edstica, permiti\u00e9ndote mantener el control sobre qui\u00e9n puede modificar qu\u00e9 partes de tus hojas de c\u00e1lculo. Desde la creaci\u00f3n de informes colaborativos hasta la gesti\u00f3n eficiente de proyectos, descubre c\u00f3mo el bloquear celdas y rangos espec\u00edficos en Excel se convierte en tu herramienta fundamental para asegurar la integridad de tus datos mientras fomentas la colaboraci\u00f3n entre equipos.<\/p>\n<h2>BLOQUEAR S\u00d3LO CELDAS Y RANGOS ESPEC\u00cdFICOS EN UNA HOJA DE C\u00c1LCULO PROTEGIDA<\/h2>\n<p>Por defecto, la protecci\u00f3n de una hoja de c\u00e1lculo bloquea todas las celdas, impidiendo que se puedan editar. Sin embargo, es posible desbloquear todas las celdas para permitir la edici\u00f3n de algunas y mantener otras bloqueadas. Asimismo, se puede bloquear celdas y rangos espec\u00edficos antes de proteger la hoja de c\u00e1lculo, y si se deseas, permitir que ciertos usuarios puedan editar \u00fanicamente en rangos espec\u00edficos dentro de una hoja protegida.<\/p>\n<p>1. Si la hoja de c\u00e1lculo est\u00e1 protegida, sigue estos pasos:<\/p>\n<p style=\"padding-left: 40px;\">a. En la pesta\u00f1a<strong> \u00abRevisar\u00bb<\/strong>, selecciona <strong>\u00abDesproteger hoja\u00bb<\/strong> en el grupo <strong>\u00abProteger\u00bb<\/strong>.<\/p>\n<p style=\"padding-left: 40px;\">Selecciona <strong>\u00abProteger hoja\u00bb<\/strong> para cambiar a <strong>\u00abDesproteger hoja\u00bb<\/strong> cuando la hoja est\u00e9 protegida.<\/p>\n<p style=\"padding-left: 40px;\">b. Si se te solicita, ingresa la contrase\u00f1a para desproteger la hoja de c\u00e1lculo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15619\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/proteger-hoja-3.png\" alt=\"\" width=\"408\" height=\"203\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>2. Selecciona toda tu hoja de c\u00e1lculo haciendo clic en <strong>\u00abSeleccionar todo\u00bb<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15633\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/bloq-rangos-1.jpg\" alt=\"\" width=\"237\" height=\"181\" \/><\/p>\n<p>3. Luego, haz clic derecho y selecciona la opci\u00f3n <strong>\u00abFormato de Celdas\u00bb<\/strong> en el men\u00fa contextual.<\/p>\n<p>4. En el cuadro de di\u00e1logo <strong>\u00abFormato de celdas\u00bb<\/strong>, ve a la pesta\u00f1a <strong>\u00abProteger\u00bb<\/strong>, desmarca la casilla <strong>\u00abBloqueada\u00bb<\/strong> y luego haz clic en <strong>\u00abAceptar\u00bb<\/strong>. Con esto, se desbloquear\u00e1n todas las celdas de tu hoja de c\u00e1lculo cuando la protejas. Ahora, puedes seleccionar las celdas que desees bloquear espec\u00edficamente.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15609 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/ocultar-form-1.png\" alt=\"BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA\" width=\"557\" height=\"462\" \/><\/p>\n<p>4. En la hoja de c\u00e1lculo, selecciona solo las celdas y rangos espec\u00edficos que quieras bloquear.<\/p>\n<p>5. Abre nuevamente el cuadro de di\u00e1logo <strong>\u00abFormato de celdas\u00bb<\/strong> <strong>(Ctrl+May\u00fas+F)<\/strong>.<\/p>\n<p>6. Esta vez, en la pesta\u00f1a \u00ab<strong>Proteger\u00bb<\/strong>, marca la casilla <strong>\u00abBloqueada\u00bb<\/strong> y luego haz clic en <strong>\u00abAceptar\u00bb<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15634\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/bloq-rangos-2.png\" alt=\"\" width=\"554\" height=\"461\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>7. En la pesta\u00f1a <strong>\u00abRevisar\u00bb<\/strong>, selecciona <strong>\u00abProteger hoja\u00bb<\/strong>. En la lista <strong>\u00abPermitir que todos los usuarios de esta hoja de c\u00e1lculo\u00bb, <\/strong>elige los elementos que quieras que los usuarios puedan cambiar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15610\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/ocultar-form-2.png\" alt=\"\" width=\"283\" height=\"306\" \/><\/p>\n<p>8. En el cuadro<strong> \u00abContrase\u00f1a para desproteger la hoja\u00bb<\/strong>, ingresa una contrase\u00f1a para la hoja, haz clic en <strong>\u00abAceptar\u00bb<\/strong> y luego vuelve a ingresar la contrase\u00f1a para confirmarla.<\/p>\n<ul>\n<li>La contrase\u00f1a es opcional. Si no proporcionas una contrase\u00f1a, cualquier usuario puede desproteger la hoja y cambiar los elementos protegidos.<\/li>\n<li>Aseg\u00farate de elegir una contrase\u00f1a que sea f\u00e1cil de recordar, porque si la pierdes, Microsoft no la puede recuperar.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15635 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/bloq-rangos-3.png\" alt=\"BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA\" width=\"406\" height=\"314\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>CONCLUSI\u00d3N<\/h2>\n<p>El bloqueo selectivo de celdas y rangos en Excel ofrece un nivel de control sin precedentes sobre tus hojas de c\u00e1lculo, permiti\u00e9ndote proteger tu informaci\u00f3n sensible mientras fomentas la colaboraci\u00f3n y la edici\u00f3n colaborativa. Al seguir los pasos detallados en este art\u00edculo, has aprendido c\u00f3mo bloquear celdas espec\u00edficas y permitir el acceso restringido a determinados usuarios, lo que te brinda una mayor seguridad y tranquilidad en el manejo de tus datos.<\/p>\n<hr \/>\n<blockquote><p><strong><span style=\"color: #136e42;\">\u00bb <\/span>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\">Facebook<\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\">Instagram<\/a>.<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\">Curso de Excel Online<\/a><\/strong><\/p><\/blockquote>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; CONTROL TOTAL EN EXCEL: &#8230; <a title=\"BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/\" aria-label=\"Leer m\u00e1s sobre BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":15636,"comment_status":"open","ping_status":"open","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":[743,328,593],"tags":[805,739,804],"class_list":["post-15632","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-colaborar-y-compartir","category-excel","category-herramientas","tag-bloquear","tag-contrasena","tag-proteger","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>BLOQUEAR RANGOS EN UNA HOJA PROTEGIDA<\/title>\n<meta name=\"description\" content=\"Puedes bloquear rangos espec\u00edficos y permitir que ciertos usuarios editen \u00fanicamente en rangos espec\u00edficos dentro de una hoja protegida.\" \/>\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\/bloquear-rangos-en-una-hoja-protegida\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BLOQUEAR RANGOS EN UNA HOJA PROTEGIDA\" \/>\n<meta property=\"og:description\" content=\"Puedes bloquear rangos espec\u00edficos y permitir que ciertos usuarios editen \u00fanicamente en rangos espec\u00edficos dentro de una hoja protegida.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/\" \/>\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=\"2024-03-06T00:50:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-06T00:52:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\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=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA\",\"datePublished\":\"2024-03-06T00:50:56+00:00\",\"dateModified\":\"2024-03-06T00:52:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/\"},\"wordCount\":684,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png\",\"keywords\":[\"bloquear\",\"contrase\u00f1a\",\"proteger\"],\"articleSection\":[\"Colaborar y Compartir\",\"Excel\",\"Herramientas\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/\",\"url\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/\",\"name\":\"BLOQUEAR RANGOS EN UNA HOJA PROTEGIDA\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png\",\"datePublished\":\"2024-03-06T00:50:56+00:00\",\"dateModified\":\"2024-03-06T00:52:46+00:00\",\"description\":\"Puedes bloquear rangos espec\u00edficos y permitir que ciertos usuarios editen \u00fanicamente en rangos espec\u00edficos dentro de una hoja protegida.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#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\":\"BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA\"}]},{\"@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":"BLOQUEAR RANGOS EN UNA HOJA PROTEGIDA","description":"Puedes bloquear rangos espec\u00edficos y permitir que ciertos usuarios editen \u00fanicamente en rangos espec\u00edficos dentro de una hoja protegida.","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\/bloquear-rangos-en-una-hoja-protegida\/","og_locale":"es_ES","og_type":"article","og_title":"BLOQUEAR RANGOS EN UNA HOJA PROTEGIDA","og_description":"Puedes bloquear rangos espec\u00edficos y permitir que ciertos usuarios editen \u00fanicamente en rangos espec\u00edficos dentro de una hoja protegida.","og_url":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2024-03-06T00:50:56+00:00","article_modified_time":"2024-03-06T00:52:46+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA","datePublished":"2024-03-06T00:50:56+00:00","dateModified":"2024-03-06T00:52:46+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/"},"wordCount":684,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png","keywords":["bloquear","contrase\u00f1a","proteger"],"articleSection":["Colaborar y Compartir","Excel","Herramientas"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/","url":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/","name":"BLOQUEAR RANGOS EN UNA HOJA PROTEGIDA","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png","datePublished":"2024-03-06T00:50:56+00:00","dateModified":"2024-03-06T00:52:46+00:00","description":"Puedes bloquear rangos espec\u00edficos y permitir que ciertos usuarios editen \u00fanicamente en rangos espec\u00edficos dentro de una hoja protegida.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/BLOQUEAR-RANGOS-ESPECIFICOS-EN-UN-HOJA-PROTEGIDA.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/bloquear-rangos-en-una-hoja-protegida\/#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":"BLOQUEAR RANGOS ESPEC\u00cdFICOS EN UNA HOJA PROTEGIDA"}]},{"@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\/15632","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=15632"}],"version-history":[{"count":1,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/15632\/revisions"}],"predecessor-version":[{"id":15637,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/15632\/revisions\/15637"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/15636"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=15632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=15632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=15632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}