txheem
Cia peb hais tias peb muaj ib daim ntawv Excel uas tau sau tag nrho cov ntaub ntawv. Nws yog qhov zoo sib xws, formatted, thiab zoo nkaus li qhov koj xav tau. Thiab ntawm no koj txiav txim siab luam tawm ntawm daim ntawv. Thiab ces nws pib saib txaus ntshai.
Spreadsheets tsis tas yuav saib zoo rau ntawm daim ntawv vim tias lawv tsis tsim los siv rau hauv kev luam ntawv. Lawv tau tshwj xeeb ua kom ntev thiab dav raws li qhov xav tau.
Qhov no yog ib qho yooj yim thaum lub rooj yuav tsum tau kho thiab qhib ntawm lub vijtsam, tab sis nws txhais tau tias nws cov ntaub ntawv yuav tsis zoo rau ntawm daim ntawv qauv.
Tab sis nyob rau hauv txhua rooj plaub, tsis muaj dab tsi yog tsis yooj yim sua, tshwj xeeb tshaj yog thaum nws los txog rau xws li ib tug saj zawg zog cuab tam li Excel. Ntxiv mus, nws tsis yooj yim kiag li. Nov yog qee cov lus qhia yuav ua li cas luam cov ntaub ntawv Excel kom lawv saib zoo ntawm daim ntawv.
Tswv yim 1: Siv lub Print Preview Option Ua ntej luam ntawv
Koj tuaj yeem pom raws nraim li cas koj daim ntawv yuav zoo li thaum luam tawm yog tias koj siv qhov no. Cov cuab yeej no tshwj xeeb tshaj yog muaj txiaj ntsig thiab yuav pab txuag tau ntau lub sijhawm thiab ntawv. Koj tuaj yeem ua qee yam kev hloov pauv rau nws yuav zoo li cas thaum luam tawm xws li nthuav cov npoo thiab lwm yam.
Koj tuaj yeem tshawb xyuas seb nws ua haujlwm li cas hauv kev xyaum, thiab nws yuav yooj yim heev los teeb tsa cov lus qhia ntawm nplooj ntawv.
Txiav txim siab seb koj npaj yuav luam dab tsi
Yog tias koj tsuas yog xav tau luam ib daim ntawv tshwj xeeb, koj tsis tas yuav luam tag nrho phau ntawv, tsuas yog cov ntaub ntawv tshwj xeeb xwb. Koj tuaj yeem luam tawm, piv txwv li, tsuas yog ib daim ntawv lossis ib daim ntawv tshwj xeeb. Koj tseem tuaj yeem luam tawm cov ntaub ntawv me me. Txhawm rau ua qhov no, koj yuav tsum xaiv lawv, thiab tom qab ntawd xaiv cov khoom "Highlighted range" hauv cov ntawv luam tawm.
Nthuav koj qhov chaw
Koj raug txwv los ntawm qhov loj ntawm daim ntawv koj luam tawm, tab sis muaj ntau txoj hauv kev uas koj tuaj yeem nce qhov chaw ntawd. Piv txwv li, hloov cov kev taw qhia ntawm ib daim ntawv. Lub neej ntawd yog portrait orientation. Nws yog qhov zoo rau cov ntxhuav nrog ntau cov kab, thiab toj roob hauv pes - yog tias muaj ntau kab.
Yog tias koj xav tau ntau qhov chaw, koj tuaj yeem txo cov npoo ntawm cov npoo ntawm daim ntawv. Qhov me me, cov ntaub ntawv ntau tuaj yeem haum rau ntawm ib daim ntawv. Thaum kawg, yog tias lub rooj me me, koj tuaj yeem siv Custom Scaling Options feature kom haum rau tag nrho cov ntaub ntawv ntawm daim ntawv.
Siv headers rau luam ntawv
Nws yog ib qho nyuaj rau to taub qhov twg ib tug neeg nyob rau hauv lub rooj yog hais tias nws yog tsis yooj yim sua kom luam lub rooj ntawm ib daim ntawv. Hauv qhov no, koj yuav tsum siv "Print headers" muaj nuj nqi. Nws tso cai rau koj ntxiv kab lossis kab ntawv kab lus rau txhua nplooj ntawv ntawm lub rooj.
Siv nplooj ntawv tawg
Yog tias koj cov ntaub ntawv nthuav dav ntau dua ib daim ntawv, nws yog ib lub tswv yim zoo los siv cov nplooj ntawv so kom pab koj nkag siab raws nraim li cas cov ntaub ntawv yuav tsum nyob hauv ib qho chaw. Thaum koj ntxig ib nplooj ntawv tawg rau hauv lub rooj, txhua yam hauv qab nws txav mus rau nplooj ntawv tom ntej. Qhov no yooj yim vim nws tso cai rau koj faib cov ntaub ntawv raws li tus neeg xav tau.
Yog tias koj ua raws li cov lus pom zoo no, koj tuaj yeem ua kom yooj yim nyeem cov ntaub ntawv Excel uas luam tawm ntawm daim ntawv.