Teem thiab kho qhov chaw luam tawm hauv Excel

Cov kauj ruam kawg hauv kev ua haujlwm ntawm Excel cov ntaub ntawv feem ntau xa lawv mus rau lub tshuab luam ntawv. Thaum koj xav luam tag nrho cov ntaub ntawv ntawm ib daim ntawv, feem ntau tsis muaj teeb meem nrog qhov no. Tab sis yuav ua li cas thaum peb tab tom cuam tshuam nrog lub rooj loj, thiab tsuas yog ib feem ntawm nws yuav tsum tau luam tawm.

Koj tuaj yeem kho qhov chaw luam tawm hauv Excel hauv ntau txoj hauv kev:

• teem caij txhua zaus ib daim ntawv xa mus rau lub tshuab luam ntawv;
• kho qhov chaw tshwj xeeb hauv cov ntaub ntawv teeb tsa.

Cia peb saib ob txoj hauv kev thiab saib seb lawv tau siv li cas hauv qhov program.

Txoj Kev 1: Kho qhov chaw txhua zaus ua ntej luam ntawv

Txoj kev no tsim nyog yog tias peb xav luam cov ntaub ntawv ib zaug xwb, yog li tsis tas yuav kho qee qhov chaw rau yav tom ntej. Txawm li cas los xij, yog tias tom qab peb txiav txim siab luam tawm tib daim ntawv, cov chaw yuav tsum tau ua dua.

Lub algorithm ntawm kev ua yog raws li nram no:

1. Nyob rau hauv txhua txoj kev yooj yim (piv txwv li, siv lub khawm laug nas nias), xaiv qhov ntau ntawm cov hlwb uas peb npaj yuav xa mus luam tawm. Cia peb hais tias peb yuav tsum luam tawm muag tsuas yog rau thawj thiab thib ob qhov chaw tawm. Tom qab xaiv, nyem rau ntawm cov ntawv qhia zaub mov “File”.
2. Hauv cov npe ntawm sab laug, mus rau ntu “Lub foob”. Nyob rau sab xis ntawm lub qhov rais, nyem rau ntawm qhov kev xaiv luam tawm tam sim no (nyob tam sim hauv qab lub npe ntawm qhov thaiv “Parameters”).
3. Ib daim ntawv teev cov kev xaiv luam tawm yuav qhib:
   • cov nplooj ntawv nquag;
   • tag nrho phau ntawv;
   • xaiv fragment (peb xav tau).
4. Yog li ntawd, tsuas yog ib feem ntawm lub rooj xaiv los ntawm peb yuav raug tso tawm nyob rau hauv cov ntaub ntawv saib ua ntej cheeb tsam, uas txhais tau hais tias thaum lub pob nyem. “Lub foob” tsuas yog cov ntaub ntawv no yuav muab luam tawm rau ntawm daim ntawv.

Txoj Kev 2: Kho qhov chaw luam ntawv tas li

Nyob rau hauv cov ntaub ntawv uas ua hauj lwm nrog cov ntaub ntawv yog nqa tawm tsis tu ncua los yog raws sij hawm (suav nrog rau xa mus rau luam ntawv), nws yog tsim nyog los teem ib qhov chaw nyob tas li. Nov yog qhov peb ua rau qhov no:

1. Raws li nyob rau hauv thawj txoj kev, thawj zaug xaiv qhov xav tau cheeb tsam ntawm cov cell. Tom qab ntawd hloov mus rau lub tab “Page layout”qhov twg peb nyem rau ntawm lub pob “Print area” nyob rau hauv lub toolbox “Page settings”. Lub kaw lus yuav muab peb ob txoj kev xaiv: teeb tsa thiab tshem tawm. Peb nres ntawm thawj tus.
2. Yog li, peb tuaj yeem kho thaj tsam ntawm cov cell, uas yuav tsum tau luam tawm tas li mus txog thaum peb txiav txim siab los hloov kho. Koj tuaj yeem tshawb xyuas qhov no hauv thaj chaw saib ua ntej hauv cov kev xaiv luam tawm (menu “File” - ntu “Lub foob”).
3. Nws tseem tsuas yog khaws cov kev hloov pauv hauv cov ntaub ntawv los ntawm txhaj rau lub pob tsim nyog hauv cov ntawv qhia zaub mov “File” los yog nyem rau ntawm lub cim floppy disk nyob rau sab laug sab laug ntawm qhov program.

Tshem pinning los ntawm qhov chaw luam tawm

Cia peb hais tias peb yuav tsum hloov qhov chaw luam ntawv ruaj khov lossis tshem tawm tag nrho. Txhawm rau ua qhov no, hloov mus rau lub tab “Page layout” hauv cov kev xaiv uas qhib tom qab nias lub pob “Print area” xaiv lub sijhawm no “Cia li tso tseg”. Nyob rau hauv cov ntaub ntawv no, nws tsis yog txhua yam tsim nyog los ua ntej xaiv ib qho ntawm cov cell hauv lub rooj.

Peb rov qab mus rau qhov chaw luam ntawv thiab xyuas kom lawv rov qab mus rau qhov qub.

xaus

Yog li, tsis muaj dab tsi nyuaj hauv kev teeb tsa ib cheeb tsam tshwj xeeb hauv Excel, thiab cov txheej txheem no tsuas yog siv ob peb feeb thiab nyem kom tiav. Nyob rau tib lub sijhawm, yog tias peb npaj ua haujlwm tas li nrog cov ntaub ntawv thiab luam tawm, peb tuaj yeem kho qhov chaw tshwj xeeb uas yuav raug xa mus luam tawm txhua lub sijhawm, thiab peb yuav tsis tas siv sijhawm rau qhov no yav tom ntej.