Como mudar a forma de comentários no Excel – Terminal de Informação

Aplicativos e Serviços / Windows

Como mudar a forma de comentários no Excel

Hoje vou mostrar como mudar o desenho das formas de comentário no Excel.

Recentemente um usuário precisou utilizar o LibreOffice, e por algum motivo, a planilha que ele usava, os comentários começaram a sair em formato de seta ao invés de retângulo, conforme print abaixo:

<img decoding="async" aria-describedby="caption-attachment-100486" data-attachment-id="100486" data-permalink="https://terminaldeinformacao.com/2020/09/02/como-mudar-a-forma-de-comentarios-no-excel/excel_01-4/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_01.png?fit=271%2C156&ssl=1" data-orig-size="271,156" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel_01" data-image-description="" data-image-caption="<p>Formato incorreto do comentário</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_01.png?fit=271%2C156&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_01.png?fit=271%2C156&ssl=1" class="size-full wp-image-100486" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_01.png?resize=271%2C156&ssl=1" alt="" width="271" height="156" data-recalc-dims="1">

Formato incorreto do comentário

Então para resolver isso, é bem simples, vamos lá.

No botão acima do Excel de Personalização do Acesso Rápido, clique em Mais Comandos

Opção Mais Comandos

Escolha a Guia de Ferramentas de Desenho | Formatar, encontre o Alterar Forma e clique em Adicionar

<img decoding="async" aria-describedby="caption-attachment-100488" data-attachment-id="100488" data-permalink="https://terminaldeinformacao.com/2020/09/02/como-mudar-a-forma-de-comentarios-no-excel/excel_03-3/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?fit=953%2C691&ssl=1" data-orig-size="953,691" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel_03" data-image-description="" data-image-caption="<p>Opção Alterar Forma</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?fit=300%2C218&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?fit=720%2C522&ssl=1" class="size-full wp-image-100488" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?resize=720%2C522&ssl=1" alt="" width="720" height="522" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?w=953&ssl=1 953w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?resize=300%2C218&ssl=1 300w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?resize=768%2C557&ssl=1 768w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?resize=740%2C537&ssl=1 740w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_03.png?resize=414%2C300&ssl=1 414w" sizes="(max-width: 720px) 100vw, 720px" data-recalc-dims="1" />

Opção Alterar Forma

Selecione a forma errada (no nosso caso em formato de seta), clique então no botão Alterar Forma, e escolha a opção desejada, como o Retângulo

<img decoding="async" aria-describedby="caption-attachment-100489" data-attachment-id="100489" data-permalink="https://terminaldeinformacao.com/2020/09/02/como-mudar-a-forma-de-comentarios-no-excel/excel_04-3/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_04.png?fit=378%2C419&ssl=1" data-orig-size="378,419" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel_04" data-image-description="" data-image-caption="<p>Forma Retângulo</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_04.png?fit=271%2C300&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_04.png?fit=378%2C419&ssl=1" class="size-full wp-image-100489" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_04.png?resize=378%2C419&ssl=1" alt="" width="378" height="419" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_04.png?w=378&ssl=1 378w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_04.png?resize=271%2C300&ssl=1 271w" sizes="(max-width: 378px) 100vw, 378px" data-recalc-dims="1" />

Forma Retângulo

Pronto, agora o comentário foi alterado, se tiver outros comentários com o formato incorreto, é só alterar utilizando o passo 3 novamente

<img decoding="async" aria-describedby="caption-attachment-100490" data-attachment-id="100490" data-permalink="https://terminaldeinformacao.com/2020/09/02/como-mudar-a-forma-de-comentarios-no-excel/excel_05-3/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_05.png?fit=270%2C193&ssl=1" data-orig-size="270,193" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="excel_05" data-image-description="" data-image-caption="<p>Verificando o comentário</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_05.png?fit=270%2C193&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_05.png?fit=270%2C193&ssl=1" class="size-full wp-image-100490" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/excel_05.png?resize=270%2C193&ssl=1" alt="" width="270" height="193" data-recalc-dims="1">

Verificando o comentário

Referência: https://www.officetooltips.com/excel_2016/tips/changing_a_comment_shape.html

Bom pessoal, por hoje é só.

Abraços e até a próxima.

Relacionado

Tags: Excel Microsoft Office

2 de setembro de 2020

<img alt='' src='https://secure.gravatar.com/avatar/49e8476dcf7c079a7d38808f17443657?s=128&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/49e8476dcf7c079a7d38808f17443657?s=256&d=mm&r=g 2x' class='avatar avatar-128 photo' height='128' width='128' decoding='async'/>

Dan (Daniel Atilio)

Cristão de ramificação protestante. Especialista em Engenharia de Software pela FIB, graduado em Banco de Dados pela FATEC Bauru e técnico em informática pelo CTI da Unesp. Entusiasta de soluções Open Source e blogueiro nas horas vagas. Autor e mantenedor do portal Terminal de Informação.

Deixe uma respostaCancelar resposta