Raws li koj paub, Excel muab tus neeg siv nrog rab peev xwm los ua hauj lwm hauv ib daim ntawv ib zaug rau ntau qhov chaw. Daim ntawv thov yuav muab lub npe rau txhua lub caij tshiab: "Sheet 1", "Sheet 2", etc. Qhov no tsis yog dhau kev qhuav, uas ntau dua tau sib raug zoo, ua haujlwm nrog cov ntaub ntawv, tab sis kuj tsis yog xwm txheej heev. Tus neeg siv los ntawm ib lub npe yuav tsis muaj cuab kav txiav txim tau seb cov ntaub ntawv twg yog muab tso rau hauv ib qho kev txuas. Yog li, qhov teeb meem ntawm cov ntawv txheeb npe hloov tau ceev ceev. Cia peb saib seb qhov no tiav hauv Excel.
Rhais cov txheej txheem
Cov txheej txheem rau cov ntawv txhim kho nyob rau hauv Excel feem ntau yog intuitive. Txawm li cas los xij, qee cov neeg siv uas pib nyuam qhuav pib qhov kev zov me nyuam, muaj qee yam teeb meem.
Ua ntej yuav pib ncaj qha mus rau qhov kev piav qhia ntawm txoj kev hloov, nrhiav cov npe uas muab tau, thiab cov twg yuav tsis yog. Lub npe tuaj yeem muab ua lwm hom lus. Thaum sau ntawv koj tuaj yeem siv tau chaw. Raws li rau cov kev txwv loj, cov hauv qab no yuav tsum muaj qhia tias:
- Lub npe yuav tsum tsis txhob muaj cov cim nram qab no: "?", "/", "", ":": "*", "[]];
- Lub npe tsis tuaj yeem txhij;
- Tag nrho ntev ntawm lub npe yuav tsum tsis pub tshaj 31 cim.
Hauv kev teeb tsa lub npe ntawm cov ntawv yuav tsum nqa mus rau hauv cov cai saum toj no cov cai. Hauv cov lus tsis txaus siab, qhov kev zov me nyuam yuav tsis tso cai rau ua tiav txoj haujlwm no.
Method 1: shortcut menu shortcut
Txoj kev tshaj tawm txoj hauv kev zoo tshaj plaws yog los ua kom tau zoo dua los ntawm lub ntsiab lus teb ntawm daim ntawv qhia lub ntsiab lus ntawm cov ntawv luv luv nyob hauv sab laug sab ntawm daim ntawv thov lub qhov rais tshaj li ntawm qhov xwm txheej.
- Peb txoj cai-nias rau ntawm daim ntawv lo, dhau qhov uas peb xav ua kom ib txoj kev ntxias. Hauv cov ntawv qhia zaub mov, xaiv cov khoom Rename.
- Raws li koj tau pom, tom qab qhov kev ua no, lub teb nrog lub npe ntawm qhov ua kom luv. Cia li ntaus tawm los ntawm cov keyboard tsis tsim npe rau hauv cov ntsiab lus teb.
- Peb nias ntawm qhov tseem ceeb Sau. Tom qab ntawd, daim ntawv yuav muab ib lub npe tshiab.
Txoj kev 2: ob npaug nias ntawm daim ntawv lo
Muaj kuj yog ib txoj kev yooj yim dua tshiab. Koj tsuas yog xav tau ob npaug-nias rau ntawm daim ntawv lo, tiam sis, hauv qhov sib piv rau yav dhau los, tsis yog nas khawm, tab sis sab laug ib sab. Thaum siv hom no, tsis muaj cov ntawv qhia zaub mov yuav tsum raug hu. Lub npe ntawm daim ntawv lo npe nrov thiab npaj txhij rau renaming. Koj tsuas yog yuav tsum tau ntaus lub npe ntawm cov kauj ruam.
Method 3: Ribbon Khawm
Hloov kho ntxiv kuj ua tau zoo siv khawm tshwjxeeb ntawm txoj kab.
- Txhawm rau ntawm daim ntawv lo, mus rau ntawm daim ntawv uas koj xav hloov dua tshiab. Txav mus rau tab "Tsev". Peb nias lub khawm "Hom ntawv"uas yog muab tso rau ntawm daim kab xev hauv lub nras cov cuab yeej "Cell". Ib daim ntawv qhib. Nyob rau hauv nws nyob rau hauv pab pawg ntawm cov tsis "Xaiv qhov chaw" yuav tsum tau nyem rau ntawm yam khoom Rename Sheet.
- Tom qab ntawd, lub npe ntawm daim ntawv lo ntawm daim ntawv tam sim no, nrog rau cov kev ua dhau los, pib ua haujlwm. Nws yog txaus hloov nws mus rau lub npe neeg siv.
Hom no tsis yog zoo li qhov yooj yim thiab yooj yim li yav dhau los. Txawm li cas los, nws kuj yog siv los ntawm qee cov neeg siv.
Method 4: Siv Add-ons thiab Macros
Nyob rau hauv tas li ntawd, muaj tshwj xeeb chaw thiab macros sau rau Excel los ntawm lwm tus neeg tsim khoom. Lawv tso cai rau kev hloov cov ntawv txheeb, thiab tsis ua nrog txhua daim ntawv qhia manually.
Lub nuances ntawm kev ua hauj lwm nrog ntau qhov chaw ntawm hom no txawv nyob ntawm tus kws tsim tawm, tab sis txoj cai ntawm kev lag luam yog tib yam.
- Koj yuav tsum tsim ob lub npe nyob rau hauv daim Excel spreadsheet: nyob hauv ib daim ntawv teev npe qub, thiab hauv ob - daim ntawv teev npe uas koj xav hloov lawv.
- Peb tso tawm superstructures los yog ib qho lag luam. Nkag mus rau hauv qhov txawv ntawm qhov chaw ntxiv ntawm qhov ntxiv-qhov rai qhov ntau ntawm lub hlwb nrog cov laus lub npe, thiab hauv lwm daim teb - nrog cov tshiab. Ndliv lub pob kws nrhav kev hloov.
- Tom qab ntawd, yuav muaj dua ib nplooj ntawv hloov npe.
Yog hais tias muaj ntau dua cov ntsiab lus uas yuav tsum tau muab hloov dua tshiab, kev siv qhov kev xaiv no yuav pab txuag lub sijhawm tseem ceeb rau tus neeg siv.
Mloog zoo! Ua ntej nruab ib tus neeg sab nrauv thiab txuas ntxiv, nco ntsoov tias lawv tau downloaded los ntawm lub chaw cia siab thiab tsis txhob muaj kev siab phem. Tom qab tag nrho, lawv tuaj yeem ua rau cov kab mob kis rau lub cev.
Raws li koj tau pom, koj tuaj yeem hloov cov ntawv txheeb los ntawm Excel siv ntau qhov kev xaiv. Qee tus yog intuitive (ntsiab lus teb ntawv qhia shortcuts), lwm tus yog me ntsis ntxiv, tab sis kuj tsis muaj teeb meem tshwj xeeb hauv txoj kev loj hlob. Lub xeem, ua ntej ntawm tag nrho cov, yog hais txog renaming siv lub pob "Hom ntawv" ntawm daim kab xev. Tsis tas li ntawd, peb cov neeg sab nraud thiab cov add-ons siv tau rau kev hloov loj dua.
