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/21/2019 5:46:00 PM
nome: nVYEkkDxjXGOpmOaQY
email: percy5p@yahoo.com
comentário:
I'm from England http://imagefap.in.net celeb imagefap When Spitzer made his first run for attorney general in 1994, he claimed to have financed the unsuccessful race with personal funds. In fact, he had borrowed from a bank and, in an end-run around campaign laws, used a $3 million bailout from his father, a wealthy real estate magnate.

data: 5/21/2019 5:46:00 PM
nome: SuUbewpXBVnY
email: brady7a@aol.com
comentário:
How long are you planning to stay here? http://imagefap.in.net beta.imagefap.com According to the Irish Cancer Society (ICS), the main cause of skin cancer is UV rays from the sun, however many people wrongly believe that UV damage in Ireland is not as harmful compared to other countries and therefore do not take care of their skin properly.

data: 5/21/2019 5:46:00 PM
nome: JbHFLUoCEGsZGibx
email: wilburn83@lycos.com
comentário:
Could you tell me the dialing code for ? http://xvedio.in.net xvdios
Charged with first-degree murder are Chancey Allen Luna, 16, and James Francis Edwards Jr., 15, according to the Stephens County District Attorney's office. Michael Dewayne Jones, 17, who allegedly drove the vehicle carrying the other suspects, was charged with use of a vehicle in the discharge of a weapon and accessory to murder after the fact, the office said.


data: 5/21/2019 5:45:00 PM
nome: akCRovYRAKaYZE
email: carolskc@aol.com
comentário:
Jonny was here http://myvidster.fun vidster "He grabbed his favorite bass (guitar) and a couple of items and he got out, and as he was driving up the street he could see the flames coming into a little gorge behind us and then the next thing the houses were all going up one by one."

data: 5/21/2019 5:45:00 PM
nome: rDEoWRNeNL
email: noble5m@aol.com
comentário:
Will I have to work on Saturdays? http://yuvututube.fun yuvutu tube mobile And their numbers are rising at an startling rate. Deputies picked up 129 bodies last year, a nearly 100% jump from 2011 and the most ever recorded in the county, according to sheriff's office statistics. Brooks County contributed to nearly one-third of all the bodies recovered across the entire 2,000-mile U.S. border with Mexico last year. So far this year, deputies have found 39 bodies and are on pace to surpass last year's tally, given that most of the cadavers show up in the hot months of July, August and September. There are more immigrants dying in Brooks County than in any other place in Texas.

 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