Tsis pom tus qauv bar hauv Excel - yuav ua li cas. 3 txoj kev daws teeb meem yog tias lub formula bar ploj lawm

Ib qho ntawm cov chaw tseem ceeb hauv qhov tseem ceeb hauv daim ntawv thov Excel yog lub formula bar. Nws lub hom phiaj yog ua raws li kev suav thiab kho cov ntsiab lus ntawm cov hlwb. Lub peculiarity ntawm lub formula bar yog hais tias los ntawm highlighting lub cell nrog tus nqi kawg, cov zaub ntawm cov kev ua nyob rau hauv lub xam yuav suav nrog. Hmoov tsis zoo, qee zaum muaj xwm txheej tshwm sim thaum lub pob no ploj ntawm Excel vaj huam sib luag. Peb yuav txheeb xyuas ntau qhov xwm txheej uas yuav ua rau muaj teeb meem zoo li no, thiab lawv yuav daws li cas hauv txoj kev yooj yim tshaj plaws.

Lub formula bar ploj lawm: yog vim li cas

Tsuas muaj ob lub laj thawj tseem ceeb vim li cas lub ntsiab lus cuam tshuam no tuaj yeem ploj ntawm toolbar - qhov no yog qhov hloov pauv hauv Excel chaw thiab software tsis ua haujlwm. Tab sis lawv tau muab faib ua cov ntaub ntawv ntxaws ntxiv.

Yog vim li cas # 1: Hloov chaw pub zaub mov

Hom teeb meem no tuaj yeem tshwm sim tom qab tus neeg siv yuam kev unchecks lub luag haujlwm uas yog lub luag haujlwm rau kev ua haujlwm ntawm cov qauv bar. Cia peb saib yuav ua li cas daws qhov teeb meem:

1. Nyob rau sab saum toj ntawm lub toolbar yog View khawm.
2. Los ntawm hovering tus cursor thiab nias lub pob sab laug, peb mus rau qhov sib thooj tab.
3. Thaum pom cov qauv kab, saib seb puas muaj zuam nyob rau pem hauv ntej ntawm nws. Nruab yog tsim nyog.
4. Raws li qhov tshwm sim ntawm kev ua, kab yuav rov tshwm sim hauv qhov program interface.

Mloog! Koj tsis tas yuav rov pib dua qhov program lossis lub khoos phis tawj txhawm rau txhim kho cov chaw.

 Yog vim li cas #2: Excel Options Settings Hloov

Lub formula bar yuav ploj mus tom qab ntawd los yog yuam kev nws nyob rau hauv cov kev xaiv qhov kev pab cuam. Txhawm rau daws qhov teeb meem, ob txoj hauv kev tau siv: thawj zaug tau piav qhia ua ntej, thiab txhawm rau txhim kho qhov teeb meem thib ob, koj yuav tsum rov ua dua txhua kauj ruam hauv tib lub sijhawm raws li thaum disabling txoj haujlwm no. Qhov twg yog qhov yooj yim dua thiab nkag siab ntau dua yog nyob ntawm tus neeg siv PC txiav txim siab. Kev daws nyob rau hauv ob txoj kev:

1. Hauv qhov toolbar, nrhiav "Cov ntaub ntawv" thiab txav mus.
2. Hauv tab uas qhib, koj yuav tsum nrhiav "Settings". Raws li txoj cai, lub ntsiab interface yog nyob rau hauv qab ntawm qhov kev pab cuam.

3. Tom ntej no, nyob rau hauv lub qhov rai uas qhib, mus rau hauv kab "Advanced", tom qab txhaj rau qhov "Ntxiv cov kev xaiv rau kev ua hauj lwm nrog Excel" yuav tshwm nyob rau sab laug.
4. Los ntawm kev tig lub log nas, peb tsa nplooj ntawv, qhov twg peb pom "Screen" pawg ntawm cov chaw.
5. Tsawg me ntsis koj tuaj yeem pom "Qhia cov qauv bar".
6. Ntawm qhov tsis sib xws, kos lub thawv.

