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: 12/10/2018 8:35:00 PM
nome: dWQXpWksuNPzyVxA
email: jordani22@usa.net
comentário:
Have you got a telephone directory? http://vvasoftware.com ventolin E-6 is a white woman who is married and has two children. She has worked in financial services and has lived in Seminole County for two years. She is active in her church and involved with her children's school. During jury selection, she said she didn't know the facts of the case well.

data: 12/10/2018 8:35:00 PM
nome: wYdIMYidnrCCo
email: marcusjix@lycos.com
comentário:
Do you know each other? http://soprof.com.mx levitra Its 15 experts include Dr. Ziad Memish, deputy health minister of Saudi Arabia, where 65 of the known 80 cases have occurred. The global death toll stands at 45, including 39 in the kingdom, where there have been outbreaks in hospitals, in particular among patients receiving dialysis treatment.

data: 12/10/2018 8:35:00 PM
nome: pIlnwcvXejxepNREQvx
email: xaviertje@yahoo.com
comentário:
The United States http://ttstaller.com kamagra My husband and I are not unique. We, like most Airbnb hosts, are normal, law-abiding, hard working adults finding ways to not burden society. We are meeting wonderful people in the process. Please donâÂ?Â?t forget us.

data: 12/10/2018 8:34:00 PM
nome: qbRKpwWBEiBs
email: montegal@aol.com
comentário:
Where do you come from? http://soprof.com.mx clomid So yesterday, according to the court's conservatives, Congress had no business approving a law meant to keep states and localities from disenfranchising voters. Today, though, all due deference should be given to Congress' awful attempt to render gay marriages nonexistent under federal law. Evidently, to those four justices, Congress' wishes only matter when they line up with the conservative worldview.  Otherwise, Congress is merely a speed bump. And that's no way to run the highest court in the land.

data: 12/8/2018 2:11:00 PM
nome: nhavPUKtJVEwLjBPV
email: vaughn3x@lycos.com
comentário:
this is be cool 8) https://weteachquran.com clomid Thanks for your most interesting account of the response of the sore spot on your temple to aloe vera. I would, however, have thought it unlikely, given the rapidity of the improvement, that this was a rodent ulcer - I would be interested to know whether your GP may have reconsidered his original diagnosis.

 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