Hloov ntawm kab dav dav thiab kab Heights hauv Excel thiab Google Spreadsheets

01 ntawm 02

Hloov Pauv Dav Dav thiab Qis Heights nrog lub Nas

Hloov Ncau Ncej Siv Tus Nas. © Ted Fabkis

Txoj kev rau txhua tus thiab hloov cov Heights

Muaj ntau txoj hau kev ntawm kev nthuav dav hauv Excel thiab Google Spreadsheets. Cov ntaub ntawv qhia txog ntau txoj kev tuaj yeem nrhiav tau ntawm cov nplooj ntawv nram qab no:

Lus Cim : Nws tseem tsis tau hloov qhov dav lossis qhov siab ntawm ib lub xov tooj ntawm tes - qhov dav yuav tsum tau hloov rau tag nrho cov kem lossis qhov siab rau tag nrho cov kab.

Hloov Ntaub Ntej Sab Ncej Nrog Tus Nas

Cov kauj ruam hauv qab no qhia txog yuav ua li cas hloov ib tus tib neeg txhua tus siv cov nas. Txhawm rau sab sab A piv txwv:

  1. Muab tus pointer pointer rau kab ciam ntawm kab A thiab B ntawm sab header
  2. Tus pointer yuav hloov mus rau ob npaug - taws dub xub qhia raws li qhia hauv daim duab saum toj no
  3. Nyem thiab puag lawm ntawm sab laug nas khawm thiab luag ob npaug-xub xub mus rau sab xis sab sab A los rau sab laug ua rau sab khab narrower
  4. Tso tus nas khawm thaum lub qhov laj siab xav mus txog

AutoFit Kem dav dav Siv cov nas

Lwm txoj kev zom los yog ua si nrog txhua tus nas yog cia Excel lossis Google Spreadsheets Pib Haum lub dav ntawm sab mus rau qhov ntev tshaj plaws ntawm cov ntaub ntawv muaj nyob hauv kem.

Rau cov ntaub ntawv ntev, lub sab yuav pib, tab sis yog lub kem tsuas muaj cov khoom luv ntawm cov ntaub ntawv, kem yuav nqaim kom haum rau cov khoom no.

Piv txwv: Hloov qhov dav ntawm kem B siv AutoFit

  1. Muab tus pointer pointer rau kab ciam ntawm kab B thiab C ntawm sab header. Tus pointer yuav hloov mus rau ob-coj xub.

  2. Ob npaug nias nrog cov laug nas khawm. Kem yuav tau kho nws cov dav kom phim tus nkag ntev tshaj plaws hauv sab ntawd

Hloov Txhua Yam Ncua Nthuav Dav Rau Hauv Daim Ntawv Cuam Tshuam Siv Cov Nas

Txhim kho tag nrho cov kem dav dav

  1. Ndliv qhov Select All All khawm saum toj lub taub hau khawm kom pom tag nrho txhua kab ntawv hauv daim ntawv sau ua haujlwm tam sim no.
  2. Muab tus pointer pointer rau kab ciam ntawm kab A thiab B ntawm sab header
  3. Tus pointer yuav hloov mus rau ob-coj xub.
  4. Nias ntawm sab laug nas khawm thiab cab ob-coj xub mus rau sab xis kom tag txhua kab hauv daim ntawv los yog sab laug ua kom txhua tus khoov zis.

Hloov Cov Heights nrog lub Nas

Cov kev xaiv thiab cov kauj ruam yuav hloov kab heights nyob rau hauv Excel thiab Google Spreadsheets nrog tus nas yog tib yam li rau kev hloov column widths, tshwj tsis yog tias koj muab tus pointer mouse rau ntawm kab kab ntawm ob kab hauv kab ua ke tsis yog ntawm lub sab header.

02 ntawm 02

Hloov Puag Ncig Feem Siv Ribbon Kev Xaiv hauv Excel

Hloov Paus Davhlau Siv cov Ribbon Options. © Ted Fabkis

Hloov Puag Ncig Nce Siv Cov Ribbon Kev Xaiv

  1. Nias ntawm ib lub xovtooj ntawm kem uas koj xav hloov - mus qhib ntau kab ntxiv ib lub xovtooj ntawm txhua kem
  2. Nias rau ntawm lub tsev tab ntawm txoj hlua
  3. Nias rau ntawm Daim Ntawv Npe icon kom qhib qhov nco cia zaub mov ntawm cov kev xaiv
  4. Kom AutoFit rau sab (s), xaiv qhov kev xaiv nyob rau hauv seem Cell ntawm cov ntawv qhia zaub mov
  5. Los muab tswv yim rau ib qho kev loj hauv cov cim ximxav, nias rau ntawm txoj kab Kev Dav Dav rau hauv cov ntawv qhia zaubmov coj tuaj rau ntawm qhov Kem
  6. Hauv lub vev xaib sib txuas rau qhov dav qhov siab hauv kev ua cim (vim tias qhov dav dav: 8.11 cim)
  7. Nyem OK los hloov qhov column widths thiab kaw lub thawv ntawv

Hloov Txhua Qhov Ncauj Ncej Ncaj Ncej hauv Cov Ntawv Cuam Tshuam Siv cov ntawv tshaj tawm

  1. Ndliv qhov Select All All khawm nyob rau sab saum toj ntawm kab ntawv khawm kom pom tag nrho txhua kab ntawv hauv daim ntawv niaj hnub no.
  2. Rov ua li cov kauj ruam 5 mus rau 7 saum toj saud los nkag rau ib qho loj rau tag nrho txhua kab

Hloov Cov Heights uas siv qhov Ribbon Options

Cov kev xaiv thiab cov kauj ruam yuav hloov kab heights nyob hauv Excel siv cov kev xaiv hauv txoj cai yog tib yam li kev hloov column columns.