txheem
Thaum tsim ib daim ntawv tshiab hauv Excel, peb tuaj yeem pom ib lossis ntau lub tab nyob hauv qab, uas yog hu ua phau ntawv nplooj ntawv. Thaum lub sijhawm ua haujlwm, peb tuaj yeem hloov pauv ntawm lawv, tsim cov tshiab, tshem tawm qhov tsis tsim nyog, thiab lwm yam. Qhov kev zov me nyuam cia li muab cov npe template nrog cov lej txuas mus rau nplooj ntawv: "Sheet1", "Sheet2", "Sheet3", thiab lwm yam. Thaum muaj. tsuas yog ob peb ntawm lawv, nws tsis yog qhov tseem ceeb. Tab sis thaum koj yuav tsum tau ua hauj lwm nrog ib tug loj tus naj npawb ntawm nplooj ntawv, kom nws yooj yim rau kev taw qhia nyob rau hauv lawv, koj muaj peev xwm rename lawv. Cia peb saib yuav ua li cas qhov no ua tiav hauv Excel.
Renaming ib daim ntawv
Daim ntawv lub npe tsis tuaj yeem muaj ntau dua 31 tus cim, tab sis nws yuav tsum tsis txhob muaj qhov khoob. Nws tuaj yeem siv cov tsiaj ntawv los ntawm txhua hom lus, tus lej, qhov chaw, thiab cov cim, tshwj tsis yog rau cov hauv qab no: "?”, “/”, “”, “:”, “*”, “[]”.
Yog tias vim li cas lub npe tsis tsim nyog, Excel yuav tsis tso cai rau koj ua tiav cov txheej txheem hloov npe.
Tam sim no cia peb mus ncaj qha rau cov kev siv uas koj tuaj yeem hloov npe cov nplooj ntawv.
Txoj Kev 1: Siv Cov Ntsiab Lus Qhia
Txoj kev no yog ib qho nrov tshaj plaws ntawm cov neeg siv. Nws yog siv raws li nram no:
- Txoj cai-nias ntawm daim ntawv lo, thiab tom qab ntawd hauv cov ntawv qhia zaub mov uas qhib, xaiv cov lus txib “Rename”.
- Daim ntawv lub npe kho hom yog qhib.
- Sau lub npe xav tau thiab nyem Sauuas cawm nws.
Txoj Kev 2: ob npaug nias rau ntawm daim ntawv lo
Txawm hais tias txoj kev piav qhia saum toj no yog qhov yooj yim heev, nws muaj qhov kev xaiv yooj yim dua thiab nrawm dua.
- Muab ob npaug rau-nias ntawm daim ntawv lo nrog rau sab laug nas khawm.
- Lub npe yuav ua haujlwm thiab peb tuaj yeem pib kho nws.
Txoj Kev 3: Siv Ribbon Tool
Qhov kev xaiv no yog siv ntau tsawg dua li thawj ob.
- Los ntawm xaiv cov ntawv xav tau hauv tab "Tsev" nyem rau ntawm lub pob “Hom ntawv” (block ntawm cov cuab yeej “Cells”).
- Hauv cov npe uas qhib, xaiv cov lus txib “Rename Sheet”.
- Tom ntej no, sau lub npe tshiab thiab txuag nws.
Nco ntsoov: Thaum koj yuav tsum tau hloov npe tsis yog ib qho, tab sis ntau cov nplooj ntawv ib zaug, koj tuaj yeem siv cov macros tshwj xeeb thiab cov add-ons uas tau sau los ntawm cov neeg tsim tawm thib peb. Tab sis txij li hom kev ua haujlwm no xav tau nyob rau hauv cov xwm txheej tsis tshua muaj, peb yuav tsis nyob ntawm nws kom meej nyob rau hauv lub moj khaum ntawm qhov kev tshaj tawm no.
xaus
Yog li, cov neeg tsim tawm ntawm Excel program tau muab ntau txoj hauv kev ib zaug, siv qhov koj tuaj yeem hloov npe cov ntawv hauv phau ntawv ua haujlwm. Lawv yog cov yooj yim heev, uas txhais tau hais tias nyob rau hauv thiaj li yuav paub thiab nco ntsoov lawv, koj yuav tsum tau ua cov kauj ruam no tsuas yog ob peb zaug.