Se você quiser atualizar apenas os valores da planilha e manter os nomes dos cabeçalhos das tabelas iguais.

Passo 1

Alterar os valores necessários da planilha

Tabela de dados do Excel com seta | www.other-levels.com

Alterar valores da tabela de dados do Excel | www.other-levels.com.png

Passo 2

Vá para o menu Dados > Clique em Atualizar tudo

Menu de dados do Excel, Atualizar tudo | www.other-levels.com

Últimas histórias

Ver tudo

Import CSV and TXT File in Microsoft Excel (The Right way)

Learn how to import files using Microsoft Excel's Power Query, maintain clean structure, auto-refresh reports and create powerful dashboards with zero errors. Ideal for data professionals, analysts and business users!

Ler mais

Manage Complex Spreadsheets in Microsoft Excel with Custom Views

Microsoft Excel's Custom Views let you save time and instantly switch between tailored worksheet layouts. Perfect for dashboards, monthly reports, filtered datasets, print-ready views, or team-specific presentations. 

Ler mais

Learn Advanced Data Manipulation in Microsoft Excel

Unlock full potential of Microsoft Excel with the OFFSET Function. Learn how to automate your spreadsheets and create interactive, scalable and smart Excel reports.

Ler mais