Yuav Paub
- Nias thiab tso Alt+ H+ O+ R , ntaus lub npe tshiab, thiab nias Enter txhawm rau hloov npe rau daim ntawv ua haujlwm.
- Ob zaug-nias daim ntawv ua haujlwm tam sim no lub npe, ntaus lub npe tshiab, thiab nias lub Enter tus yuam sij.
- Txoj nyem rau ntawm daim ntawv teev npe tam sim no, xaiv Rename, ntaus lub npe tshiab, thiab nias lub Enter tus yuam sij.
Ob qhov kev hloov pauv uas ua kom yooj yim rau kev teeb tsa thiab txheeb xyuas cov ntawv ua haujlwm thiab cov ntaub ntawv uas lawv muaj yog los hloov npe daim ntawv ua haujlwm thiab hloov xim ntawm daim ntawv ua haujlwm hauv qab ntawm thaj chaw ua haujlwm. Cov lus qhia no siv rau Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 rau Mac, Excel 2016 rau Mac, Excel rau Mac 2011, Excel rau Microsoft 365, thiab Excel Online.
Siv Keyboard Hotkeys
Nyob hauv Excel 2019, Excel 2016, Excel 2013, lossis Excel 2010, koj tuaj yeem siv cov keyboard shortcut los hloov npe rau daim ntawv ua haujlwm.
Cov txheej txheem ntawm keystrokes activates ribbon commands. Thaum tus yuam sij kawg hauv ntu, R, raug nias thiab tso tawm, lub npe tam sim no ntawm daim ntawv tab ntawm daim ntawv tam sim no lossis cov ntawv tseem ceeb.
- Nias thiab tso tawm ua ntu ntu ntawm qhov tseem ceeb hauv qab no kom pom lub npe ntawm daim ntawv nquag: Alt + H + O + R.
- Tau lub npe tshiab rau daim ntawv ua haujlwm.
- Nias lub Enter tus yuam sij ntawm cov keyboard kom ua tiav renaming daim ntawv ua haujlwm.
Raws li kev hloov npe rau daim ntawv ua haujlwm siv hotkeys, koj tsis tas yuav tuav lub Alt thaum koj nias lwm tus yuam sij, zoo li nrog qee cov keyboard shortcuts. Txhua tus yuam sij raug nias thiab tso tawm ua ntu zus.
ob-click the Sheet Tab
Txoj kev no ua haujlwm hauv txhua qhov ntawm Excel rau Windows, Mac, Microsoft 365, thiab Online.
- ob-nias ntawm lub npe tam sim no hauv daim ntawv ua haujlwm kom pom lub npe tam sim no hauv tab.
- Tau lub npe tshiab rau daim ntawv ua haujlwm.
- Nias lub Enter tus yuam sij ntawm cov keyboard kom ua tiav renaming daim ntawv ua haujlwm.
- Lub npe tshiab yuav tsum pom ntawm daim ntawv ua haujlwm.
Right-Click the Sheet Tab
Txoj kev no ua haujlwm hauv txhua qhov ntawm Excel rau Windows, Mac, Microsoft 365, thiab Online.
- Right-click rau ntawm tab ntawm daim ntawv ua haujlwm koj xav hloov npe qhib cov ntawv qhia zaub mov.
- Nias rau Rename hauv daim ntawv qhia zaub mov kom qhia txog lub npe daim ntawv tam sim no.
- Tau lub npe tshiab rau daim ntawv ua haujlwm.
- Nias lub Enter tus yuam sij ntawm cov keyboard kom ua tiav renaming daim ntawv ua haujlwm.
- Lub npe tshiab yuav tsum pom ntawm daim ntawv ua haujlwm.
Nkag mus rau Kev Xaiv Ribbon Nrog Nas
Txoj kev no ua haujlwm hauv txhua qhov ntawm Excel rau Windows, Mac, Microsoft 365, thiab Online.
- Nias rau ntawm lub tab ntawm daim ntawv ua haujlwm kom hloov npe los ua nws daim ntawv nquag.
- Click on the Home tab ntawm daim ribbon.
- Click Format hauv pawg Cells los qhib cov ntawv qhia zaub mov.
- Click on Rename Sheet kom pom cov ntawv tab nyob hauv qab ntawm qhov screen.
- Tau lub npe tshiab rau daim ntawv ua haujlwm.
- Nias lub Enter tus yuam sij ntawm cov keyboard kom ua tiav renaming daim ntawv ua haujlwm.
View All Sheet Tabs in a Workbook
Yog tias phau ntawv ua haujlwm muaj ntau daim ntawv ua haujlwm lossis kab rov tav scroll txuas ntxiv, tsis yog txhua daim ntawv tab yuav tsum pom ib zaug. Qhov ntev ntawm daim ntawv npe, lub tabs ntev dua.
Kho qhov xwm txheej no:
- Muab tus nas pointer hla lub ntsug ellipsis (peb ntsug dots) nyob ib sab ntawm kab rov tav scrollbar.
- Tus nas pointer yuav hloov mus rau ob lub taub hau xub, raws li pom hauv daim duab saum toj no.
- Nias thiab tuav lub sab laug nas khawm thiab luag tus pointer mus rau sab xis kom nthuav dav thaj tsam rau daim ntawv tab kom pom, lossis sab laug kom nthuav dav lub scrollbar.
Excel Worksheet Name Restrictions
Muaj qee qhov kev txwv thaum nws los hloov npe daim ntawv ua haujlwm Excel:
- Ib lub npe tsis tuaj yeem tshaj 31 tus cim ntev
- Ib daim ntawv teev npe tsis tuaj yeem tso tseg
- Cov cim hauv qab no tsis tuaj yeem ua lub npe: / ?: [
Siv cov npe ua haujlwm hauv Excel Formulas
Renaming ib daim ntawv ua haujlwm tsis yog ua kom yooj yim rau kev taug qab ntawm cov nplooj ntawv hauv ib phau ntawv loj, tab sis nws muaj qhov txiaj ntsig ntxiv los ua kom yooj yim rau kev nkag siab cov qauv uas nthuav dav ntau daim ntawv ua haujlwm.
Thaum tus qauv suav nrog cov xovtooj siv los ntawm cov ntawv ua haujlwm sib txawv, daim ntawv ua haujlwm yuav tsum muaj nyob hauv cov qauv.
Yog tias cov npe ua haujlwm raug siv - xws li Sheet2, Sheet3 - cov qauv yuav zoo li no:
=Sheet3!C7+Sheet4!C10
Muab cov ntawv ua haujlwm piav qhia lub npe - xws li Cov Nqi Them Tsib Hlis thiab Lub Rau Hli Cov Nqi - tuaj yeem ua rau cov qauv yooj yim rau kev txiav txim siab. Piv txwv li:
='Nyiaj Nqis'!C7+'Lub Rau Hli Nqis'!C10
