Pangani ndi kutsegula mabuku a Excel

Musanayambe kugwira ntchito ndi Microsoft Excel, muyenera kupanga chikalata chatsopano kapena kutsegula chomwe chilipo kale. Mutha kupanga buku lopanda kanthu kapena kugwiritsa ntchito template yopangidwa kale. Kuphatikiza apo, monga gawo la phunziroli, tiwona momwe tingakanire mafayilo ndi mafoda mukuwona kwa Backstage kuti muwafikire mwachangu.

Mafayilo a Microsoft Excel amatchulidwa mabuku. Mukayamba ntchito yatsopano ku Excel, muyenera kupanga buku latsopano. Pali njira zingapo zoyambira ndi chikalata cha Excel 2013: pangani buku latsopano lopanda kanthu, gwiritsani ntchito template yomwe ilipo, kapena tsegulani chikalata chosungidwa kale.

Pangani buku latsopano lopanda kanthu

1. Sankhani tabu file. Backstage view imatsegulidwa.
2. Sankhani Panganindiye akanikizire buku lopanda kanthu.
3. Buku latsopano lopanda kanthu lidzatsegulidwa.

Kutsegula buku lakale la Excel

Kuphatikiza pa kupanga buku latsopano, pakufunika kutsegula zikalata zosungidwa kale. Kuti mumve zambiri, yang'anani ku Saving and AutoRecovering Workbooks mu phunziro la Excel.

1. Sinthani ku Backstage view, tabu Open.
2. Sankhani kompyuta, Kenako Review. Mukhozanso kutsegula mafayilo osungidwa pa OneDrive (omwe kale anali SkyDrive).
3. A dialog box adzaoneka Kutsegula chikalata. Pezani ndikusankha fayilo yomwe mukufuna, kenako dinani Open.

Ngati mwatsegula chikalatachi posachedwa, zidzakhala zosavuta kuchipeza pamndandanda Mabuku atsopanokuposa kufufuza pa kompyuta.

Kusindikiza buku la ntchito mu Excel

Ngati nthawi zambiri mumagwira ntchito ndi chikalata chomwechi, zimakhala zosavuta kuziyika pakuwona kwa Backstage.

1. Pitani ku Backstage view, kenako dinani Open. Mabuku otsegulidwa posachedwa adzawonekera.
2. Yendetsani cholozera cha mbewa pa bukhu lomwe mukufuna kulisindikiza. Chizindikiro cha pushpin chidzawonekera pafupi ndi icho. Dinani pa chithunzi.
3. Bukhulo lidzakonzedwa. Kuti muchotse, dinani chizindikiro cha pininso.

Momwemonso, mutha kuyikanso zikwatu mukuwona kwa Backstage kuti mufike mwachangu. Kuti muchite izi, mukakhala mukuwona kwa Backstage, pitani ku tabu Open Kenako kompyuta. Pezani chikwatu chomwe mukufuna kusindikiza ndikudina chizindikiro cha pushpin.

Kugwiritsa ntchito ma templates mu Excel

Template ndi chikalata chopangidwa kale chomwe chimagwiritsidwa ntchito kufulumizitsa ntchito. Ma templates ali ndi makonda opangidwa kale monga masanjidwe ndi mapangidwe kuti asunge nthawi ndi khama popanga pulojekiti yatsopano.

Momwe mungapangire buku latsopano potengera template

1. Dinani filekuti muyendere ku Backstage view.
2. Press Pangani. Kutsatira njira buku lopanda kanthu pali zidindo zingapo.
3. Sankhani chithunzi kuti muwone.
4. Chiwonetsero ndi zina zowonjezera zokhudzana ndi kugwiritsa ntchito template zimatsegulidwa.
5. Press Panganikugwiritsa ntchito template yosankhidwa.
6. Buku lantchito latsopano lochokera pa template limatsegulidwa.

Mutha kusankha pateni ndi gulu kapena gwiritsani ntchito tsamba losakira kuti mupeze mawonekedwe osowa.

Si ma templates onse amapangidwa ndi Microsoft. Ambiri amapangidwa ndi anthu ena komanso ogwiritsa ntchito payekha, kotero ma template ena amatha kugwira ntchito bwino komanso ena oyipa kuposa ena.