{"id":3068,"date":"2021-07-20T01:03:54","date_gmt":"2021-07-20T01:03:54","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=3068"},"modified":"2021-07-21T04:42:43","modified_gmt":"2021-07-21T04:42:43","slug":"bloquear-celulas-no-excel","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel","title":{"rendered":"5 truques para bloquear c\u00e9lulas no Excel"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong><em>Quer impedir que os usu\u00e1rios alterem os dados, a formata\u00e7\u00e3o ou a f\u00f3rmula contidos nas c\u00e9lulas de uma planilha do Excel?<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">Em meu blog anterior, j\u00e1 compartilhei alguns truques r\u00e1pidos para\u00a0<strong>proteger a pasta de trabalho do Excel contra edi\u00e7\u00e3o<\/strong>.\u00a0Mas se voc\u00ea quiser impedir que o usu\u00e1rio fa\u00e7a altera\u00e7\u00f5es em qualquer c\u00e9lula em particular, essas corre\u00e7\u00f5es n\u00e3o ser\u00e3o aplic\u00e1veis.<!--more--><\/p>\n<p style=\"text-align: justify;\">Bem, para tal situa\u00e7\u00e3o, o melhor truque aplic\u00e1vel \u00e9\u00a0<strong>bloquear c\u00e9lulas no Excel.\u00a0<\/strong>Hoje, por meio desta postagem, irei compartilhar diferentes maneiras de\u00a0<strong>bloquear c\u00e9lulas do Excel.\u00a0<\/strong>Para que ningu\u00e9m possa modificar o conte\u00fado de suas c\u00e9lulas protegidas.<\/p>\n<h2 style=\"text-align: justify;\"><strong><u>Qual \u00e9 a necessidade de bloquear c\u00e9lulas no Excel?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">O ponto positivo de\u00a0<strong>bloquear c\u00e9lulas no Excel<\/strong>\u00a0\u00e9 que ele protege seus dados contra altera\u00e7\u00f5es indesejadas.<\/p>\n<p style=\"text-align: justify;\">Suponha que voc\u00ea precise compartilhar sua planilha do Excel com outros usu\u00e1rios e que haja algumas c\u00e9lulas espec\u00edficas que voc\u00ea n\u00e3o deseja que sejam modificadas.\u00a0Nesse caso, o bloqueio de c\u00e9lula \u00e9 o melhor truque para evitar altera\u00e7\u00f5es de f\u00f3rmula e formata\u00e7\u00e3o como problemas.<\/p>\n<p style=\"text-align: justify;\">Assim, ao bloquear a c\u00e9lula no Excel, voc\u00ea pode manter seu trabalho protegido.\u00a0Isso envolve duas etapas b\u00e1sicas.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Bloqueando \/ desbloqueando as c\u00e9lulas da planilha.<\/li>\n<li>Protegendo a planilha do Excel.<\/li>\n<\/ol>\n<h2 style=\"text-align: justify;\"><strong><u>Como\u00a0Para\u00a0Cells bloquear na planilha do Excel?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong><em><a href=\"#a1\">1 # Bloquear c\u00e9lulas na planilha do Excel<\/a><\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em><a href=\"#a2\">2 # Bloqueie algumas c\u00e9lulas espec\u00edficas\u00a0no\u00a0Excel<\/a><\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em><a href=\"#a3\">3 # Bloquear c\u00e9lulas do Excel usando c\u00f3digo VBA<\/a><\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em><a href=\"#a4\">4 # Proteja a planilha inteira,\u00a0exceto\u00a0algumas c\u00e9lulas<\/a><\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em><a href=\"#a5\">5 # Bloquear c\u00e9lulas de f\u00f3rmula<\/a><\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">Vamos discutir tudo isso resumidamente para saber\u00a0<strong>como bloquear c\u00e9lulas no Excel.<\/strong><\/p>\n<p><a name=\"a1\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Truque 1 # Bloquear c\u00e9lulas na planilha do Excel<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Siga as solu\u00e7\u00f5es mencionadas abaixo para\u00a0<strong>bloquear c\u00e9lulas na planilha do Excel:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha as c\u00e9lulas que voc\u00ea precisa bloquear.<\/li>\n<li>V\u00e1 para a guia P\u00e1gina inicial e, a partir do grupo Alinhamento , toque na pequena seta presente ao longo dela. Isso abrir\u00e1 as janelas de Formatar c\u00e9lulas.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3070\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-1.png\" alt=\"bloquear c\u00e9lulas no Excel 1\" width=\"520\" height=\"140\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-1.png 520w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-1-300x81.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, na\u00a0janela de\u00a0formata\u00e7\u00e3o da c\u00e9lula\u00a0, v\u00e1 para a\u00a0guia\u00a0Prote\u00e7\u00e3o\u00a0e selecione a caixa de sele\u00e7\u00e3o de\u00a0Depois\u00a0disso, toque no bot\u00e3o OK para desligar esta janela pop-up.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3071\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-2.png\" alt=\"bloquear c\u00e9lulas no Excel 2\" width=\"539\" height=\"258\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-2.png 539w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-2-300x144.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/p>\n<p style=\"text-align: justify;\">Observa\u00e7\u00e3o:\u00a0se voc\u00ea estiver tentando essas etapas na planilha ou pasta de trabalho que n\u00e3o protegeu, ver\u00e1 que as c\u00e9lulas j\u00e1 est\u00e3o bloqueadas.\u00a0Isso significa que a c\u00e9lula tamb\u00e9m pode ser bloqueada quando a pasta de trabalho ou planilha est\u00e1 protegida.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Na faixa excel bater a revis\u00e3o Depois que a partir do Altera\u00e7\u00f5es grupo, voc\u00ea tem que escolher o livro Protect ou Proteger planilha.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-3072\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-3-1024x118.png\" alt=\"bloquear c\u00e9lulas no Excel 3\" width=\"1024\" height=\"118\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-3-1024x118.png 1024w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-3-300x34.png 300w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-3-768x88.png 768w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-3.png 1045w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Em seguida, voc\u00ea deve reaplicar a prote\u00e7\u00e3o em sua pasta de trabalho ou planilha.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Dica:\u00a0<\/strong>bem, \u00e9 a melhor solu\u00e7\u00e3o para desbloquear c\u00e9lulas que voc\u00ea precisa modificar antes de proteger uma pasta de trabalho ou planilha.\u00a0Mas n\u00e3o se preocupe, pois voc\u00ea pode desbloque\u00e1-los facilmente, mesmo depois de aplicar prote\u00e7\u00e3o sobre eles.\u00a0Para remover a prote\u00e7\u00e3o, tudo que voc\u00ea precisa fazer \u00e9 apenas remover a senha aplicada.<\/p>\n<p><a name=\"a2\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Truque 2 # Bloqueie algumas c\u00e9lulas espec\u00edficas\u00a0no\u00a0Excel<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">\u00c0s vezes, voc\u00ea s\u00f3 precisa bloquear algumas c\u00e9lulas individuais que cont\u00eam dados ou f\u00f3rmulas importantes.\u00a0Nesses casos, proteja apenas as c\u00e9lulas que voc\u00ea precisa travar, deixando as demais como est\u00e3o.<\/p>\n<p style=\"text-align: justify;\">Por padr\u00e3o, c\u00e9lulas inteiras s\u00e3o bloqueadas, portanto, se voc\u00ea aplicar prote\u00e7\u00e3o \u00e0 planilha, c\u00e9lulas inteiras tamb\u00e9m ser\u00e3o bloqueadas.<\/p>\n<p style=\"text-align: justify;\">Portanto, certifique-se de que est\u00e3o protegidas apenas as c\u00e9lulas que deseja bloquear e, em seguida, aplique a prote\u00e7\u00e3o apenas em toda a planilha.<\/p>\n<p style=\"text-align: justify;\">Siga as etapas para\u00a0<strong>bloquear algumas c\u00e9lulas espec\u00edficas no Excel<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha a planilha inteira e v\u00e1 para a guia P\u00e1gina inicial.<\/li>\n<li>Depois disso, acerte o sinal do iniciador da caixa de di\u00e1logo para apresentar o grupo de alinhamento.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3073\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-4.png\" alt=\"bloquear c\u00e9lulas no Excel 4\" width=\"520\" height=\"140\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-4.png 520w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-4-300x81.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora na caixa de di\u00e1logo aberta de\u00a0Formatar c\u00e9lulas\u00a0, v\u00e1 para a\u00a0guia\u00a0Prote\u00e7\u00e3o\u00a0e desmarque a\u00a0op\u00e7\u00e3o\u00a0Bloqueado\u00a0.\u00a0Clique no\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3074\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-5.png\" alt=\"bloquear c\u00e9lulas no Excel 5\" width=\"539\" height=\"258\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-5.png 539w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-5-300x144.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha as c\u00e9lulas que voc\u00ea precisa bloquear.<\/li>\n<li>Mais uma vez, toque no iniciador da caixa de di\u00e1logo presente no\u00a0grupo\u00a0Alinhamento\u00a0, que est\u00e1 na\u00a0guia\u00a0In\u00edcio\u00a0.<\/li>\n<li>Agora, novamente na caixa de di\u00e1logo aberta de\u00a0Formatar c\u00e9lulas,\u00a0v\u00e1 para a\u00a0guia\u00a0Prote\u00e7\u00e3o\u00a0e marque a\u00a0op\u00e7\u00e3o\u00a0Bloqueado\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3075\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-6.png\" alt=\"bloquear c\u00e9lulas no Excel 6\" width=\"538\" height=\"241\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-6.png 538w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-6-300x134.png 300w\" sizes=\"auto, (max-width: 538px) 100vw, 538px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Isso desbloquear\u00e1 c\u00e9lulas inteiras da planilha, exceto aquela que voc\u00ea selecionou para bloqueio.<\/li>\n<li>Agora v\u00e1 para a\u00a0guia\u00a0Revis\u00e3o\u00a0e, a partir do\u00a0grupo\u00a0Altera\u00e7\u00f5es\u00a0, clique na\u00a0op\u00e7\u00e3o\u00a0Proteger Planilha\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-3076\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-7-1024x118.png\" alt=\"bloquear c\u00e9lulas no Excel 7\" width=\"1024\" height=\"118\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-7-1024x118.png 1024w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-7-300x34.png 300w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-7-768x88.png 768w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-7.png 1045w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na caixa de di\u00e1logo aberta da Folha de Prote\u00e7\u00e3o:<\/li>\n<li>Verifique se a op\u00e7\u00e3o &#8216;\u00a0Proteger planilha e conte\u00fado de c\u00e9lulas bloqueadas\u00a0&#8216; est\u00e1 marcada ou n\u00e3o.\u00a0Se n\u00e3o estiver, verifique.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3077\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-8.png\" alt=\"bloquear c\u00e9lulas no Excel 8\" width=\"285\" height=\"320\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-8.png 285w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-8-267x300.png 267w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Digite a senha para aplicar a senha em sua planilha.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3078\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-9.png\" alt=\"bloquear c\u00e9lulas no Excel 9\" width=\"456\" height=\"321\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-9.png 456w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-9-300x211.png 300w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora especifique a permiss\u00e3o que deseja atribuir a outros usu\u00e1rios. Por padr\u00e3o, voc\u00ea ver\u00e1 que as duas primeiras op\u00e7\u00f5es j\u00e1 est\u00e3o selecionadas. Usando qual usu\u00e1rio pode facilmente fazer a sele\u00e7\u00e3o das c\u00e9lulas bloqueadas ou desbloqueadas.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3079\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-10.png\" alt=\"bloquear c\u00e9lulas no Excel 10\" width=\"285\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-10.png 285w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-10-268x300.png 268w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Al\u00e9m disso, voc\u00ea tamb\u00e9m pode permitir outras op\u00e7\u00f5es, como inserir linhas \/ colunas ou fazer altera\u00e7\u00f5es na formata\u00e7\u00e3o.<\/li>\n<li>Toque no\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3080\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-11.png\" alt=\"bloquear c\u00e9lulas no Excel 11\" width=\"285\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-11.png 285w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-11-268x300.png 268w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea estiver aplicando qualquer senha, ser\u00e1 solicitado que a reconfirme.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3081\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-12.png\" alt=\"bloquear c\u00e9lulas no Excel 12\" width=\"314\" height=\"195\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-12.png 314w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-12-300x186.png 300w\" sizes=\"auto, (max-width: 314px) 100vw, 314px\" \/><\/p>\n<p style=\"text-align: justify;\">Na pr\u00f3xima vez que voc\u00ea tentar editar essas c\u00e9lulas espec\u00edficas, receber\u00e1 a seguinte caixa de di\u00e1logo pop-up de mensagem de erro.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3082\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-13.png\" alt=\"bloquear c\u00e9lulas no Excel 13\" width=\"909\" height=\"241\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-13.png 909w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-13-300x80.png 300w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-13-768x204.png 768w\" sizes=\"auto, (max-width: 909px) 100vw, 909px\" \/><br \/>\n<a name=\"a3\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Truque 3 # Bloquear c\u00e9lulas do Excel usando c\u00f3digo VBA<\/u><\/strong><\/h3>\n<ul style=\"text-align: justify;\">\n<li>Escolha c\u00e9lulas inteiras em sua planilha do Excel.<\/li>\n<li>Agora v\u00e1 para a\u00a0guia\u00a0Home\u00a0primeiro e depois para as\u00a0c\u00e9lulas\u00a0desta se\u00e7\u00e3o de c\u00e9lula, toque na\u00a0op\u00e7\u00e3o\u00a0Formatar\u00a0e escolha a\u00a0op\u00e7\u00e3o de\u00a0formatar c\u00e9lulas\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3083\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-14.png\" alt=\"bloquear c\u00e9lulas no Excel 14\" width=\"768\" height=\"494\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-14.png 768w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-14-300x193.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Isso abrir\u00e1 uma\u00a0caixa de di\u00e1logo\u00a0Formatar\u00a0c\u00e9lulas.\u00a0Nesta caixa de di\u00e1logo aberta, voc\u00ea precisa clicar na\u00a0guia Prote\u00e7\u00e3o\u00a0.\u00a0Aqui voc\u00ea desmarcou a op\u00e7\u00e3o\u00a0Bloqueado\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3084\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-15.png\" alt=\"bloquear c\u00e9lulas no Excel 15\" width=\"529\" height=\"460\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-15.png 529w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-15-300x261.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora em seu arquivo Excel onde aparece o nome de sua planilha.\u00a0Clique com o bot\u00e3o direito do mouse e escolha\u00a0View Code.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3085\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-16.png\" alt=\"bloquear c\u00e9lulas no Excel 16\" width=\"361\" height=\"275\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-16.png 361w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-16-300x229.png 300w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Isso abrir\u00e1 a\u00a0caixa de di\u00e1logo\u00a0Microsoft Visual Basic for Applications\u00a0.\u00a0Nesta folha branca aberta junto com a caixa de di\u00e1logo, voc\u00ea s\u00f3 precisa digitar o c\u00f3digo abaixo.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3086\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-17.png\" alt=\"bloquear c\u00e9lulas no Excel 17\" width=\"768\" height=\"759\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-17.png 768w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-17-300x296.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>No c\u00f3digo escrito, selecionamos o intervalo de dados de C7 a E11.\u00a0E tamb\u00e9m aplicou uma senha como 1234.<\/li>\n<li>Depois de inserir o c\u00f3digo completo, v\u00e1 para\u00a0Aqui voc\u00ea encontrar\u00e1 uma op\u00e7\u00e3o\u00a0Executar Form Sub \/ Usu\u00e1rio (F5) e\u00a0toque nela.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3087\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-18.png\" alt=\"bloquear c\u00e9lulas no Excel 18\" width=\"766\" height=\"294\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-18.png 766w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-18-300x115.png 300w\" sizes=\"auto, (max-width: 766px) 100vw, 766px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora voc\u00ea ver\u00e1 que sua planilha do Excel est\u00e1 abrindo junto com uma janela de senha.<\/li>\n<li>Portanto, escreva a mesma senha atribu\u00edda ao c\u00f3digo do VBA,\u00a0por exemplo\u00a0: 1234.<\/li>\n<li>Depois de fazer isso sempre que voc\u00ea se aproxima para fazer altera\u00e7\u00f5es nas c\u00e9lulas desejadas do Excel.\u00a0Isso ir\u00e1 lan\u00e7ar uma mensagem de aviso informando que\u00a0\u201cvoc\u00ea n\u00e3o pode editar as c\u00e9lulas, pois est\u00e1 protegido\u201d.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3088\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-19.png\" alt=\"bloquear c\u00e9lulas no Excel 19\" width=\"767\" height=\"345\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-19.png 767w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-19-300x135.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Nota:\u00a0<\/strong>Para desbloquear as c\u00e9lulas bloqueadas com o c\u00f3digo VBA do Excel, voc\u00ea deve seguir os mesmos procedimentos de desbloqueio explicados anteriormente.<\/p>\n<p><a name=\"a4\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Truque 4 # Proteja a planilha inteira,\u00a0exceto\u00a0algumas c\u00e9lulas<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Em alguns casos, as pessoas tamb\u00e9m desejam proteger a planilha inteira, mantendo algumas das c\u00e9lulas desbloqueadas.<\/p>\n<p style=\"text-align: justify;\">Bem, tal situa\u00e7\u00e3o surge quando voc\u00ea adiciona recursos interativos em sua planilha, como uma lista suspensa.\u00a0E voc\u00ea deseja que seu menu suspenso continue funcionando mesmo quando a planilha estiver protegida.<\/p>\n<p style=\"text-align: justify;\">Para realizar esta tarefa, basta seguir as etapas abaixo mencionadas:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Fa\u00e7a a sele\u00e7\u00e3o das c\u00e9lulas que deseja manter desbloqueadas.<\/li>\n<li>Pressione a tecla\u00a0Control + 1\u00a0no teclado.<\/li>\n<li>Na\u00a0caixa de di\u00e1logo\u00a0Formatar c\u00e9lulas\u00a0aberta,\u00a0v\u00e1 para\u00a0&#8216;Prote\u00e7\u00e3o&#8217;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3089\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-20.png\" alt=\"bloquear c\u00e9lulas no Excel 20\" width=\"671\" height=\"220\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-20.png 671w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-20-300x98.png 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Desmarque a\u00a0op\u00e7\u00e3o\u00a0Bloqueado\u00a0e aperte o bot\u00e3o OK.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Agora, se toda a planilha for mantida protegida, essas c\u00e9lulas espec\u00edficas devem funcionar normalmente.<\/p>\n<p style=\"text-align: justify;\">Para isso, voc\u00ea deve realizar os seguintes passos, de forma a proteger toda a planilha, exceto as c\u00e9lulas selecionadas:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Acesse a\u00a0guia\u00a0Revis\u00e3o\u00a0e, a partir do\u00a0grupo\u00a0Altera\u00e7\u00f5es\u00a0, toque no\u00a0\u00edcone\u00a0Proteger planilha\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3090\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-21.png\" alt=\"bloquear c\u00e9lulas no Excel 21\" width=\"420\" height=\"135\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-21.png 420w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-21-300x96.png 300w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na\u00a0caixa de di\u00e1logo\u00a0Proteger planilha\u00a0aberta\u00a0:<\/li>\n<li>Verifique se a op\u00e7\u00e3o &#8216;\u00a0Proteger planilha e conte\u00fado de c\u00e9lulas bloqueadas\u00a0&#8216; est\u00e1 marcada ou n\u00e3o.\u00a0Se n\u00e3o estiver, verifique.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3091\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-22.png\" alt=\"bloquear c\u00e9lulas no Excel 22\" width=\"285\" height=\"320\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-22.png 285w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-22-267x300.png 267w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Digite a senha para aplicar a senha em sua planilha).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3092\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-23.png\" alt=\"bloquear c\u00e9lulas no Excel 23\" width=\"456\" height=\"321\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-23.png 456w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-23-300x211.png 300w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora especifique a permiss\u00e3o que deseja atribuir a outros usu\u00e1rios.\u00a0Por padr\u00e3o, voc\u00ea ver\u00e1 que as duas primeiras op\u00e7\u00f5es j\u00e1 est\u00e3o selecionadas.\u00a0Usando qual usu\u00e1rio pode facilmente fazer a sele\u00e7\u00e3o das c\u00e9lulas bloqueadas ou desbloqueadas.<\/li>\n<li>Al\u00e9m disso, voc\u00ea tamb\u00e9m pode permitir outras op\u00e7\u00f5es, como inserir linhas \/ colunas ou fazer altera\u00e7\u00f5es na formata\u00e7\u00e3o.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3093\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-24.png\" alt=\"bloquear c\u00e9lulas no Excel 24\" width=\"285\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-24.png 285w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-24-268x300.png 268w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><br \/>\n<a name=\"a5\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Truque 5 # Bloquear c\u00e9lulas de f\u00f3rmula<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Para\u00a0<strong>bloquear as c\u00e9lulas da f\u00f3rmula<\/strong>, a primeira coisa que voc\u00ea precisa fazer \u00e9 desbloquear todas as c\u00e9lulas e, em seguida, bloquear apenas as c\u00e9lulas que cont\u00eam a f\u00f3rmula.\u00a0Por fim, proteja o len\u00e7ol.<\/p>\n<p style=\"text-align: justify;\">Bem, se voc\u00ea n\u00e3o sabe como realizar todas essas tarefas, siga as etapas abaixo:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha a c\u00e9lula inteira da sua planilha.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3094\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-25.jpg\" alt=\"bloquear c\u00e9lulas no Excel 25\" width=\"604\" height=\"127\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-25.jpg 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-25-300x63.jpg 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora clique com o bot\u00e3o direito e na op\u00e7\u00e3o listada escolha\u00a0<strong>Formatar c\u00e9lulas.<\/strong><\/li>\n<li>Na janela de formata\u00e7\u00e3o da c\u00e9lula, v\u00e1 at\u00e9 a\u00a0guia\u00a0<strong>Prote\u00e7\u00e3o\u00a0<\/strong>e\u00a0desmarque\u00a0a caixa de sele\u00e7\u00e3o da\u00a0op\u00e7\u00e3o\u00a0Bloqueado\u00a0.\u00a0Depois disso, clique no\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3095\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-26.png\" alt=\"bloquear c\u00e9lulas no Excel 26\" width=\"529\" height=\"465\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-26.png 529w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-26-300x264.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>V\u00e1 para a\u00a0guia\u00a0Home\u00a0e, no\u00a0grupo\u00a0Editing\u00a0, escolha\u00a0Find &amp; Select.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3096\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-27.png\" alt=\"bloquear c\u00e9lulas no Excel 27\" width=\"338\" height=\"100\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-27.png 338w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-27-300x89.png 300w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique na\u00a0op\u00e7\u00e3o\u00a0Ir\u00a0para\u00a0especial\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3097\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-28.png\" alt=\"bloquear c\u00e9lulas no Excel 28\" width=\"183\" height=\"272\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha\u00a0F\u00f3rmulas\u00a0e clique no\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3098\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-29.png\" alt=\"bloquear c\u00e9lulas no Excel 29\" width=\"314\" height=\"330\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-29.png 314w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-29-285x300.png 285w\" sizes=\"auto, (max-width: 314px) 100vw, 314px\" \/><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea ver\u00e1 que, ap\u00f3s realizar essas etapas, o Excel selecionar\u00e1 todas as c\u00e9lulas da f\u00f3rmula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3099\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-30.png\" alt=\"bloquear c\u00e9lulas no Excel 30\" width=\"604\" height=\"127\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-30.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-30-300x63.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Pressione o\u00a0bot\u00e3o\u00a0CTRL + 1\u00a0no teclado.<\/li>\n<li>V\u00e1 para a\u00a0guia\u00a0Prote\u00e7\u00e3o\u00a0e marque a caixa de sele\u00e7\u00e3o da\u00a0op\u00e7\u00e3o\u00a0Bloqueado\u00a0.\u00a0Depois disso, pressione o\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3100\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-31.png\" alt=\"bloquear c\u00e9lulas no Excel 31\" width=\"529\" height=\"465\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-31.png 529w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-31-300x264.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/p>\n<p style=\"text-align: justify;\">Observa\u00e7\u00e3o:<\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea marcar a caixa de sele\u00e7\u00e3o da\u00a0op\u00e7\u00e3o\u00a0Oculto\u00a0, o usu\u00e1rio n\u00e3o poder\u00e1 ver a f\u00f3rmula na barra de f\u00f3rmulas, mesmo depois de escolher as c\u00e9lulas da f\u00f3rmula.<\/p>\n<p style=\"text-align: justify;\">Sempre tenha isso em mente que o bloqueio de c\u00e9lulas n\u00e3o tem nenhum efeito at\u00e9 e a menos que a planilha seja protegida.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Portanto, agora \u00e9 hora de proteger sua planilha do Excel.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Depois disso, voc\u00ea ver\u00e1 que todas as c\u00e9lulas da f\u00f3rmula foram bloqueadas.\u00a0No caso de edi\u00e7\u00e3o dessas c\u00e9lulas, primeiro \u00e9 necess\u00e1rio desproteger a planilha.<\/p>\n<h2 style=\"text-align: justify;\"><strong><u>FAQ:<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\"><div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span> <strong>Como voc\u00ea <\/strong>bloqueia <strong>c\u00e9lulas no Excel sem proteger a planilha? <\/strong><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"> Para\u00a0<strong>bloquear c\u00e9lulas em O Excel sem a planilha de prote\u00e7\u00e3o\u00a0<\/strong>\u00e9 poss\u00edvel usando o\u00a0<strong>c\u00f3digo VBA<\/strong>\u00a0do\u00a0<strong>Excel<\/strong><strong>.\u00a0<\/strong>Embora seja um procedimento um pouco longo, mas muito \u00fatil em situa\u00e7\u00f5es em que outros m\u00e9todos n\u00e3o funcionam.\u00a0Portanto, \u00e9 importante ter conhecimento de\u00a0<strong>bloqueio de c\u00e9lulas com o Excel VBA.<\/strong><\/p>\n<p style=\"text-align: justify;\">Para saber como realizar esta tarefa, v\u00e1 para a se\u00e7\u00e3o do\u00a0<strong>truque 3 # Bloquear c\u00e9lulas do Excel usando c\u00f3digo VBA\u00a0<\/strong>neste artigo.<\/p>\n<p style=\"text-align: justify;\"><\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span> <strong>Como voc\u00ea <\/strong>bloqueia <strong>uma c\u00e9lula em uma f\u00f3rmula? <\/strong><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul style=\"text-align: justify;\">\n<li>Para\u00a0<strong>bloquear c\u00e9lulas na f\u00f3rmula do Excel,\u00a0<\/strong>voc\u00ea precisa primeiro arrastar ou apenas copiar a f\u00f3rmula e, em seguida, bloquear o valor da c\u00e9lula usando a tecla F4.<\/li>\n<li>Pressionar a tecla f4, em \u00faltima an\u00e1lise, bloqueia a refer\u00eancia de c\u00e9lula de apenas uma c\u00e9lula da f\u00f3rmula.<\/li>\n<li>Portanto, escolha a c\u00e9lula da f\u00f3rmula e toque em uma das refer\u00eancias de c\u00e9lula mostradas na barra de f\u00f3rmula e, em seguida, pressione a tecla F4.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3101\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-32.png\" alt=\"bloquear c\u00e9lulas no Excel 32\" width=\"551\" height=\"185\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-32.png 551w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-32-300x101.png 300w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora voc\u00ea ver\u00e1 que a refer\u00eancia de c\u00e9lula selecionada por voc\u00ea agora est\u00e1 bloqueada.<\/li>\n<li>Execute o procedimento para bloquear outras refer\u00eancias de c\u00e9lula da f\u00f3rmula.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span> <strong>Posso bloquear v\u00e1rias c\u00e9lulas no Excel? <\/strong><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\">Sim, voc\u00ea pode bloquear v\u00e1rias c\u00e9lulas no Excel por meio de\u00a0pain\u00e9is congelados\u00a0.\u00a0Isso bloquear\u00e1 colunas ou linhas espec\u00edficas no lugar.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Para bloquear qualquer linha \u00fanica, v\u00e1 para a guia Exibir e escolha a op\u00e7\u00e3o Congelar linha superior.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3102\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-33.png\" alt=\"bloquear c\u00e9lulas no Excel 33\" width=\"447\" height=\"262\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-33.png 447w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-33-300x176.png 300w\" sizes=\"auto, (max-width: 447px) 100vw, 447px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Para bloquear qualquer coluna apenas, v\u00e1 para a guia Exibir e escolha a op\u00e7\u00e3o Congelar a primeira coluna.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3103\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-34.png\" alt=\"bloquear c\u00e9lulas no Excel 34\" width=\"537\" height=\"241\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-34.png 537w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-34-300x135.png 300w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Para bloquear mais de uma coluna \/ linha ou para bloquear a coluna e as linhas simultaneamente.\u00a0Voc\u00ea precisa ir para a\u00a0guia\u00a0View\u00a0e clicar em\u00a0Freeze Panes\u00a0.\u00a0Voc\u00ea precisa colocar o cursor logo abaixo da linha que deseja congelar e no lado direito da coluna que deseja congelar.<\/li>\n<li>Para bloquear v\u00e1rias linhas a partir da linha 1, basta escolher a linha presente abaixo da linha que voc\u00ea deseja congelar.\u00a0Depois disso, v\u00e1 para a\u00a0guia\u00a0View\u00a0e clique em\u00a0Freeze Panes\u00a0.<\/li>\n<li>Para bloquear v\u00e1rias colunas a partir da coluna 1, basta escolher a coluna presente no lado direito da coluna que voc\u00ea deseja congelar.\u00a0Depois disso, v\u00e1 para a\u00a0guia\u00a0View\u00a0e clique em\u00a0Freeze Panes\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3104\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-35.png\" alt=\"bloquear c\u00e9lulas no Excel 35\" width=\"618\" height=\"420\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-35.png 618w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-35-300x204.png 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><\/p>\n<p style=\"text-align: justify;\"><\/div><\/div>\n<p style=\"text-align: justify;\"><div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span> <strong>Como fa\u00e7o para tornar uma c\u00e9lula n\u00e3o edit\u00e1vel no Excel? <\/strong><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\">Para tornar uma c\u00e9lula n\u00e3o edit\u00e1vel no Excel, voc\u00ea precisa torn\u00e1-la somente leitura usando o c\u00f3digo VBA.<\/p>\n<p style=\"text-align: justify;\">O ponto positivo de usar o c\u00f3digo VBA para tornar a c\u00e9lula somente leitura \u00e9 que voc\u00ea n\u00e3o precisa proteger sua planilha.<\/p>\n<p style=\"text-align: justify;\">Portanto, vamos aplicar a solu\u00e7\u00e3o a seguir para\u00a0<strong>tornar uma c\u00e9lula n\u00e3o edit\u00e1vel no Excel.<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Clique com o bot\u00e3o direito do mouse na guia da planilha na qual deseja tornar a c\u00e9lula somente leitura.\u00a0Depois disso, a partir das op\u00e7\u00f5es listadas que aparecem, escolha\u00a0View Code.<\/li>\n<li>Agora, na\u00a0janela\u00a0aberta do\u00a0Microsoft Visual Basic for Applications\u00a0, voc\u00ea precisa copiar e colar o c\u00f3digo VBA a seguir na janela Code.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>C\u00f3digo VBA:\u00a0para\u00a0tornar a c\u00e9lula somente leitura no Excel<\/strong><\/p>\n<blockquote><p>Private Sub Worksheet_SelectionChange(ByVal Target\u00a0As Range)<\/p>\n<p>If Target.Column = 1\u00a0Then<\/p>\n<p>If Target.Row = 3\u00a0Or Target.Row = 4\u00a0Or Target.Row = 5\u00a0Then<\/p>\n<p>Beep<\/p>\n<p>Cells(Target.Row, Target.Column).Offset(0, 1).Select<\/p>\n<p>MsgBox Cells(Target.Row, Target.Column).Address &amp;\u00a0\u201d cannot be selected and edited as it is a read-only cell\u201d, _<\/p>\n<p>vbInformation, \u201cRepair MS Excel\u201d<\/p>\n<p>End If<\/p>\n<p>End If<\/p>\n<p>End Sub<\/p><\/blockquote>\n<p style=\"text-align: justify;\"><strong>Nota\u00a0<\/strong>: lembre-se de usar este c\u00f3digo, voc\u00ea s\u00f3 pode definir as c\u00e9lulas selecionadas de uma coluna como somente leitura.\u00a0Usando o c\u00f3digo acima, na planilha atual voc\u00ea pode tornar as c\u00e9lulas A3, A4 e A5 como somente leitura.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-3105\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-36-1024x324.png\" alt=\"bloquear c\u00e9lulas no Excel 36\" width=\"1024\" height=\"324\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-36-1024x324.png 1024w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-36-300x95.png 300w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-36-768x243.png 768w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Cells-In-Excel-36.png 1168w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>No teclado, pressione as\u00a0teclas\u00a0Alt\u00a0+\u00a0Q\u00a0para fechar a\u00a0janela\u00a0do\u00a0Microsoft Visual Basic for Applications\u00a0.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><\/div><\/div>\n<h2 style=\"text-align: justify;\"><strong><u>Op\u00e7\u00e3o recomendada\u00a0para\u00a0recupera\u00e7\u00e3o de dados do Excel<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>MS Excel reparo Ferramenta<\/strong> \u00e9 uma ferramenta especial que \u00e9 projetada especificamente para reparar qualquer tipo de problema, corrup\u00e7\u00e3o, erros no arquivo do Excel. Isso tamb\u00e9m pode restaurar facilmente todos os dados perdidos do Excel, incluindo\u00a0<strong>coment\u00e1rios de c\u00e9lulas, gr\u00e1ficos, propriedades da planilha e outros dados relacionados.<\/strong><\/p>\n<p style=\"text-align: justify;\">\u00c9 uma ferramenta exclusiva que pode reparar v\u00e1rios arquivos corrompidos do Excel em um ciclo de reparo e restaurar dados para um novo arquivo do Excel em branco ou para o local preferido.\u00a0A ferramenta tem a capacidade de recuperar dados sem modificar a formata\u00e7\u00e3o original.<\/p>\n<ul style=\"text-align: justify;\">\n<li>A interface \u00e9 muito simples, com uma grande barra de ferramentas de bot\u00f5es para adicionar arquivos ou pastas ao aplicativo.<\/li>\n<li>Com este software, voc\u00ea pode reparar seu arquivo Excel corrompido.<\/li>\n<li>Ele pode facilmente restaurar todos os arquivos Excel corrompidos e tamb\u00e9m recuperar tudo o que inclui coment\u00e1rios de c\u00e9lulas, gr\u00e1ficos, propriedades de planilhas e outros dados relacionados.<\/li>\n<li>O arquivo Excel corrompido pode ser restaurado em um novo arquivo Excel em branco.<\/li>\n<li>Ele tem a capacidade de recuperar os dados completos do arquivo Excel do arquivo e restaur\u00e1-los, mesmo sem modificar a formata\u00e7\u00e3o original.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Baixar<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/compre-agora' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Compre Agora<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> A vers\u00e3o gratuita do produto exibe apenas dados recuper\u00e1veis.<\/div><\/center>\n<h3 style=\"text-align: justify;\"><strong><u>Etapas para utilizar a ferramenta de reparo do MS Excel:<\/u><\/strong><\/h3>\n<h2 style=\"text-align: justify;\"><strong><u>Conclus\u00e3o<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Bloquear c\u00e9lulas no Excel ajuda a manter a f\u00f3rmula completamente segura de ser modificada por terceiros.<\/p>\n<p style=\"text-align: justify;\">Esperan\u00e7osamente, este tutorial informativo parece \u00fatil para voc\u00ea.\u00a0N\u00e3o se esque\u00e7a de deixar um coment\u00e1rio se tiver d\u00favidas ou dicas para compartilhar sobre\u00a0<strong>como bloquear c\u00e9lulas no Excel.<\/strong><\/p>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Quer impedir que os usu\u00e1rios alterem os dados, a formata\u00e7\u00e3o ou a f\u00f3rmula contidos nas c\u00e9lulas de uma planilha do &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"5 truques para bloquear c\u00e9lulas no Excel\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel#more-3068\" aria-label=\"Read more about 5 truques para bloquear c\u00e9lulas no Excel\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":3346,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[1182,1181,1185,1183,1180,1184,1186],"class_list":["post-3068","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-bloquear-celulas-na-planilha-do-excel","tag-bloquear-celulas-no-excel-sem-proteger-a-planilha","tag-bloquear-varias-celulas-no-excel","tag-bloqueie-celulas-do-excel-usando-codigo-vba","tag-como-bloquear-celulas-no-excel","tag-l-ock-celulas-formulas","tag-tornar-uma-celula-nao-editavel-no-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>5 truques para bloquear c\u00e9lulas no Excel<\/title>\n<meta name=\"description\" content=\"Aprenda a bloquear c\u00e9lulas no Excel. Tamb\u00e9m obtenha respostas a perguntas como: como bloquear c\u00e9lulas no Excel sem proteger a planilha? Como bloquear uma c\u00e9lula em uma f\u00f3rmula? Pode i bloquear v\u00e1rias c\u00e9lulas em Excel e muito mais.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 truques para bloquear c\u00e9lulas no Excel\" \/>\n<meta property=\"og:description\" content=\"Aprenda a bloquear c\u00e9lulas no Excel. Tamb\u00e9m obtenha respostas a perguntas como: como bloquear c\u00e9lulas no Excel sem proteger a planilha? Como bloquear uma c\u00e9lula em uma f\u00f3rmula? Pode i bloquear v\u00e1rias c\u00e9lulas em Excel e muito mais.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-20T01:03:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-21T04:42:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-cells-in-excel-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"5 truques para bloquear c\u00e9lulas no Excel\",\"datePublished\":\"2021-07-20T01:03:54+00:00\",\"dateModified\":\"2021-07-21T04:42:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel\"},\"wordCount\":2793,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/lock-cells-in-excel-pt.png\",\"keywords\":[\"Bloquear c\u00e9lulas na planilha do Excel\",\"Bloquear c\u00e9lulas no Excel sem proteger a planilha\",\"bloquear v\u00e1rias c\u00e9lulas no Excel\",\"Bloqueie c\u00e9lulas do Excel usando c\u00f3digo VBA\",\"como bloquear c\u00e9lulas no Excel\",\"l ock c\u00e9lulas f\u00f3rmulas\",\"tornar uma c\u00e9lula n\u00e3o edit\u00e1vel no Excel\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel\",\"name\":\"5 truques para bloquear c\u00e9lulas no Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/lock-cells-in-excel-pt.png\",\"datePublished\":\"2021-07-20T01:03:54+00:00\",\"dateModified\":\"2021-07-21T04:42:43+00:00\",\"description\":\"Aprenda a bloquear c\u00e9lulas no Excel. Tamb\u00e9m obtenha respostas a perguntas como: como bloquear c\u00e9lulas no Excel sem proteger a planilha? Como bloquear uma c\u00e9lula em uma f\u00f3rmula? Pode i bloquear v\u00e1rias c\u00e9lulas em Excel e muito mais.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/lock-cells-in-excel-pt.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/lock-cells-in-excel-pt.png\",\"width\":550,\"height\":300,\"caption\":\"5 truques para bloquear c\u00e9lulas no Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/bloquear-celulas-no-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 truques para bloquear c\u00e9lulas no Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 truques para bloquear c\u00e9lulas no Excel","description":"Aprenda a bloquear c\u00e9lulas no Excel. Tamb\u00e9m obtenha respostas a perguntas como: como bloquear c\u00e9lulas no Excel sem proteger a planilha? Como bloquear uma c\u00e9lula em uma f\u00f3rmula? Pode i bloquear v\u00e1rias c\u00e9lulas em Excel e muito mais.","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:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel","og_locale":"en_US","og_type":"article","og_title":"5 truques para bloquear c\u00e9lulas no Excel","og_description":"Aprenda a bloquear c\u00e9lulas no Excel. Tamb\u00e9m obtenha respostas a perguntas como: como bloquear c\u00e9lulas no Excel sem proteger a planilha? Como bloquear uma c\u00e9lula em uma f\u00f3rmula? Pode i bloquear v\u00e1rias c\u00e9lulas em Excel e muito mais.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2021-07-20T01:03:54+00:00","article_modified_time":"2021-07-21T04:42:43+00:00","og_image":[{"width":550,"height":300,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-cells-in-excel-pt.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"5 truques para bloquear c\u00e9lulas no Excel","datePublished":"2021-07-20T01:03:54+00:00","dateModified":"2021-07-21T04:42:43+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel"},"wordCount":2793,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-cells-in-excel-pt.png","keywords":["Bloquear c\u00e9lulas na planilha do Excel","Bloquear c\u00e9lulas no Excel sem proteger a planilha","bloquear v\u00e1rias c\u00e9lulas no Excel","Bloqueie c\u00e9lulas do Excel usando c\u00f3digo VBA","como bloquear c\u00e9lulas no Excel","l ock c\u00e9lulas f\u00f3rmulas","tornar uma c\u00e9lula n\u00e3o edit\u00e1vel no Excel"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel","url":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel","name":"5 truques para bloquear c\u00e9lulas no Excel","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-cells-in-excel-pt.png","datePublished":"2021-07-20T01:03:54+00:00","dateModified":"2021-07-21T04:42:43+00:00","description":"Aprenda a bloquear c\u00e9lulas no Excel. Tamb\u00e9m obtenha respostas a perguntas como: como bloquear c\u00e9lulas no Excel sem proteger a planilha? Como bloquear uma c\u00e9lula em uma f\u00f3rmula? Pode i bloquear v\u00e1rias c\u00e9lulas em Excel e muito mais.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-cells-in-excel-pt.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-cells-in-excel-pt.png","width":550,"height":300,"caption":"5 truques para bloquear c\u00e9lulas no Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/bloquear-celulas-no-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"5 truques para bloquear c\u00e9lulas no Excel"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=3068"}],"version-history":[{"count":4,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3068\/revisions"}],"predecessor-version":[{"id":3121,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3068\/revisions\/3121"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/3346"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=3068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=3068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=3068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}