Tseem ceeb! Tsis zoo li txoj kev daws teeb meem yav dhau los, qhov no yuav tsum muaj kev lees paub ntawm kev hloov pauv. Yog li ntawd, txhawm rau kom cov kev hloov pauv muaj txiaj ntsig, nyob hauv qab ntawm qhov chaw ntxiv ntawm cov kev txwv, koj yuav tsum nyem lub pob "OK", uas yuav txhais tau tias ua tiav cov haujlwm.

Yog vim li cas #3: Program poob lossis kev noj nyiaj txiag

Kev daws qhov teeb meem, yog tias ua yuam kev hauv qhov chaw, raug kho yooj yim heev, tab sis yuav ua li cas yog tias qhov program poob, lossis nws ua tsis tiav. Hauv qhov no, koj yuav tsum sim ua kom Excel rov qab. Cov hauv qab no yog ib qho piv txwv ntawm kev rov kho qhov program siv Windows 10 ua piv txwv. Txawm hais tias qhov chaw nyob hauv cov versions dhau los ntawm Windows yuav luag zoo ib yam:

1. Nyob rau hauv lub kaum sab laug sab laug, nyem lub pob "Start".
2. Hauv kab tshawb nrhiav peb sau "Control Panel".
3. Tom qab kuaj pom los ntawm lub kaw lus, qhib daim ntawv thov los ntawm nias lub pob laug nas.
4. Hauv daim ntawv thov uas qhib, koj yuav tsum tau teeb tsa cov tsos ntawm cov cim me me thiab mus rau "Cov Haujlwm thiab Cov Nta".
5. Lub qhov rais Uninstall/Change Programs yuav qhib. Ntawm no peb pom daim ntawv thov peb xav tau (qhov no, Microsoft Excel lossis Office) thiab nyem rau ntawm nws. Nyob rau hauv lub dialog box uas tshwm, koj yuav tsum qhib lub "Hloov" khawm. Tsis tas li ntawd, kev ua haujlwm tuaj yeem ua tau los ntawm txhaj rau lub npe ntawm qhov kev zov me nyuam nrog rau sab laug khawm thiab nyem rau hauv lub header ntawm cov npe ntawm cov tshwm sim interface keeb "Hloov".

6. Sai li qhov pib ntawm qhov kev hloov pauv tau lees paub, lub qhov rais tshiab rau kev kho qhov program yuav qhib. Ntawm no koj yuav tsum xaiv ib qho ntawm txoj kev. Raws li txoj cai, "Quick Recovery" yog txaus, uas tsis tas yuav muaj kev sib txuas hauv Is Taws Nem. Yog li ntawd, peb tso tseg peb txoj kev xaiv ntawm cov khoom no thiab nyem lub pob "Restore".

Lub qhov rais "Uninstall thiab hloov ib qho kev pab cuam" muaj xws li Microsoft Office pob, tom qab pib qhov kev hloov pauv, tag nrho cov kev rov qab los ntawm txhua qhov kev pab cuam suav nrog hauv cov khoom no los ntawm Microsoft yuav rov ua dua. Tos kom cov txheej txheem ua kom tiav thiab xyuas kom meej tias cov formula bar tshwm nyob rau hauv nws qhov chaw. Yog tias qhov no tsis tshwm sim, xa mus rau txoj kev thib ob.

Tswv yim! Txoj kev thib ob "Restore dua lub network" tsuas yog xaiv yog tias tsis muaj dab tsi hloov tom qab thawj txoj kev. Nws yuav tsum tau siv sij hawm ntau dua thiab kev sib txuas hauv internet ruaj khov.

xaus

Thaum txheeb xyuas qhov teeb meem nrog qhov poob ntawm lub formula bar, koj tsis tas yuav poob siab thiab ntshai. Thov nyeem zaj no ua ntej. Tej zaum yog vim li cas yog qhov kev hloov pauv tsis zoo hauv qhov kev zov me nyuam, uas raug kho nyob rau hauv ib qho teeb meem ntawm feeb. Nyob rau hauv qhov phem tshaj plaws, thaum qhov kev pab cuam crashes, koj yuav tsum tau rov qab Microsoft Office, uas yog tseem yooj yim ua yog hais tias koj ua raws li tag nrho cov lus qhia.