The formula bar yog ib lub cuab yeej uas tshwm rau saum Microsoft Excel thiab Google Cov Ntawv Tshaj Tawm; nws kuj yog qee zaum hu ua fx bar vim tias qhov shortcut nyob ib sab ntawm nws. Koj siv lub formula bar txhawm rau nkag mus rau tus qauv tshiab lossis luam cov qauv uas twb muaj lawm; nws siv kuj muaj xws li tso saib thiab kho cov qauv. Lub formula bar qhia:
- Cov ntawv nyeem lossis tus lej cov ntaub ntawv los ntawm lub xov tooj tam sim no lossis lub cev muaj zog.
- Formula nyob rau hauv lub active cell (tsis yog cov lus teb).
- Qhov ntau ntawm cov hlwb sawv cev rau cov ntaub ntawv xaiv hauv ib daim ntawv Excel.
Vim formula bar qhia cov qauv nyob hauv cov hlwb ntau dua li cov txiaj ntsig ntawm cov qauv, nws yooj yim los nrhiav cov hlwb uas muaj cov qauv tsuas yog nyem rau ntawm lawv. Daim ntawv qhia bar kuj qhia txog tus nqi tag nrho rau cov lej uas tau teeb tsa kom pom tsawg dua qhov chaw nyob hauv ib lub xovtooj.
Cov lus qhia no siv rau Excel versions 2019, 2016, 2013, 2010, thiab Excel rau Microsoft 365.
Editing Formula, Charts, and Data
The formula bar kuj tuaj yeem siv los hloov kho cov qauv lossis lwm cov ntaub ntawv nyob hauv lub xov tooj nquag los ntawm nias rau ntawm cov ntaub ntawv hauv cov qauv bar nrog tus cursor. Nws kuj tseem tuaj yeem siv los hloov kho qhov sib txawv rau ib tus neeg cov ntaub ntawv series uas tau xaiv hauv daim ntawv Excel.
Expaning the Excel Formula Bar
Thaum ua haujlwm nrog cov ntaub ntawv ntev nkag lossis cov qauv nyuaj, koj tuaj yeem nthuav tawm formula bar hauv Excel kom cov ntaub ntawv qhwv ntawm ntau kab. Koj tsis tuaj yeem nce qhov loj ntawm formula bar hauv Google Sheets.
txhawm rau nthuav cov qauv bar hauv Excel:
- Hover the mouse pointer ze rau hauv qab ntawm tus qauv bar kom txog rau thaum nws hloov mus rau hauv ntsug, ob-headed xub.
- nias thiab tuav down the l eft nas khawm thiab rub down kom nthuav dav formula bar.
Xwb, cov keyboard shortcut rau nthuav cov qauv bar yog:
Koj tuaj yeem nias thiab tso txhua tus yuam sij tib lub sijhawm, lossis tuav lub Ctrl thiab Shift tus yuam sij ua ntej thiab tom qab ntawd nias lub U key. Txhawm rau kho qhov loj me me ntawm cov qauv bar, nias tib lub yuam sij thib ob.
Wrap Formulas lossis Cov Ntaub Ntawv ntawm Ntau Kab
Tom qab koj tau nthuav dav Excel cov qauv bar, cov kauj ruam tom ntej yog qhwv cov qauv ntev lossis cov ntaub ntawv mus rau ntau kab. Nyob rau hauv lub formula bar, click tso koj cov ntsiab lus ntxig, tom qab ntawd nias Alt + Enter ntawm cov keyboard.
Cov mis los yog cov ntaub ntawv los ntawm qhov tawg mus rau qhov txav mus rau kab tom ntej hauv cov qauv bar. Rov ua cov kauj ruam ntxiv ntxiv yog tias xav tau.
Show/Hide the Formula Bar
Qhia lossis zais cov qauv bar hauv Excel lossis Google Sheets:
-
Excel: Nyem rau ntawm View tab ntawm ribbon.
Google Sheets: Nyem rau ntawm View ntawv xaiv.
-
Excel: Kos lossis tshem tawm Formula Bar kev xaiv.
Google Sheets: Yog tias Formula bar kev xaiv muaj ib daim tshev nyob ib sab ntawm nws, ces nws pom; yog tsis muaj check, ces muab zais. Nyem qhov Formula bar kev xaiv thiab ntxiv lossis tshem tawm cov cim kos.
-
The Formula bar yuav tsum tau teeb tsa rau qhov pom koj xaiv.
Image
Tiv thaiv cov qauv los ntawm kev tso tawm
Excel daim ntawv tiv thaiv muaj xws li kev xaiv uas tiv thaiv cov qauv hauv cov xauv lub hlwb los ntawm kev tshwm sim hauv cov qauv bar. Koj tuaj yeem siv qhov tshwj xeeb no los tiv thaiv lwm tus neeg siv los ntawm kev kho cov qauv hauv cov ntawv sib koom. Kev zais cov qauv yog txheej txheem ob kauj ruam. Ua ntej, cov hlwb uas muaj cov qauv raug muab zais, thiab tom qab ntawv tiv thaiv daim ntawv thov.
Txog theem thib ob yog ua tiav, cov qauv tseem pom nyob rau hauv formula bar.
Ua ntej, zais cov hlwb uas muaj cov qauv:
- Xaiv ntau ntawm cov hlwb muaj cov qauv uas koj xav zais.
-
Ntawm Home tab ntawm ribbon, nyem rau ntawm Format kev xaiv qhib lub drop-down menu.
- In the menu, click on Format Cells los qhib lub Format Cells dialog box.
- Nyob hauv lub dialog box, nyem rau ntawm Kev Tiv Thaiv tab.
- Xaiv lub Hidden checkbox.
- Click OK txhawm rau siv qhov hloov pauv thiab kaw lub thawv sib tham.
Tom ntej, pab kom muaj kev tiv thaiv daim ntawv ua haujlwm:
- Ntawm Home tab ntawm ribbon, nyem rau ntawm Format kev xaiv qhib lub drop-down menu.
- Click on Protect Sheet nyob rau hauv qab ntawm daim ntawv mus qhib lub Tiv thaiv Sheet dialog box.
- Kaws lossis tshem tawm cov kev xaiv uas xav tau.
- Click OK txhawm rau siv cov kev hloov pauv thiab kaw lub dialog box.
Lub sijhawm no, cov qauv uas tau xaiv yuav tsis pom hauv daim ntawv qhia.
Formula Bar Icons hauv Excel
The X, ✔, thiab fx icons nyob ib sab ntawm tus qauv bar hauv Excel ua cov hauv qab no:
- X – Ncua tseg cov kev hloov kho lossis ib feem ntawm cov ntaub ntawv nkag hauv lub xov tooj nquag.
- ✔ - Ua kom tiav qhov nkag lossis hloov kho cov ntaub ntawv hauv lub xovtooj ua haujlwm (tsis tau txav lub xovtooj ntawm tes tseem ceeb mus rau lwm lub xovtooj),
- fx - Muab ib qho luv rau kev ntxig cov haujlwm rau hauv lub xov tooj nquag los ntawm kev qhib lub Insert function dialog box thaum clicked.
Cov keyboard sib npaug rau cov cim no, feem, yog:
- The Esc tus yuam sij – Tso tseg kev hloov kho lossis ib feem ntawm cov ntaub ntawv nkag.
- Tus Enter tus yuam sij - Ua kom tiav qhov nkag lossis hloov kho cov ntaub ntawv hauv lub xov tooj nquag (tsiv lub xov tooj ntawm tes tseem ceeb mus rau lwm lub xov tooj).
- Shift + F3 – Qhib lub Insert dialog box.
Editing hauv Formula Bar nrog Shortcut Keys
Tus yuam sij keyboard shortcut rau kho cov ntaub ntawv lossis cov qauv yog F2 rau Excel thiab Google Sheets - los ntawm lub neej ntawd, qhov no tso cai rau kev hloov kho hauv lub xov tooj nquag. Hauv Excel, koj tuaj yeem lov tes taw lub peev xwm los hloov kho cov qauv thiab cov ntaub ntawv hauv lub xov tooj ntawm tes thiab tsuas yog tso cai rau kev hloov kho hauv cov qauv bar.
Txhawm rau lov tes taw kho hauv hlwb:
- Click on the File tab ntawm ribbon los qhib cov ntawv qhia zaub mov.
- Click on Options hauv cov ntawv qhia zaub mov kom qhib lub Excel Options dialog box.
- Click on Advanced nyob rau sab laug pane ntawm lub dialog box.
- In the Editing options section of the right pane, uncheck the Cia kho ncaj qha rau ntawm tes kev xaiv.
- Click OK txhawm rau siv qhov hloov pauv thiab kaw lub thawv sib tham.
Google Sheets tsis tso cai hloov kho ncaj qha hauv formula bar siv F2.
