{"id":645,"date":"2023-10-14T20:26:54","date_gmt":"2023-10-14T20:26:54","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/"},"modified":"2023-12-06T11:37:24","modified_gmt":"2023-12-06T11:37:24","slug":"desmarcar-celulas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/","title":{"rendered":"Como desmarcar c\u00e9lulas no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-3038148340\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-513890188\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>At\u00e9 agora, o Excel n\u00e3o tinha a capacidade de desmarcar c\u00e9lulas ou um intervalo do intervalo de c\u00e9lulas selecionado. Portanto, ningu\u00e9m poderia desmarcar c\u00e9lulas ou um intervalo de c\u00e9lulas de sua sele\u00e7\u00e3o.<\/p><p> Mas agora o Excel introduziu o recurso para desmarcar c\u00e9lulas selecionadas ou um intervalo de c\u00e9lulas de sua sele\u00e7\u00e3o atual. No momento em que este artigo foi escrito, esse novo recurso estava dispon\u00edvel apenas para assinantes do Office 365 e Excel 2019 para PC e Mac.<\/p><p> Abaixo capturamos algumas etapas r\u00e1pidas e f\u00e1ceis para voc\u00ea desmarcar e selecionar c\u00e9lulas no Excel<\/p><h2 id=\"deselect-cells-in-excel\" class=\"wp-block-heading\"> Desmarcar c\u00e9lulas no Excel<\/h2><p> Depois de adicionar o recurso Desmarcar c\u00e9lulas no Excel, fica f\u00e1cil desmarcar as c\u00e9lulas desnecess\u00e1rias da sele\u00e7\u00e3o atual.<\/p><ul><li> Primeiro, mantenha pressionada a tecla \u201cControl\u201d no teclado.<\/li><li> Depois disso, clique nas c\u00e9lulas da sele\u00e7\u00e3o atual que deseja desmarcar da sele\u00e7\u00e3o. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64054\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"desmarcar c\u00e9lulas\" width=\"580\" height=\"284\"><\/figure><\/div><p> Na imagem de exemplo acima, mantivemos pressionada a tecla Control e clicamos nas c\u00e9lulas B1, B3 e B7 para desmarcar essas colunas da sele\u00e7\u00e3o atual (A1-I15). Voc\u00ea pode ver ap\u00f3s a sele\u00e7\u00e3o que as colunas selecionadas est\u00e3o desmarcadas.<\/p><h2 id=\"deselect-the-entire-columns-in-excel\" class=\"wp-block-heading\"> Desmarque colunas inteiras no Excel<\/h2><ul><li> Primeiro, mantenha pressionada a tecla \u201cControl\u201d no teclado.<\/li><li> Depois disso, clique no cabe\u00e7alho da coluna e arraste at\u00e9 a coluna inteira para desmarcar essa coluna da sua sele\u00e7\u00e3o atual. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64055\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-deselectionner-la-colonne-entiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"desmarcar coluna inteira\" width=\"654\" height=\"303\"><\/figure><\/div><p> Na imagem de exemplo acima, mantivemos pressionada a tecla Control e clicamos no cabe\u00e7alho da coluna (Categoria), e arrastamos a coluna inteira para D15 e fizemos o mesmo com ela -cabe\u00e7alho da coluna (Zona) para desmarcar essas duas colunas inteiras (D &amp; F) da sele\u00e7\u00e3o atual (A1-I15).<\/p><h2 id=\"select-cells-or-ranges-in-excel\" class=\"wp-block-heading\"> Selecione c\u00e9lulas ou intervalos no Excel<\/h2><p> N\u00e3o h\u00e1 altera\u00e7\u00e3o na sele\u00e7\u00e3o ou intervalo de c\u00e9lulas no Excel. O processo de sele\u00e7\u00e3o de c\u00e9lulas \u00e9 o mesmo e \u00e9 mostrado abaixo:<\/p><ul><li> Para c\u00e9lulas cont\u00edguas, selecione a c\u00e9lula a partir da qual deseja criar sua sele\u00e7\u00e3o e<\/li><li> Depois disso, mantenha pressionado o bot\u00e3o \u201cShift\u201d do teclado e clique na outra c\u00e9lula at\u00e9 a qual deseja criar uma sele\u00e7\u00e3o<\/li><li> Ou selecione a c\u00e9lula a partir da qual deseja criar sua sele\u00e7\u00e3o e arraste-a para a c\u00e9lula na qual deseja criar uma sele\u00e7\u00e3o. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64056\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-des-cellules-contigues.png\" sizes=\"auto, \" srcset=\"\" alt=\"selecione c\u00e9lulas cont\u00edguas\" width=\"589\" height=\"295\"><\/figure><\/div><p> Na imagem de exemplo acima, primeiro clicamos e seguramos Shift na c\u00e9lula A1 e, em seguida, clicamos diretamente na c\u00e9lula I15 para criar uma sele\u00e7\u00e3o de (A1-I15).<\/p><ul><li> Para c\u00e9lulas n\u00e3o cont\u00edguas, mantenha pressionada a tecla Control e selecione as c\u00e9lulas ou intervalos desejados como sua sele\u00e7\u00e3o. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64057\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionner-des-cellules-non-contigues.png\" sizes=\"auto, \" srcset=\"\" alt=\"selecione c\u00e9lulas n\u00e3o cont\u00edguas\" width=\"646\" height=\"266\"><\/figure><\/div><p> Na imagem de exemplo acima, mantivemos pressionada a tecla Control e selecionamos os intervalos de c\u00e9lulas n\u00e3o cont\u00edguos.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/nocoes-basicas-de-excel\/\">No\u00e7\u00f5es b\u00e1sicas do Microsoft Excel (componentes, pe\u00e7as e notas de conhecimento)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/adicionar-remover-hiperlinks\/\">Adicione e remova hiperlinks no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/adicione-uma-marca-dagua\/\">Adicione uma marca d&#8217;\u00e1gua no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/remover-colunas-de-linha-ocultas\/\">Exclua linhas ocultas no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/adicionar-uma-coluna\/\">Adicionar uma coluna no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/selecione-celulas-nao-contiguas\/\">Selecione c\u00e9lulas n\u00e3o cont\u00edguas no Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-645","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como desmarcar c\u00e9lulas no Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 como desmarcar c\u00e9lulas no Excel. E voc\u00ea tamb\u00e9m aprender\u00e1 como desmarcar um\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como desmarcar c\u00e9lulas no Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 como desmarcar c\u00e9lulas no Excel. E voc\u00ea tamb\u00e9m aprender\u00e1 como desmarcar um\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:37:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/\",\"name\":\"Como desmarcar c\u00e9lulas no Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\",\"datePublished\":\"2023-10-14T20:26:54+00:00\",\"dateModified\":\"2023-12-06T11:37:24+00:00\",\"description\":\"Neste tutorial, voc\u00ea aprender\u00e1 como desmarcar c\u00e9lulas no Excel. E voc\u00ea tamb\u00e9m aprender\u00e1 como desmarcar um\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como desmarcar c\u00e9lulas no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como desmarcar c\u00e9lulas no Excel? (Tutorial 2023)","description":"Neste tutorial, voc\u00ea aprender\u00e1 como desmarcar c\u00e9lulas no Excel. E voc\u00ea tamb\u00e9m aprender\u00e1 como desmarcar um","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:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/","og_locale":"pt_PT","og_type":"article","og_title":"Como desmarcar c\u00e9lulas no Excel? (Tutorial 2023)","og_description":"Neste tutorial, voc\u00ea aprender\u00e1 como desmarcar c\u00e9lulas no Excel. E voc\u00ea tamb\u00e9m aprender\u00e1 como desmarcar um","og_url":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:37:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/","url":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/","name":"Como desmarcar c\u00e9lulas no Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png","datePublished":"2023-10-14T20:26:54+00:00","dateModified":"2023-12-06T11:37:24+00:00","description":"Neste tutorial, voc\u00ea aprender\u00e1 como desmarcar c\u00e9lulas no Excel. E voc\u00ea tamb\u00e9m aprender\u00e1 como desmarcar um","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/desmarcar-celulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como desmarcar c\u00e9lulas no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=645"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/645\/revisions"}],"predecessor-version":[{"id":1035,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/645\/revisions\/1035"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}