Cov txheej txheem:

Yuav ua li cas hloov cov ntaub ntawv los ntawm kab rau kab hauv Excel?
Yuav ua li cas hloov cov ntaub ntawv los ntawm kab rau kab hauv Excel?

Video: Yuav ua li cas hloov cov ntaub ntawv los ntawm kab rau kab hauv Excel?

Video: Yuav ua li cas hloov cov ntaub ntawv los ntawm kab rau kab hauv Excel?
Video: Cas Tus Nim No Txawv Deb Tus Thaum Ub Ua Luaj Li Lawm? 8/8/2021 2024, Kaum ib hlis
Anonim

Pib los ntawm kev xaiv thiab luam koj tag nrho cov ntaub ntawv ntau. Nyem rau ntawm qhov chaw tshiab hauv koj daim ntawv, ces mus rau Kho kom raug | Paste Tshwj xeeb thiab xaiv lub Transpose kos lub thawv, qhia hauv daim duab B. Nyem OK, thiab Excel yuav transpose kem thiab kab daim ntawv lo thiab cov ntaub ntawv , raws li qhia hauv daim duab C.

Ib yam li ntawd, tib neeg nug, koj hloov kab hauv Excel li cas?

Qhib lub Excel cov ntaub ntawv koj xav hloov cov hlwb, kab, lossis kab nyob rau hauv. Xaiv lub cell, kab , lossis kab koj xav hloov cov ntsiab lus ntawm, thiab tuav cia Hloov tus yuam sij. Tom ntej no, nyem rau ntawm tus ciam teb sab xis ntawm lub xov tooj ntawm tes, thiab luag nws tawm mus. Txhob tso lub Hloov tus yuam sij.

Tom qab ntawd, lo lus nug yog, ua li cas koj hloov pauv hauv Excel? TRANSPOSE muaj nuj nqi

  1. Kauj Ruam 1: Xaiv cov cell dawb. Ua ntej xaiv qee lub hlwb dawb.
  2. Kauj Ruam 2: Hom = TRANSPOSE(Nrog cov hlwb dawb paug tseem xaiv, hom: =TRANSPOSE(
  3. Kauj ruam 3: Ntaus qhov ntau ntawm cov thawj cov hlwb. Tam sim no ntaus therange ntawm cov hlwb koj xav hloov pauv.
  4. Kauj ruam 4: Thaum kawg, nias CTRL + SHIFT + ENTER. Tam sim no nias CTRL + SHIFT + ENTER.

Ib sab saum toj no, koj yuav ua li cas hloov tag nrho kem hauv Excel?

Yuav ua li cas rub kab hauv Excel

  1. Xaiv lub kem koj xav txav.
  2. Muab tus nas pointer rau ntawm ntug ntawm qhov kev xaiv kom txog thaum nws hloov ntawm tus ntoo khaub lig mus rau 4-sided xub cursor.
  3. Nias thiab tuav tus yuam sij ua haujlwm, thiab tom qab ntawd rub kab ke mus rau qhov chaw tshiab.
  4. Yog li ntawd!

Muaj pes tsawg kab thiab kab hauv Excel?

16384

Pom zoo: