Bwalo lamapangidwe (fx bar) mu Zowonjezera

Kodi Fomu ya Fomu kapena Fx mu Excel ndi Chiyani Ndingayigwiritse Ntchito?

Galasi lamakono - lotchedwanso fx bar chifukwa cha chizindikiro cha fx chomwe chili pambali pake - ndibokosi lamakono omwe ali pamwamba pa mitu ya Excel ndi Google Spreadsheets.

Kawirikawiri, ntchito zake zikuphatikizapo kusonyeza, kusintha, ndi kulowetsa deta yomwe ili m'maselo apakompyuta kapena m'matcha.

Kuwonetsa Deta

Zowonjezera, bar yachangidwe idzawonetsa:

• malemba kapena nambala ya chiwerengero yomwe ili mu selo yamakono kapena yogwira ntchito;
• maonekedwe omwe ali mu selo yogwira ntchito osati yankho la funso;
• maselo osiyanasiyana omwe akuyimira mndandanda wa deta yosankhidwa mu Excel Tchati.

Popeza kapangidwe kameneka kali ndi mawonekedwe omwe ali mu maselo m'malo mwa zotsatira zake, n'zosavuta kupeza maselo omwe ali ndi mayesero pokhapokha atsegula pa iwo.

Babu lachindunji limatulutsanso kufunika kwathunthu kwa manambala omwe apangidwira kuti asonyeze malo ochepa a decimal mu selo.

Kusintha Mafomu, Zolemba, ndi Deta

Babu lachindunji lingagwiritsenso ntchito kusintha mazenera kapena deta zina zomwe zili mu selo yogwira ntchito pokhapokha podutsa pa deta muzenera zam'mimba ndi pointer ya mouse.

Ikhoza kugwiritsidwanso ntchito kusinthana mndandanda wa mndandanda uliwonse wa deta umene wasankhidwa mu Chitsanzo cha Excel.

N'zotheka kuika deta mu selo yogwira ntchito, pokha pokha pokhapokha ndikugwiritsira ntchito ndondomeko ya mbewa kuti mulowetsepo papepala lolowetsa.

Kuwonjezera Pulogalamu ya Bar Excel

Kwa maulendo apatali a deta kapena maulendo ovuta, bar baringaliro la Excel lingathe kufalikira ndi ndondomeko kapena deta atakulungidwa pa mizere yambiri monga momwe tawonetsera pa chithunzi pamwambapa. Babu lamakina sangathe kufalikira mu Google Spreadsheets.

Kuonjezera kapangidwe ka bar ndi mouse:

1. Sungani chofufumitsa cha mbewa pafupi ndi pansi pa barreyi mpaka mutembenuzire muwongolera, mzere wotsogolera awiri - monga momwe asonyezedwera mu fano;
2. Pano, panikizani ndi kugwira batani lamanzere lachitsulo ndikukwera kuti mukulitse bar.

Kuti muonjezere kapangidwe ka bar ndi makina osinthika:

Njira yotsindikiza yazowonjezera kapangidwe kazenera ndi:

Ctrl + Shift + U

Mafungulowa akhoza kupindikizidwa ndi kumasulidwa onse panthawi imodzimodzi, kapena makina a Ctrl ndi Shift angagwiritsidwe pansi ndipo chilembo cha U chili chinasindikizidwa paokha.

Kuti mubwezeretse kukula kosasintha kwa bar, perekani zolemba zomwezo kachiwiri.

Pezani Mafomu kapena Dongosolo pa Mipingo Yambiri mu Bwalo la Makhalidwe

Pambuyo pokonza ma Excel pamatabwa, chotsatira ndichokulunga ma fomu apamwamba kapena deta pamzere wambiri, monga momwe tawonera pa chithunzi pamwambapa,

Mu barandula yotsatira:

1. Dinani pa selo mu tsamba lomwe liri ndi ndondomeko kapena deta;
2. Dinani ndi ndondomeko ya ndondomeko kuti muikepo mfundo yoikapo pa nthawi yopuma;
3. Dinani makina a Alt + Lowani pa makiyi.

Mndandanda kapena deta kuchokera pang'onopang'ono yopitirira patsogolo idzaikidwa pa mzere wotsatira mu bar. Bwezerani masitepewa pamwamba kuti muwonjezere zopuma zina.

Onetsani / Bisani Bwalo la Machitidwe

Pali njira ziwiri zomwe zimapezeka pobisala / kuwonetsera kapangidwe kameneka mu Excel:

Njira yofulumira - yosonyezedwa mu chithunzi pamwambapa:

1. Dinani pa tsamba labuboni;
2. Onetsetsani / osatsegula Chophimba Chopangira Mazenera chomwe chili mu Gulu lawonetserako lakaboni .

Njira yayitali:

1. Dinani pa Fayilo tabu ya riboni kuti mutsegule menyu otsika;
2. Dinani pa Zosankha mu menyu kuti mutsegula Excel Options dialog box ;
3. Dinani Patsogolo muzanja lamanzere la bokosi la bokosi;
4. Mu gawo la Mawonetsedwe la mbali yolondola, fufuzani / osasintha njira Yopangira Bar ;
5. Dinani OK kuti mugwiritse ntchito kusintha ndi kutseka bokosi.

Kwa Google Spreadsheets:

1. Dinani pa Mapu awona kuti mutsegule ndondomeko yotsitsa;
2. Dinani pazomwe mungapezerepo pazomwe mungachite kuti muwone (muwone) kapena musabwereze (kubisa).

Pewani Mafomu Kuchokera mu Excel Bar Bar

Kutetezedwa kwa tsamba la Excel kumaphatikizapo njira yomwe imalepheretsa mayendedwe m'maselo otsekedwa kuti asawonedwe mu bar.

Kubisa mawonekedwe, monga maselo otseka, ndi njira ziwiri.

1. Maselo okhala ndi mayendedwe amabisika;
2. Tsambali lamasewera limagwiritsidwa ntchito.

Mpaka sitepe yachiwiri ikuchitika, mayendedwe adzakhalabe akuwoneka mu bar.

Khwerero 1:

1. Sankhani ma selo osiyanasiyana omwe ali ndi mayina obisika;
2. Kabukhu Kakanema ka Ribbon, dinani pa Format kusankha kuti mutseke menyu pansi;
3. Mu menyu, dinani pa Mawonekedwe a Mafelelo kuti mutsegule bokosi la mauthenga a mawonekedwe;
4. Mu bokosi la bokosi, dinani pa tsamba la Chitetezo ;
5. Pa tabayiyi, sankhani bokosi lobisika .
6. Dinani OK kuti mugwiritse ntchito kusintha ndi kutseka bokosi la bokosi.

Khwerero 2:

1. Kabukhu Kakanema ka Ribbon, dinani pa Format kusankha kuti mutseke menyu pansi;
2. Dinani pa Chitetezo Chotsatira Patsamba pansi pa mndandanda kuti mutsegule Bokosi lakulingalira la Tsambali;
3. Fufuzani kapena osasintha zomwe mukufuna
4. Dinani OK kuti mugwiritse ntchito kusintha ndi kutseka bokosi.

Panthawiyi, mawonekedwe osankhidwa ayenera kubisika kuwona mu bar.

✘, ✔ ndi fx Zithunzi mu Excel

✗, ✔ ndi mafano a fx omwe ali pambali pa bar yachitsanzo mu Excel angagwiritsidwe ntchito:

• ✘ - kuchotseratu kusintha kapena kulowa padera pa selo yogwira ntchito;
• ✔ - kumaliza kulemba kapena kusinthidwa kwa deta mu selo yogwira ntchito - sikusunthira mbali yeniyeni yogwira maselo ku selo lina;
• fx - kupereka njira yowonjezera yoyika ntchito mu selo yogwira ntchito potsegula Insert function dialog box pamene ikasindikizidwa.

Mzerewu wofanana ndi mafano awa, motere, ndiwo:

• Chingwe cha Esc - chikuletsa kusintha kapena kusalowa kwadongosolo;
• Mfungulo lolowamo - amatsiriza kulemba kapena kusintha kwa deta mu selo yogwira ntchito - amasunthira selo yogwira ntchito ku selo lina;
• Shift + F3 - imatsegula Insert dialog box;

Kusintha mu Babu la Fomu ndi Zowonjezera Zake mu Excel

Mfungulo wachinsinsi wosinthira deta kapena mawonekedwe ndi F2 kwa onse Excel ndi Google Spreadsheets. Mwachikhazikitso, izi zimalola kusintha mu selo yogwira - tsamba lolowetsa lili mu selo pamene F2 yatsindikizidwa.

Mu Excel, n'zotheka kusintha malemba ndi deta muzenera zamatabwa m'malo mwa selo. Kuchita izi:

1. Dinani pa Fayilo tabu ya riboni kuti mutsegule menyu otsika;
2. Dinani pa Zosankha mu menyu kuti mutsegula Excel Options dialog box;
3. Dinani Patsogolo muzanja lamanzere la bokosi la bokosi;
4. Mu gawo la zosintha zosinthidwa pazithunzi zoyenera, sanamvetsetse Kukonzekera Kwachindunji mwachindunji ;
5. Dinani OK kuti mugwiritse ntchito kusintha ndi kutseka bokosi la bokosi.

Google Spreadsheets salola mpangidwe wachindunji mu bar ya fomu pogwiritsa ntchito F2.