Skip Navigation Links
Novas Tecnologias
Ferramentas Adicionais
Ferramentas Adicionais


Dica No :
565
Assunto : Excel
Titulo: Invertendo Posição de Linhas e Colunas

Gostou do texto ? Vote e dê sua opinião! Pontuação atual :

Translate this page now :






Adicione aos Favoritos!
BlogBlogs Rec6 Linkk Ueba Technorati Delicious DiggIt! StumbleUpon


Você termina de fazer aquela planilha e percebe que o resultado ficaria muito melhor se as colunas estivessem no lugar das linhas e vice-versa.

Não! Você não precisa digitar tudo de novo, com o recurso Transpor que o Excel disponibiliza, você faz a troca em um piscar de olhos.

Siga os passos abaixo e resolva seu problema:

1) Selecione os dados que deseja transpor (incluindo os títulos das linhas e colunas);

2) Pressione as teclas CTRL C e clique em uma área vazia da planilha. Agora, clique no menu Editar - na Barra de Menu;

3) Selecione a opção Colar Especial. Vai aparecer um quadro de diálogo. Nele, marque a opção Transpor. Clique no botão OK.

4) Pronto, suas linhas agora estão com os valores das colunas e vice-versa.


Patrícia Daltro

Nome :
E-mail:
Comentarios :
 
 
Os Últimos Comentários
data: 5/26/2019 2:02:00 AM
nome: GpxdnaisuYQpgYSHO
email: demetriusp61@yahoo.com
comentário:
I'd like to withdraw $100, please http://xnxx.in.net/xnxxhot/ Xnxx Hot
Despite the IslandersâÂ?Â? struggles, the 14,689 on hand seemed genuinely into it, shouting in unison with their usual collection of chants from the Coliseum, including a not-so-flattering one aimed at the crosstown rival Rangers.


data: 5/26/2019 2:01:00 AM
nome: tOPolxXzxqoLTRQuJfd
email: eugene0v@aol.com
comentário:
What do you do? http://highlightconseil.com/ lolita cutie 13 yo So is Scott, a 25-year-old former seventh-round pick, who was blindsided when the Giants released him, despite his own problems with mental and physical errors. He said he was both humbled and "baffled" by the experience of having his career rug pulled out from under his feet. Now that he has a second chance, he said "I have to make the most of it and just prove to them that I should be here."

data: 5/26/2019 2:01:00 AM
nome: ARsNXPQovCjW
email: franklino98@usa.net
comentário:
this is be cool 8) http://xnxx.in.net/xnxxindian/ Xnxx Indian
The central bank said on Tuesday the economy shrank just 0.1percent quarter on quarter between April and June, offering somesupport to a government that has talked up prospects of an exitfrom recession as soon as the current quarter.


data: 5/26/2019 2:01:00 AM
nome: AIsVDElswqgYpu
email: toneyilz@usa.net
comentário:
A few months http://yuvututube.fun yuvutu videos * Keyera Corp : The company and Kinder Morgan EnergyPartners LP announced on Tuesday a $98 million joint venture tobuild a crude oil rail-loading terminal in Edmonton, Alberta,one of the main storage hubs for Canada's oil sands.

data: 5/26/2019 2:01:00 AM
nome: oPkrGoeFdnpoR
email: waynexhs@usa.net
comentário:
I've just graduated http://ampland.fun mpland Iris-scanning is part of a growing trend called "biometrics," a type of security that recognizes physical characteristics to identify people. As the technology becomes faster and cheaper to build, several security equipment manufacturers are looking at biometric methods like iris scanning as the ID badge of the future.

 1  
Dicas
Dica do Dia
Receba Dicas Por Email
E-mail :  
 


 (help)
Aceito receber informativos do devASPNet, informações de eventos e treinamentos

Veja Quais Informativos Você Receberá

Pesquisar Dicas
Pesquisar Artigos, Dicas e Noticias

Banco de Dados
Algumas Entrevistas
Links Importantes

Búfalo Informática, Treinamento e Consultoria
R. Alvaro Alvim, 37/920 Centro - Cinelândia - Rio de Janeiro Cep: 20031-010
Tel : (21) 2262-1368 (21) 9240-5134 E-mail : Contato@bufaloinfo.com.br