Pangani Tchati mu Excel pogwiritsa ntchito njira zochepa

Ngati mukufunikira tchati mofulumira kapena mukufuna kungoyang'ana njira zina mu deta yanu, mukhoza kupanga tchati mu Excel ndi keystroke imodzi.

Chimodzi mwa zojambula zosadziwika kwambiri za Excel ndi chakuti pulogalamuyi ili ndi tchati chosasinthika chomwe chingathe kuchitidwa pogwiritsa ntchito makiyi osatsegulira.

Tchati chosasinthika amalola ogwiritsa ntchito mwamsanga kuwonjezera tchati chogwiritsiridwa ntchito kwambiri pa tsamba lomwe liripo pakali pano kapena kuwonjezera tchati ku tsamba losiyana pa bukhuli la ntchito .

Njira ziwiri zoti muchite izi ndi izi:

1. Sankhani deta yomwe mukufuna kugwiritsa ntchito pa tchati
2. Dinani fungulo F11 pa kambokosi

Tchati pogwiritsa ntchito zonse zosinthika zosinthika zimapangidwa ndikuwonjezeredwa ku tsamba limodzi lokha labukhuli.

Ngati zosintha zosasintha za fakitale zisasinthidwe, tchati chomwe chimapangidwira F11 ndichitsulo cha mzere .

01 a 04

Kuwonjezera Tchati Chadongosolo ku Tsamba Lalikulu Lalikulu ndi Alt + F1

Powonjezera chithunzi chachinsinsi pa pepala lapadera, tchati chomwechi chikhoza kuwonjezeredwa pa tsamba lomwe liripo - tsamba lolemba kumene deta ilipo - pogwiritsira ntchito mafungulo osiyana siyana.

1. Sankhani deta yomwe mukufuna kugwiritsa ntchito mu tchati;
2. Koperani ndi kugwiritsira chingwe cha Alt pa kibokosi;
3. Sindikizani ndi kumasula f1 Fiyi pa kibokosi;
4. Chithunzi chosasinthika chikuwonjezeredwa pa tsamba lamasamba.

02 a 04

Kusintha kwa Excel Mtundu Wotsatila

Ngati kukakamiza F11 kapena Alt + F1 kumapanga chithunzi chimene sichikukondweretsa, muyenera kusintha mtundu wosati wa chithunzi.

Mtundu watsopano wa chithunzi umayenera kusankhidwa kuchokera ku folda yamakono mu Excel yomwe imakhala ndi ma templates okha omwe mwalenga.

Njira yosavuta yosinthira mtundu wa chithunzi cha Excel ndi:

1. Dinani pa tchati chomwe chilipo kuti mutsegule mndondomeko yoyenera .
2. Sankhani mtundu wa Chati Chasinthidwe kuchokera pazitukulo kuti mukatsegule bokosi lachidule la mtundu wa Chati ;
3. Dinani pa Zithunzi pazanja lamanzere pa bokosi la dialog;
4. Dinani pazithunzi pazithunzi pa dzanja langa lamanja Zitsanzo Zanga ;
5. Sankhani "Ikani ngati tchati chotsatira" muzitukuko.

03 a 04

Kupanga ndi Kusunga Zithunzi Zanyati

Ngati simunapange template yomwe ingagwiritsidwe ntchito ngati mtundu wa chithunzi, njira yosavuta yochitira izi ndiyo:

1. Sinthani chithunzi chomwe chilipo kuti muphatikize zosankha zonse - monga mzere, X ndi Y zoyimira, ndi mtundu wa machitidwe - pa template yatsopano;
2. Dinani kumene pa tchati;
3. Sankhani "Sungani Chikhomo ..." kuchokera kuzinthu zamkati zomwe zikuwonetsedwa pa chithunzi pamwambapa, kutsegula bokosi lachikhomo la Chitukuko cha Chakudya;
4. Tchulani template;
5. Dinani Bungwe lopulumutsa kuti muzisunga template ndi kutseka bokosi la dialog.

Zindikirani: Fayilo imasungidwa ngati fayilo ya .crtx ku malo otsatirawa:

C: \ Documents ndi Settings \ username \ AppData \ Roaming \ Microsoft \ Zithunzi \ Zatati

04 a 04

Kuchotsa Chithunzi cha Chati

Njira yosavuta yochotsera kachitidwe kazithunzi ka Excel ndi:

1. Dinani pakanema pa tchati chomwe chilipo kuti mutsegule ndondomeko yoyenera.
2. Sankhani "Mtundu wa Chati Chasintha" kuchokera m'ndandanda wamakono kuti mutsegule Bokosi la Chitukuko cha Tchati Chasintha;
3. Dinani pa Zithunzi pazanja lamanzere pa bokosi la dialog;
4. Dinani pa Kusamalitsa Zithunzi pa batani kumbali yakumanzere ya ngodya ya bokosilo kuti mutsegule fayilo yamakalata ojambula;
5. Dinani pakanema template kuti muchotsedwe ndipo sankhani Chotsani mndandanda wa mauthenga - Fayilo Yotsutsa fayilo lidzatsegule ndikukupemphani kuti mutsimikizire ferelo kuchotsedwa;
6. Dinani pa Inde mu bokosi kuti muchotse template ndi kutseka bokosi.