txheem
Thaum ua haujlwm hauv Excel, feem ntau yuav tsum tau cais cov ntaub ntawv. Koj tuaj yeem ua qhov no ib yam li ntawm tib daim ntawv, lossis ntxiv ib qho tshiab. Tau kawg, muaj kev xaiv xws li tsim cov ntaub ntawv tshiab, tab sis tsuas yog siv tau yog tias peb tsis tas yuav txuas cov ntaub ntawv ua ke.
Muaj ob peb txoj hauv kev ntxiv ib daim ntawv tshiab rau hauv Excel phau ntawv. Hauv qab no peb yuav txiav txim siab txhua tus ntawm lawv.
Cov ntsiab lus
New Sheet Button
Txog tam sim no, qhov no yog txoj kev yooj yim tshaj plaws thiab pheej yig tshaj plaws, uas zoo li yuav siv los ntawm cov neeg siv feem ntau ntawm qhov program. Nws yog txhua yam hais txog qhov yooj yim tshaj plaws ntawm cov txheej txheem ntxiv - koj tsuas yog yuav tsum nyem rau ntawm qhov tshwj xeeb "New Sheet" khawm (hauv daim ntawv ntxiv), uas nyob rau sab xis ntawm cov nplooj ntawv uas twb muaj lawm hauv qab ntawm lub qhov rais program. .
Daim ntawv tshiab yuav muaj npe cia. Txhawm rau hloov nws, koj yuav tsum tau nyem ob npaug rau nws nrog rau sab laug nas khawm, sau lub npe xav tau, thiab tom qab ntawd nias Enter.
Koj tuaj yeem ntxiv ib daim ntawv tshiab hauv phau ntawv siv cov ntawv qhia zaub mov. Txhawm rau ua qhov no, right-click rau ib qho ntawm cov nplooj ntawv uas twb muaj lawm hauv daim ntawv. Cov ntawv qhia zaub mov yuav qhib, uas koj yuav tsum xaiv cov khoom "Insert Sheet".
Raws li koj tuaj yeem pom, txoj kev yooj yim raws li qhov tau piav qhia saum toj no.
Yuav ua li cas ntxiv ib daim ntawv los ntawm qhov program ribbon
Tau kawg, txoj haujlwm ntawm kev ntxiv ib daim ntawv tshiab kuj tuaj yeem pom ntawm cov cuab yeej nyob hauv Excel ribbon.
- Mus rau "Tsev" tab, nyem rau ntawm lub cuab yeej "Cells", tom qab ntawd rau ntawm tus xub me me nyob ib sab ntawm lub pob "Insert".
- Nws yog ib qho yooj yim los twv seb koj xav tau dab tsi los ntawm cov npe uas tshwm sim - qhov no yog cov khoom "Insert sheet".
- Qhov ntawd yog tag nrho, ib daim ntawv tshiab tau ntxiv rau hauv daim ntawv
Nco ntsoov: Qee qhov xwm txheej, yog tias qhov loj me ntawm qhov program qhov rais tau nthuav dav txaus, koj tsis tas yuav nrhiav "Cells" cuab yeej, vim tias "Insert" khawm tau tshwm sim tam sim ntawd hauv "Lub Tsev" tab.
Siv hotkeys
Zoo li ntau lwm yam kev pab cuam, Excel muaj, kev siv uas tuaj yeem txo lub sijhawm los nrhiav cov haujlwm hauv cov ntawv qhia zaub mov.
Txhawm rau ntxiv ib daim ntawv tshiab hauv phau ntawv ua haujlwm, tsuas yog nias lub keyboard shortcut Ua haujlwm + F11.
xaus
Ntxiv ib daim ntawv tshiab rau Excel yog qhov ua haujlwm yooj yim tshaj plaws, uas tej zaum yog ib qho nrov tshaj plaws thiab siv ntau tshaj plaws. Qee qhov xwm txheej, tsis muaj peev xwm ua qhov no, nws yuav nyuaj heev lossis tseem tsis tuaj yeem ua txoj haujlwm zoo. Yog li, qhov no yog ib qho ntawm cov kev txawj ntse uas txhua tus neeg uas npaj yuav ua haujlwm zoo hauv qhov kev zov me nyuam yuav tsum paub.