{"id":86,"date":"2023-11-17T05:47:13","date_gmt":"2023-11-17T05:47:13","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/"},"modified":"2023-12-06T11:33:45","modified_gmt":"2023-12-06T11:33:45","slug":"caixa-de-dialogo","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/","title":{"rendered":"Como abrir uma caixa de di\u00e1logo no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1436241253\"><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-788940483\"><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>No Excel, para acessar mais op\u00e7\u00f5es de qualquer categoria de op\u00e7\u00e3o, voc\u00ea pode abrir a caixa de di\u00e1logo e usar essas op\u00e7\u00f5es diretamente na caixa de di\u00e1logo. Al\u00e9m disso, existem algumas op\u00e7\u00f5es que devem ser usadas diretamente em uma caixa de di\u00e1logo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77704\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"caixa de di\u00e1logo de formato de c\u00e9lulas\" width=\"556\" height=\"549\"><\/figure><\/div><p> Neste tutorial, veremos como abrir e usar uma caixa de di\u00e1logo usando uma op\u00e7\u00e3o.<\/p><h2 class=\"wp-block-heading\"> Abra uma caixa de di\u00e1logo na faixa de op\u00e7\u00f5es<\/h2><ol type=\"1\"><li> Navegue at\u00e9 a guia na qual deseja abrir a op\u00e7\u00e3o.<\/li><li> V\u00e1 para o grupo de op\u00e7\u00f5es.<\/li><li> Passe o cursor sobre a pequena seta no canto inferior direito.<\/li><li> Clique nele para abrir a caixa de di\u00e1logo de op\u00e7\u00f5es. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77705\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-boite-de-dialogue-du-ruban.png\" sizes=\"auto, \" srcset=\"\" alt=\"caixa de di\u00e1logo da faixa de op\u00e7\u00f5es\" width=\"686\" height=\"166\"><\/figure><\/div><p> No momento em que voc\u00ea clica nele, o Excel abre a caixa de di\u00e1logo dessa op\u00e7\u00e3o. E, quando voc\u00ea clica na seta do grupo de fontes, ela abre a caixa de di\u00e1logo de formato e a guia de fontes a partir da\u00ed. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77706\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-onglet-de-police-de-la-boite-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"guia de fonte da caixa de di\u00e1logo\" width=\"508\" height=\"502\"><\/figure><\/div><p> Na faixa de op\u00e7\u00f5es voc\u00ea tem v\u00e1rias guias, mas nem todas as guias possuem essas setas para baixo nos grupos de op\u00e7\u00f5es para abrir a caixa de di\u00e1logo.<\/p><h2 class=\"wp-block-heading\"> Op\u00e7\u00f5es da caixa de di\u00e1logo<\/h2><p> Como eu disse, existem algumas op\u00e7\u00f5es que voc\u00ea deve usar diretamente de uma caixa de di\u00e1logo. Por exemplo, a op\u00e7\u00e3o Localizar e Substituir. Ao pressionar o atalho de teclado (Ctrl + F), aparecer\u00e1 uma caixa de di\u00e1logo onde voc\u00ea dever\u00e1 inserir o valor que deseja pesquisar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77707\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-options-de-boite-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"op\u00e7\u00f5es da caixa de di\u00e1logo\" width=\"563\" height=\"239\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Caixa de di\u00e1logo Op\u00e7\u00f5es do Excel<\/h2><p> <a href=\"https:\/\/exceladvisor.org\/pt\/opcoes\/\">As Op\u00e7\u00f5es do Excel<\/a> tamb\u00e9m possuem uma caixa de di\u00e1logo. Ao abrir as op\u00e7\u00f5es, Arquivo \u21e2 Mais \u21e2 Op\u00e7\u00f5es. Voc\u00ea receber\u00e1 uma grande caixa de di\u00e1logo com todas as op\u00e7\u00f5es que voc\u00ea pode modificar em seu ambiente Excel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77708\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-dialogue-des-5-options-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Caixa de di\u00e1logo de op\u00e7\u00f5es do Excel\" width=\"783\" height=\"406\"><\/figure><\/div><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\/justificar-completamente\/\">Preencha Justificar no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/barra-de-formulas-do-excel\/\">Barra de f\u00f3rmulas no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/governante\/\">Mostrar r\u00e9gua no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/alca-de-enchimento\/\">Al\u00e7a de preenchimento no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/formato-de-pintor\/\">Pintor de formato no Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-86","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 abrir uma caixa de di\u00e1logo no Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Neste tutorial, aprenderemos como usar uma caixa de di\u00e1logo no Excel. Para acessar mais op\u00e7\u00f5es de qualquer\" \/>\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\/caixa-de-dialogo\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como abrir uma caixa de di\u00e1logo no Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, aprenderemos como usar uma caixa de di\u00e1logo no Excel. Para acessar mais op\u00e7\u00f5es de qualquer\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:33:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/\",\"name\":\"Como abrir uma caixa de di\u00e1logo no Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-les-cellules.png\",\"datePublished\":\"2023-11-17T05:47:13+00:00\",\"dateModified\":\"2023-12-06T11:33:45+00:00\",\"description\":\"Neste tutorial, aprenderemos como usar uma caixa de di\u00e1logo no Excel. Para acessar mais op\u00e7\u00f5es de qualquer\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-les-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-les-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como abrir uma caixa de di\u00e1logo 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 abrir uma caixa de di\u00e1logo no Excel? (Tutorial 2023)","description":"Neste tutorial, aprenderemos como usar uma caixa de di\u00e1logo no Excel. Para acessar mais op\u00e7\u00f5es de qualquer","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\/caixa-de-dialogo\/","og_locale":"pt_PT","og_type":"article","og_title":"Como abrir uma caixa de di\u00e1logo no Excel? (Tutorial 2023)","og_description":"Neste tutorial, aprenderemos como usar uma caixa de di\u00e1logo no Excel. Para acessar mais op\u00e7\u00f5es de qualquer","og_url":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:33:45+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-les-cellules.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/","url":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/","name":"Como abrir uma caixa de di\u00e1logo no Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-les-cellules.png","datePublished":"2023-11-17T05:47:13+00:00","dateModified":"2023-12-06T11:33:45+00:00","description":"Neste tutorial, aprenderemos como usar uma caixa de di\u00e1logo no Excel. Para acessar mais op\u00e7\u00f5es de qualquer","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-les-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-formater-les-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/caixa-de-dialogo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como abrir uma caixa de di\u00e1logo 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\/86","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=86"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/86\/revisions"}],"predecessor-version":[{"id":770,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/86\/revisions\/770"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}