{"id":2987,"date":"2021-05-18T08:05:45","date_gmt":"2021-05-18T08:05:45","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=2987"},"modified":"2021-07-23T11:50:20","modified_gmt":"2021-07-23T11:50:20","slug":"criar-lista-suspensa-no-excel","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel","title":{"rendered":"4 maneiras Para Criar Lista Suspensa 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<blockquote>\n<p style=\"text-align: justify;\"><strong>Resumo:<\/strong><\/p>\n<p style=\"text-align: justify;\">Este blog resume os detalhes completos sobre\u00a0<strong>como criar uma lista suspensa no Excel\u00a0<\/strong>usando diferentes truques.\u00a0Aprenda tamb\u00e9m\u00a0<strong>como adicionar \/ remover item da lista suspensa\u00a0<\/strong>ou etapas para\u00a0<strong>excluir a lista suspensa<\/strong>.<!--more--><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify;\"><strong><u>O que s\u00e3o listas de valida\u00e7\u00e3o de dados?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Criar a lista suspensa \u00e9 a melhor maneira de manter as entradas de dados em\u00a0uma estrutura\u00a0uniforme e livre de erros.\u00a0Voc\u00ea tamb\u00e9m pode restringir a entrada de valores que n\u00e3o deseja colocar em sua planilha.<\/p>\n<p style=\"text-align: justify;\">Apenas por esse motivo, tamb\u00e9m s\u00e3o conhecidas como listas de valida\u00e7\u00e3o de dados.\u00a0Portanto, apenas os dados v\u00e1lidos entrar\u00e3o na c\u00e9lula ap\u00f3s passar pelas condi\u00e7\u00f5es que voc\u00ea aplicou a ela.<\/p>\n<p style=\"text-align: justify;\">Adicionar lista suspensa na planilha do Excel \u00e9 muito \u00fatil quando v\u00e1rios usu\u00e1rios est\u00e3o inserindo dados na mesma planilha do Excel.\u00a0Por outro lado, voc\u00ea deseja atribuir op\u00e7\u00f5es limitadas \u00e0 lista de valores ou itens que j\u00e1 foram aprovados por voc\u00ea.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, tamb\u00e9m se pode usar a lista suspensa no Excel para criar modelos financeiros e relat\u00f3rios interativos onde o resultado \u00e9 alterado automaticamente quando o valor da c\u00e9lula \u00e9 alterado.<\/p>\n<p style=\"text-align: justify;\">Um dos recursos mais \u00fateis da valida\u00e7\u00e3o de dados \u00e9 a capacidade de criar uma lista suspensa\u00a0que permite aos usu\u00e1rios selecionar um valor de uma lista predefinida.<\/p>\n<h2 style=\"text-align: justify;\"><strong><u>Como Para Criar Lista Suspensa No Excel?<\/u><\/strong><\/h2>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo 1 # Criar lista suspensa simples<\/u><\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li>Em sua nova planilha do Excel, voc\u00ea deve digitar os dados que deseja mostrar na lista suspensa.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">\u00c9 melhor ter uma lista de itens na tabela do Excel, mas se voc\u00ea n\u00e3o tiver, converta a lista em tabela fazendo a sele\u00e7\u00e3o dos intervalos de c\u00e9lulas e pressionando a\u00a0guia\u00a0Ctrl + T.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2991\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-1.png\" alt=\"Criar Lista Suspensa No Excel 1\" width=\"123\" height=\"211\" \/><\/p>\n<p style=\"text-align: justify;\">Notas:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Por que voc\u00ea deve colocar seus dados em uma tabela?\u00a0Quando seus dados est\u00e3o em uma tabela, conforme voc\u00ea\u00a0adiciona ou remove itens da lista, todos os menus suspensos baseados nessa tabela ser\u00e3o atualizados automaticamente.\u00a0Voc\u00ea n\u00e3o precisa fazer mais nada.<\/li>\n<li>Agora \u00e9 um bom momento para\u00a0classificar os dados em um intervalo ou tabela em sua lista suspensa.<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"2\">\n<li>Escolha a c\u00e9lula da planilha onde voc\u00ea precisa inserir a lista suspensa.<\/li>\n<li>Agora acesse a\u00a0guia\u00a0Dados\u00a0&gt;\u00a0Valida\u00e7\u00e3o de dados na faixa\u00a0do Excel.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2992\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-2.png\" alt=\"Criar Lista Suspensa No Excel 2\" width=\"686\" height=\"183\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-2.png 686w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-2-300x80.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/p>\n<p style=\"text-align: justify;\">Observa\u00e7\u00e3o:<\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea n\u00e3o conseguir acessar a\u00a0guia\u00a0Valida\u00e7\u00e3o de dados\u00a0, isso significa que sua planilha est\u00e1 protegida ou compartilhada.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Ent\u00e3o, imediatamente, desbloqueie a se\u00e7\u00e3o espec\u00edfica de sua pasta de trabalho protegida ou apenas desative o compartilhamento da planilha.<\/li>\n<li>Depois disso, tente apenas as etapas restantes.<\/li>\n<li>Na\u00a0guia\u00a0Configura\u00e7\u00f5es,\u00a0voc\u00ea deve clicar na\u00a0caixa\u00a0Permitir\u00a0e, em seguida, escolher a\u00a0op\u00e7\u00e3o\u00a0Lista\u00a0.<\/li>\n<li>V\u00e1 para a\u00a0caixa\u00a0Fonte\u00a0e escolha o intervalo da lista.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">No exemplo mostrado, estamos colocando nossos dados na planilha denominada cidades em\u00a0A2: A9.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2993\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-3.png\" alt=\"Criar Lista Suspensa No Excel 3\" width=\"433\" height=\"292\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-3.png 433w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-3-300x202.png 300w\" sizes=\"auto, (max-width: 433px) 100vw, 433px\" \/><\/p>\n<p style=\"text-align: justify;\">Lembre-se: deixamos a linha do cabe\u00e7alho apenas porque n\u00e3o precisamos inclu\u00ed-la na \u00e1rea de sele\u00e7\u00e3o:<\/p>\n<ol style=\"text-align: justify;\" start=\"6\">\n<li>Se voc\u00ea n\u00e3o quiser que a c\u00e9lula vazia crie qualquer tipo de problema, marque o campo\u00a0Ignorar em branco. Marque\u00a0tamb\u00e9m a\u00a0op\u00e7\u00e3o\u00a0suspensa Na c\u00e9lula\u00a0.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2994\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-4.png\" alt=\"Criar Lista Suspensa No Excel 4\" width=\"394\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-4.png 394w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-4-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"7\">\n<li>Acesse a mensagem de entrada\n<ul>\n<li>Para fazer uma caixa de mensagem aparecer quando voc\u00ea toca na c\u00e9lula, nesse caso voc\u00ea precisa escolher\u00a0\u201cMostrar mensagem de entrada quando a c\u00e9lula for selecionada\u201d<\/li>\n<li>Agora atribua o t\u00edtulo e a mensagem que deseja mostrar na caixa de di\u00e1logo, ou seja, at\u00e9 255 caracteres.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">No caso, voc\u00ea n\u00e3o precisa mostrar nenhuma mensagem, ent\u00e3o deixe a op\u00e7\u00e3o\u00a0\u201cmostrar mensagem de entrada quando a c\u00e9lula for selecionada\u201d\u00a0desmarcada.<\/p>\n<ol style=\"text-align: justify;\" start=\"8\">\n<li>V\u00e1 para o \u201c\u00a0Alerta de erro\u201d.<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li>No caso de aparecer uma caixa de mensagem quando algu\u00e9m colocar algo errado que n\u00e3o esteja na sua lista, marque a\u00a0op\u00e7\u00e3o \u201c\u00a0Mostrar alerta de erro ap\u00f3s a inser\u00e7\u00e3o de dados inv\u00e1lidos\u201d\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2995\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-5.png\" alt=\"Criar Lista Suspensa No Excel 5\" width=\"396\" height=\"321\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-5.png 396w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-5-300x243.png 300w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Depois disso, escolha uma op\u00e7\u00e3o na\u00a0caixa\u00a0Estilo\u00a0:\u00a0Informa\u00e7\u00e3o, Aviso\u00a0e Pare.\u00a0Depois disso, digite o\u00a0t\u00edtulo\u00a0e\u00a0a mensagem de erro\u00a0.\u00a0Se voc\u00ea n\u00e3o quiser exibir nenhuma mensagem pop-up, remova o texto da\u00a0se\u00e7\u00e3o de\u00a0mensagem de erro\u00a0e desmarque\u00a0\u201cmostrar alerta de erro ap\u00f3s a inser\u00e7\u00e3o de dados inv\u00e1lidos\u201d.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2996\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-6.png\" alt=\"Criar Lista Suspensa No Excel 6\" width=\"394\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-6.png 394w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-6-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"9\">\n<li>Se voc\u00ea est\u00e1 confuso sobre as op\u00e7\u00f5es de escolha na\u00a0caixa\u00a0Estilo\u00a0.\u00a0Ent\u00e3o leia isto:<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Informa\u00e7\u00e3o ou aviso: a\u00a0escolha desta op\u00e7\u00e3o mostra a mensagem, mas n\u00e3o impede que os usu\u00e1rios insiram dados indispon\u00edveis na lista suspensa.<\/p>\n<p style=\"text-align: justify;\">Parar:\u00a0esta op\u00e7\u00e3o impedir\u00e1 que os usu\u00e1rios insiram dados que n\u00e3o estejam presentes na lista suspensa.<\/p>\n<p style=\"text-align: justify;\">Observa\u00e7\u00e3o:<\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea se esqueceu de adicionar o t\u00edtulo ou a mensagem de erro, por padr\u00e3o, o t\u00edtulo ser\u00e1 considerado como Microsoft Excel e a mensagem ser\u00e1 considerada como &#8220;O valor inserido n\u00e3o \u00e9 v\u00e1lido. Um usu\u00e1rio restringiu valores que podem ser inseridos nesta c\u00e9lula.&#8221;<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo 2 # Criar\u00a0lista\u00a0suspensa\u00a0que\u00a0permite outras entradas\u00a0<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Voc\u00ea pode facilmente <strong>criar<\/strong><strong>\u00a0lista suspensa no Excel\u00a0<\/strong>que permite outras entradas.\u00a0Aqui est\u00e3o as etapas que voc\u00ea precisa realizar:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Insira o valor que n\u00e3o est\u00e1 dispon\u00edvel na lista suspensa ap\u00f3s este Excel exibir o alerta de erro.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Nesse caso, para permitir outras entradas, execute as seguintes etapas.<\/p>\n<ul style=\"text-align: justify;\">\n<li>V\u00e1 para a guia Dados depois do grupo Ferramentas de Dados , clique no \u00edcone Valida\u00e7\u00e3o de Dados.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2997\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-7.png\" alt=\"Criar Lista Suspensa No Excel 7\" width=\"686\" height=\"183\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-7.png 686w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-7-300x80.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/p>\n<p style=\"text-align: justify;\">Isso abrir\u00e1 a caixa de di\u00e1logo\u00a0&#8216;Valida\u00e7\u00e3o de dados&#8217;.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora voc\u00ea tem que passar para o\u00a0Alerta de erro\u00a0de tabula\u00e7\u00e3o e\u00a0desmarque\u00a0o\u00a0&#8216;alerta erro Mostrar ap\u00f3s dados inv\u00e1lido for inserido&#8217;\u00a0op\u00e7\u00e3o.<\/li>\n<li>Clique no\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<li>Agora voc\u00ea pode inserir facilmente o valor que n\u00e3o est\u00e1 presente na lista suspensa.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2998\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-8.png\" alt=\"Criar Lista Suspensa No Excel 8\" width=\"394\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-8.png 394w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-8-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo 3 # Lista suspensa din\u00e2mica<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Outra forma muito interessante \u00e9\u00a0<strong>criar lista suspensa din\u00e2mica no Excel <\/strong>para que sempre que qualquer item for adicionado ou exclu\u00eddo da lista, ele seja atualizado automaticamente.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Na sua primeira planilha, escolha a c\u00e9lula\u00a0B1\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2999\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-9.png\" alt=\"Criar Lista Suspensa No Excel 9\" width=\"604\" height=\"81\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-9.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-9-300x40.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>V\u00e1 para a guia Dados e, a partir do grupo Ferramentas de dados , clique no \u00edcone Valida\u00e7\u00e3o de Dados.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3020\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-10.png\" alt=\"Criar Lista Suspensa No Excel 10\" width=\"446\" height=\"100\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-10.png 446w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-10-300x67.png 300w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/p>\n<p style=\"text-align: justify;\">Isso abrir\u00e1 automaticamente a caixa de di\u00e1logo\u00a0de\u00a0&#8216;\u00a0Valida\u00e7\u00e3o de\u00a0dados\u00a0&#8216;<\/p>\n<ul style=\"text-align: justify;\">\n<li>Na\u00a0caixa\u00a0Permitir\u00a0, clique na\u00a0op\u00e7\u00e3o\u00a0Lista\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3000\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-11.png\" alt=\"Criar Lista Suspensa No Excel 8\" width=\"394\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-11.png 394w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-11-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Toque na\u00a0caixa\u00a0Fonte\u00a0e depois insira esta\u00a0f\u00f3rmula: = OFFSET (Sheet2! $ A $ 1,0,0, COUNTA (Sheet2! $ A: $ A), 1)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3001\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-12.png\" alt=\"Criar Lista Suspensa No Excel 12\" width=\"604\" height=\"215\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-12.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-12-300x107.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\">Explica\u00e7\u00e3o:\u00a0aqui a\u00a0fun\u00e7\u00e3o\u00a0OFFSET\u00a0do\u00a0Excel\u00a0usa os 5 argumentos.\u00a0Refer\u00eancia: Folha2! $ A $ 1, linhas a deslocar: 0, colunas a deslocar: 0, altura: CONTAR.VAL (Folha2! $ A: $ A) e largura: 1.\u00a0CONTAR.VAL (Folha2! $ A: $ A)\u00a0conta o n\u00famero de valores na coluna A na Folha2 que n\u00e3o est\u00e3o vazios.\u00a0Quando voc\u00ea adiciona um item \u00e0 lista na Planilha2,\u00a0CONT.valores (\u00a0Planilha2! $ A: $ A)\u00a0aumenta.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3002\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-13.png\" alt=\"Criar Lista Suspensa No Excel 13\" width=\"604\" height=\"141\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-13.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-13-300x70.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\">Isso dar\u00e1 a voc\u00ea o resultado de que o intervalo retornado da fun\u00e7\u00e3o OFFSET \u00e9 expandido e tamb\u00e9m atualiza a lista suspensa.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique no\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<li>V\u00e1 para a segunda folha e adicione qualquer novo item no final da lista.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Resultado:<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo 4 #\u00a0Listas\u00a0suspensas de dependentes<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Vamos saber como voc\u00ea pode criar uma lista suspensa dependente no Excel.\u00a0Aqui est\u00e1 um exemplo para mostrar\u00a0<strong>como criar listas suspensas dependentes\u00a0no\u00a0Excel.\u00a0\u00a0<\/strong><\/p>\n<p style=\"text-align: justify;\">De uma lista suspensa quando o usu\u00e1rio escolhe a pizza.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3021\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-14.png\" alt=\"Criar Lista Suspensa No Excel 14\" width=\"604\" height=\"101\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-14.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-14-300x50.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o, na segunda lista suspensa, as variantes de pizza come\u00e7am a aparecer.\u00a0Execute as etapas a seguir para criar listas suspensas dependentes no Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3004\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-16.png\" alt=\"Criar Lista Suspensa No Excel 16\" width=\"604\" height=\"101\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-16.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-16-300x50.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>V\u00e1 para a segunda planilha, para criar os seguintes intervalos nomeados.<\/li>\n<\/ul>\n<table width=\"292\">\n<tbody>\n<tr>\n<td width=\"178\">Nome<\/td>\n<td width=\"114\">Endere\u00e7o de intervalo<\/td>\n<\/tr>\n<tr>\n<td>Comida<\/td>\n<td>A1: A3<\/td>\n<\/tr>\n<tr>\n<td>pizza<\/td>\n<td>B1: B4<\/td>\n<\/tr>\n<tr>\n<td>Panquecas<\/td>\n<td>C1: C2<\/td>\n<\/tr>\n<tr>\n<td>chin\u00eas<\/td>\n<td>D1: D3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul style=\"text-align: justify;\">\n<li>Na sua primeira planilha, basta escolher a c\u00e9lula\u00a0B1.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3005\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-17.png\" alt=\"Criar Lista Suspensa No Excel 17\" width=\"604\" height=\"215\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-17.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-17-300x107.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>V\u00e1 para a guia Dados e depois do grupo Ferramentas de Dados, clique no\u00a0\u00edcone\u00a0Valida\u00e7\u00e3o de Dados\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3006\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-18.png\" alt=\"Criar Lista Suspensa No Excel 18\" width=\"446\" height=\"100\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-18.png 446w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-18-300x67.png 300w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/p>\n<p style=\"text-align: justify;\">Isso abrir\u00e1 a caixa de di\u00e1logo\u00a0&#8216;Valida\u00e7\u00e3o de dados&#8217;.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, na guia de configura\u00e7\u00e3o, v\u00e1 para a caixa Permitir e toque na op\u00e7\u00e3o Lista<\/li>\n<li>Na caixa Fonte, digite o\u00a0tipo de\u00a0texto\u00a0= Comida.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3007\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-19.png\" alt=\"Criar Lista Suspensa No Excel 19\" width=\"394\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-19.png 394w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-19-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique no\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Resultado:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3008\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-20.png\" alt=\"Criar Lista Suspensa No Excel 20\" width=\"604\" height=\"101\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-20.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-20-300x50.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora escolha a c\u00e9lula\u00a0E1.<\/li>\n<li>Na caixa de di\u00e1logo de valida\u00e7\u00e3o de dados aberta, v\u00e1 para a\u00a0guia de\u00a0configura\u00e7\u00f5es\u00a0e, em seguida, na caixa Permitir toque na\u00a0op\u00e7\u00e3o\u00a0Lista\u00a0.<\/li>\n<li>Na caixa Fonte, digite o\u00a0tipo de\u00a0texto\u00a0=\u00a0INDIRETO (\u00a0$ B $ 1).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3009\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-21.png\" alt=\"Criar Lista Suspensa No Excel 21\" width=\"394\" height=\"319\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-21.png 394w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-21-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Pressione o bot\u00e3o OK.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Resultado:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3010\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-22.png\" alt=\"Criar Lista Suspensa No Excel 22\" width=\"604\" height=\"101\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-22.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-22-300x50.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\">Explica\u00e7\u00e3o:\u00a0aqui a\u00a0fun\u00e7\u00e3o\u00a0INDIRETA\u00a0fornecer\u00e1 a refer\u00eancia especificada principalmente pela sequ\u00eancia de texto.\u00a0Suponha que o usu\u00e1rio selecione a categoria de comida chinesa em sua primeira lista suspensa.\u00a0=\u00a0INDIRETO (\u00a0$ B $ 1)\u00a0.\u00a0Isso fornecer\u00e1 as refer\u00eancias do item chin\u00eas.\u00a0Devido a isso, na segunda lista suspensa com os itens chineses.<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Come Aggiungi \/ Rimuovi Articoli da drop-down Lista?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Mesmo sem usar a\u00a0op\u00e7\u00e3o\u00a0&#8216;Valida\u00e7\u00e3o de dados&#8217;\u00a0e fazer altera\u00e7\u00f5es na refer\u00eancia do intervalo, voc\u00ea pode facilmente adicionar \/ excluir itens da\u00a0lista suspensa do Excel.<\/p>\n<p style=\"text-align: justify;\"><strong>Vamos saber como\u2026!<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Para adicionar um item na lista suspensa, escolha primeiro o item que\u00a0deseja\u00a0adicionar.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3011\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-23.png\" alt=\"Criar Lista Suspensa No Excel 23\" width=\"604\" height=\"175\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-23.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-23-300x87.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique com o bot\u00e3o direito e selecione a op\u00e7\u00e3o Inserir.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3012\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-24.png\" alt=\"Criar Lista Suspensa No Excel 24\" width=\"137\" height=\"300\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha a op\u00e7\u00e3o &#8220;Shift c\u00e9lulas para baixo&#8221; e aperte o bot\u00e3o OK.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3013\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-25.png\" alt=\"Criar Lista Suspensa No Excel 25\" width=\"173\" height=\"178\" \/><\/p>\n<p style=\"text-align: justify;\">Resultado:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3014\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-26.png\" alt=\"Criar Lista Suspensa No Excel 26\" width=\"604\" height=\"195\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-26.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-26-300x97.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\">Observa\u00e7\u00e3o:<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea notar\u00e1 que automaticamente a refer\u00eancia de intervalo \u00e9 deslocada da Planilha2\u00a0! $\u00a0A $ 1: $ A $ 3 para a Planilha2! $ A $ 1: $ A $ 4.\u00a0Para verificar isso, abra a caixa de di\u00e1logo de\u00a0&#8216;Valida\u00e7\u00e3o de dados&#8217;.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Insira qualquer novo item que voc\u00ea deseja adicionar.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3015\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-27.png\" alt=\"Criar Lista Suspensa No Excel 27\" width=\"604\" height=\"195\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-27.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-27-300x97.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e1 o resultado:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3016\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-28.png\" alt=\"Criar Lista Suspensa No Excel 28\" width=\"604\" height=\"121\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-28.png 604w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-28-300x60.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Para remover qualquer item da lista suspensa, pule o passo 2 e clique na op\u00e7\u00e3o Excluir . Escolha a op\u00e7\u00e3o &#8220;Shift c\u00e9lulas para cima&#8221; e clique na guia OK.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><strong><u>Como\u00a0Para\u00a0Remover A Lista Suspensa No Excel?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Aqui est\u00e3o as etapas que voc\u00ea precisa executar para\u00a0<strong>remover a lista suspensa no Excel<\/strong>.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha a c\u00e9lula que cont\u00e9m a lista suspensa.<\/li>\n<li>V\u00e1 para a guia Dados e, a partir do grupo Ferramentas de Dados , escolha o \u00edcone Valida\u00e7\u00e3o de Dados.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3017\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-29.png\" alt=\"Criar Lista Suspensa No Excel 29\" width=\"686\" height=\"183\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-29.png 686w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-29-300x80.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/p>\n<p style=\"text-align: justify;\">Depois disso, voc\u00ea ver\u00e1 que uma caixa de di\u00e1logo de\u00a0&#8216;Valida\u00e7\u00e3o de dados&#8217;\u00a0come\u00e7a a aparecer na tela.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique no bot\u00e3o Limpar tudo.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3018\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-30.png\" alt=\"Criar Lista Suspensa No Excel 30\" width=\"725\" height=\"343\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-30.png 725w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-30-300x142.png 300w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/p>\n<p style=\"text-align: justify;\">Observa\u00e7\u00e3o:<\/p>\n<p style=\"text-align: justify;\">Para remover listas suspensas inteiras : na caixa de di\u00e1logo de valida\u00e7\u00e3o de dados aberta, marque a op\u00e7\u00e3o &#8220;Aplicar essas altera\u00e7\u00f5es a todas as outras c\u00e9lulas com as mesmas configura\u00e7\u00f5es&#8221; antes de selecionar o bot\u00e3o Limpar tudo.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique no bot\u00e3o OK.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><strong><u>Como\u00a0Para\u00a0Recuperar Corrupt \/ perdido \/ apagou Excel arquivo de dados?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Voc\u00ea j\u00e1 pensou que iniciativa tomar\u00e1 se, de repente, os dados do seu arquivo Excel forem perdidos ou exclu\u00eddos de alguma forma? Bem, para lidar com tal situa\u00e7\u00e3o, eu tenho uma solu\u00e7\u00e3o simples, ou seja, usar\u00a0<a href=\"https:\/\/pt.repairmsexcel.com\/baixar-julgamento.php\" target=\"_blank\" rel=\"noopener\"><strong>Excel recupera\u00e7\u00e3o Ferramenta<\/strong><\/a>,\u00a0este software ajuda voc\u00ea a recuperar arquivos do Excel exclu\u00eddos, corrompidos ou perdidos, mesmo sem qualquer backup.\u00a0N\u00e3o s\u00f3 isso, ele tamb\u00e9m \u00e9 capaz de\u00a0<strong>reparar arquivos Excel (XLS e XLSX) corrompidos e danificados\u00a0<\/strong>e\u00a0<strong>corrigir erros do Excel\u00a0<\/strong>tamb\u00e9m.<\/p>\n<p style=\"text-align: justify;\">Com isso, voc\u00ea pode\u00a0recuperar\u00a0gr\u00e1fico, planilha de gr\u00e1fico, tabela, coment\u00e1rio de c\u00e9lula, imagem, coment\u00e1rio de c\u00e9lula, f\u00f3rmula e classificar e filtrar\u00a0e todos os componentes de dados de arquivo Excel corrompido.<\/p>\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<ul style=\"text-align: justify;\">\n<li>Recupere e repare ambos rapidamente . xls e. arquivo xlsx.<\/li>\n<li>Restaure facilmente\u00a0v\u00e1rios arquivos do Excel corrompidos\u00a0simultaneamente.<\/li>\n<li>Restaure tudo, incluindo\u00a0planilhas, coment\u00e1rios de c\u00e9lulas, propriedades da planilha, gr\u00e1ficos e outros dados.<\/li>\n<li>Muito f\u00e1cil de usar para que at\u00e9 mesmo um usu\u00e1rio novato tamb\u00e9m possa us\u00e1-lo.<\/li>\n<li>Suporta sistemas operacionais Windows e Mac.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><strong><u>Conclus\u00e3o:<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Adotar a ideia da lista suspensa dependente \u00e9 realmente muito legal e f\u00e1cil de fazer.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea pode criar n\u00fameros de\u00a0<strong>listas suspensas dependentes na planilha do Excel<\/strong>.\u00a0Por\u00e9m, \u00e0 medida que o n\u00famero desse tipo de lista suspensa aumenta, todos os dados s\u00e3o complexos.\u00a0ent\u00e3o\u00a0\u00e9 melhor us\u00e1-lo em um estado menos complexo.<\/p>\n<p style=\"text-align: justify;\">Espero que a postagem acima ajude voc\u00ea a\u00a0<strong>criar uma lista suspensa no Excel<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Portanto, sem perder mais tempo,\u00a0<strong>crie listas suspensas na planilha do Excel\u00a0<\/strong>que permita aos usu\u00e1rios fazer a sele\u00e7\u00e3o para o valor da lista predefinida.<\/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>Resumo: Este blog resume os detalhes completos sobre\u00a0como criar uma lista suspensa no Excel\u00a0usando diferentes truques.\u00a0Aprenda tamb\u00e9m\u00a0como adicionar \/ remover &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"4 maneiras Para Criar Lista Suspensa No Excel\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel#more-2987\" aria-label=\"Read more about 4 maneiras Para Criar Lista Suspensa No Excel\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":3023,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[1171,1168,1170,1169,1172],"class_list":["post-2987","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-como-criar-uma-lista-suspensa-no-excel","tag-crie-uma-lista-suspensa-no-excel","tag-lista-suspensa-dinamica","tag-listas-suspensas-dependentes","tag-remover-itens-de-lista-suspensa","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>4 maneiras Para Criar Lista Suspensa No Excel<\/title>\n<meta name=\"description\" content=\"Aprenda truques f\u00e1ceis para criar uma lista suspensa no Excel. Obtenha mais detalhes sobre como adicionar ou remover itens da lista suspensa.\" \/>\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\/criar-lista-suspensa-no-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"4 maneiras Para Criar Lista Suspensa No Excel\" \/>\n<meta property=\"og:description\" content=\"Aprenda truques f\u00e1ceis para criar uma lista suspensa no Excel. Obtenha mais detalhes sobre como adicionar ou remover itens da lista suspensa.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-18T08:05:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-23T11:50:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"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=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"4 maneiras Para Criar Lista Suspensa No Excel\",\"datePublished\":\"2021-05-18T08:05:45+00:00\",\"dateModified\":\"2021-07-23T11:50:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel\"},\"wordCount\":2042,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/Create-Drop-Down-List-In-Excel-pt.png\",\"keywords\":[\"como criar uma lista suspensa no Excel\",\"crie uma lista suspensa no Excel\",\"Lista suspensa din\u00e2mica\",\"Listas suspensas dependentes\",\"Remover itens De Lista Suspensa\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel\",\"name\":\"4 maneiras Para Criar Lista Suspensa No Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/Create-Drop-Down-List-In-Excel-pt.png\",\"datePublished\":\"2021-05-18T08:05:45+00:00\",\"dateModified\":\"2021-07-23T11:50:20+00:00\",\"description\":\"Aprenda truques f\u00e1ceis para criar uma lista suspensa no Excel. Obtenha mais detalhes sobre como adicionar ou remover itens da lista suspensa.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/Create-Drop-Down-List-In-Excel-pt.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/Create-Drop-Down-List-In-Excel-pt.png\",\"width\":1280,\"height\":720,\"caption\":\"4 maneiras Para Criar Lista Suspensa No Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-lista-suspensa-no-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"4 maneiras Para Criar Lista Suspensa 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":"4 maneiras Para Criar Lista Suspensa No Excel","description":"Aprenda truques f\u00e1ceis para criar uma lista suspensa no Excel. Obtenha mais detalhes sobre como adicionar ou remover itens da lista suspensa.","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\/criar-lista-suspensa-no-excel","og_locale":"en_US","og_type":"article","og_title":"4 maneiras Para Criar Lista Suspensa No Excel","og_description":"Aprenda truques f\u00e1ceis para criar uma lista suspensa no Excel. Obtenha mais detalhes sobre como adicionar ou remover itens da lista suspensa.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2021-05-18T08:05:45+00:00","article_modified_time":"2021-07-23T11:50:20+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-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":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"4 maneiras Para Criar Lista Suspensa No Excel","datePublished":"2021-05-18T08:05:45+00:00","dateModified":"2021-07-23T11:50:20+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel"},"wordCount":2042,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-pt.png","keywords":["como criar uma lista suspensa no Excel","crie uma lista suspensa no Excel","Lista suspensa din\u00e2mica","Listas suspensas dependentes","Remover itens De Lista Suspensa"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel","url":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel","name":"4 maneiras Para Criar Lista Suspensa No Excel","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-pt.png","datePublished":"2021-05-18T08:05:45+00:00","dateModified":"2021-07-23T11:50:20+00:00","description":"Aprenda truques f\u00e1ceis para criar uma lista suspensa no Excel. Obtenha mais detalhes sobre como adicionar ou remover itens da lista suspensa.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-pt.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-In-Excel-pt.png","width":1280,"height":720,"caption":"4 maneiras Para Criar Lista Suspensa No Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-lista-suspensa-no-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"4 maneiras Para Criar Lista Suspensa 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\/2987","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=2987"}],"version-history":[{"count":6,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2987\/revisions"}],"predecessor-version":[{"id":3365,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2987\/revisions\/3365"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/3023"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=2987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=2987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=2987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}