Yuav ua li cas qhwv hauv Excel: 9 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav ua li cas qhwv hauv Excel: 9 Kauj Ruam (nrog Duab)
Yuav ua li cas qhwv hauv Excel: 9 Kauj Ruam (nrog Duab)

Video: Yuav ua li cas qhwv hauv Excel: 9 Kauj Ruam (nrog Duab)

Video: Yuav ua li cas qhwv hauv Excel: 9 Kauj Ruam (nrog Duab)
Video: Playful Kiss - Playful Kiss: Full Episode 1 (Official & HD with subtitles) 2024, Tej zaum
Anonim

Microsoft daim ntawv thov daim ntawv, Excel, yog siv feem ntau rau cov xwm txheej nyiaj txiag. Vim li ntawd, ntau yam uas tau nkag mus rau hauv Excel daim ntawv teev npe yog tus lej. Txawm li cas los xij, muaj cov xwm txheej uas cov ntawv xav tau nkag mus rau hauv Excel. Vim tias qhov loj thiab qhov xwm txheej ntawm tus kheej lub hlwb, feem ntau nws yog qhov tsim nyog los qhwv cov ntawv thiab txuas ntxiv cov xov tooj ntawm tes lossis cov xov tooj ntawm tes, lossis koom ua ke ntau lub cell ua ke. Nov yog yuav ua li cas qhwv hauv Excel yog li koj tuaj yeem siv nws rau cov xwm txheej raws cov ntawv.

Cov kauj ruam

Qhib hauv Excel Kauj Ruam 1
Qhib hauv Excel Kauj Ruam 1

Kauj ruam 1. Tua tawm Microsoft Excel

Qhib hauv Excel Kauj Ruam 2
Qhib hauv Excel Kauj Ruam 2

Kauj Ruam 2. Txiav txim qhov chaw koj yuav tso cov ntawv

Qhib hauv Excel Kauj Ruam 3
Qhib hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem thiab rub kom pom cov cell thoob plaws uas cov ntawv yuav muab tso rau

Qhib hauv Excel Kauj Ruam 4
Qhib hauv Excel Kauj Ruam 4

Kauj Ruam 4. Txoj cai-nias ntawm kab lus tseem ceeb thiab xaiv qhov "Format Cells" xaiv nyob ze rau hauv qab ntawm lub qhov rooj qhib

Qhwv hauv Excel Kauj Ruam 5
Qhwv hauv Excel Kauj Ruam 5

Kauj Ruam 5. Xaiv lub Alignment tab ntawm Format Cells window

Qhwv hauv Excel Kauj Ruam 6
Qhwv hauv Excel Kauj Ruam 6

Kauj Ruam 6. Txheeb xyuas qhov "Merge Cells" xaiv thiab tom qab ntawd nyem lub pob OK kom kaw lub qhov rais

Qhib hauv Excel Kauj Ruam 7
Qhib hauv Excel Kauj Ruam 7

Kauj Ruam 7. Sau cov ntawv uas xav tau rau hauv lub cell no

Ntaus lossis luam tawm thiab muab cov ntawv tso rau hauv lub cell. Nws yuav tsis tshwm sim kom haum, tab sis, txawm hais tias qhov ua tiav nkag mus tsis pom nyob hauv lub xovtooj, nws tseem nyob ntawd

Qhib hauv Excel Kauj Ruam 8
Qhib hauv Excel Kauj Ruam 8

Kauj Ruam 8. Qhwv cov ntawv hauv xovtooj ntawm tes los ntawm txoj nyem rau ntawm cov xovtooj sib txuas thiab xaiv dua "Format Cells

Txheeb xyuas qhov "Wrap Text" option ntawm Alignment tab ntawm "Format Cells" window thiab tom qab ntawd nyem lub pob OK kom kaw lub qhov rai

Muab qhwv hauv Excel Kauj Ruam 9
Muab qhwv hauv Excel Kauj Ruam 9

Kauj Ruam 9. Rov ua qhov loj ntawm tes kom haum rau qhov ntau ntawm cov ntawv, yog tias tsim nyog

  • Lub xovtooj tsis loj txaus yog tias cov ntawv zoo li raug txiav tawm.
  • Nthuav tag nrho kab uas lub xovtooj nyob los ntawm nyem rau ntawm kab lej thiab rub cia kom txog rau thaum txhua kab ntawv tshwm.
  • Ntxiv ntau lub cell rau thawj txheej ntawm cov xovtooj sib txuas los ua kom lub cell loj. Nyem rau thawj lub xovtooj sib txuas ntawm tes thiab rub ob qho los lossis mus rau sab xis kom pom cov cell ntxiv. Txoj cai-nias ntawm pab pawg tshwj xeeb ntawm cov cell thiab xaiv qhov "Format Cells" xaiv.
  • Nco tseg qhov grey tawm kos hauv lub thawv "Merge Cells". Txheeb xyuas thiab tshuaj xyuas kom txog thaum lub cim tsis muaj xim dub lawm.

Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube

Pom zoo: