Thawj qhia hauv Excel 2007, cov hlua yog cov hlua ntawm cov nyees khawm thiab cov cim nyob saum thaj chaw ua haujlwm. Cov ribbon hloov cov ntawv qhia zaub mov thiab toolbars pom nyob rau hauv yav dhau los versions ntawm Excel.
Cov lus qhia hauv kab lus no siv rau Excel rau Microsoft 365, Excel 2019, Excel 2016, Excel 2013, thiab Excel 2010.
Ribbon Components
Cov kab ntawv suav nrog cov ntawv sau npe Tsev, Ntxig, Nplooj Txheej Txheem, Cov Qauv, Cov Ntaub Ntawv, Tshuaj Xyuas, Saib, thiab Pab. Thaum koj xaiv ib lub tab, thaj tsam hauv qab ntawm kab ntawv qhia txog cov pab pawg thiab, nyob rau hauv cov pab pawg, cov nyees khawm uas sawv cev rau ntau yam lus txib.
Thaum Excel qhib lub Tsev tab qhia, nrog rau cov pab pawg thiab cov nyees khawm hauv nws. Txhua pawg sawv cev ua haujlwm. Pawg Number suav nrog cov lus txib uas tsim cov lej, piv txwv li, kom nce lossis txo tus lej lej. Cov pab pawg Cells suav nrog cov kev xaiv los ntxig, tshem tawm, thiab tsim cov cell.
Xaiv cov lus txib ntawm txoj hlua yuav ua rau muaj kev xaiv ntxiv uas muaj nyob rau hauv cov ntawv qhia zaub mov lossis lub thawv sib tham uas cuam tshuam rau cov lus txib xaiv.
Collapse and expand the Ribbon
Cov ribbon tuaj yeem sib tsoo kom nce qhov loj ntawm daim ntawv ua haujlwm pom ntawm lub computer screen.
Muaj plaub txoj hauv kev los rhuav tshem cov kab:
- Ob-nias ib lub tab, xws li Home, Insert, lossis Page Layoutkom pom cov tabs nkaus xwb. Txhawm rau nthuav cov ribbon, nyem ob npaug rau ib tab.
- Nias CTRL+F1 ntawm cov keyboard kom pom cov tabs nkaus xwb. Txhawm rau nthuav cov ribbon, nias CTRL+F1.
- Xaiv Ribbon Display Options (nyob saum cov ribbon nyob rau sab xis sab xis ntawm Excel thiab zoo li lub thawv nrog tus xub tig ntsej muag) thiab xaiv Auto-hide Ribbon Tsis yog cov tabs lossis cov lus txib yuav pom. Txhawm rau nthuav cov ribbon, xaiv Ribbon Display Options, thiab xaiv Qhia Tabs thiab Commands
- Xaiv tus nce xubnyob rau sab xis ntawm txoj hlua khi kom tawg cov kab thiab tso saib tsuas yog cov tabs. Txhawm rau nthuav cov ribbon, nyem ob npaug rau ib lub tab.
Customize Ribbon
Txij li Excel 2010, nws muaj peev xwm hloov kho cov ribbon siv Customize Ribbon xaiv. Siv qhov kev xaiv no rau:
- Rename lossis rov xaj cov tab thiab pab pawg.
- Display tej tabs.
- Ntxiv lossis tshem tawm cov lus txib rau cov tabs uas twb muaj lawm.
- Ntxiv cov tab kev cai thiab pab pawg kev cai uas muaj cov lus txib nquag siv.
Tseem muaj cov lus txib uas tsis tuaj yeem hloov pauv ntawm kab, tshwj xeeb yog cov lus txib uas tshwm sim hauv cov ntawv grey hauv Customize Ribbon qhov rai, piv txwv li:
- Npe ntawm lub default commands.
- Icons cuam tshuam nrog cov lus txib default.
- Qhov kev txiav txim ntawm cov lus txib no ntawm lub ribbon.
Txhawm rau ntxiv cov lus txib rau ribbon:
- Xaiv tab, xws li Home, Insert, lossis Page Layout.
- Right-click a blank area of the ribbon.
-
Xaiv Customize the Ribbon.
Image -
Mus rau Main Tabs daim ntawv thiab xaiv lub tab (piv txwv li Layout tab) uas koj xav ntxiv cov lus txib. Ces xaiv New Group.
Thaum ntxiv cov lus txib rau lub ribbon, koj yuav tsum tsim ib pawg kev cai.
Image -
A Pab Pawg Tshiab (Kev Cai) yam khoom tshwm hauv qab tab koj xaiv. Txhawm rau muab cov npe tshwj xeeb, xaiv Rename.
Image -
Nyob rau hauv Rename qhov rais, xaiv lub cim, tom qab ntawd mus rau Tsev lub npe lub thawv ntawv thiab sau lub npe piav qhia rau cov lus txib. Xaiv OK.
Image - Xaiv pab pawg koj nyuam qhuav tsim.
-
Nyob hauv Xaiv cov lus txib los ntawm daim ntawv, xaiv cov lus txib ntxiv rau pawg no, tom qab ntawd xaiv Ntxiv.
Image - Xaiv OK. Cov pab pawg tshiab thiab cov lus txib tshwm rau ntawm kab.
