Njira 4 zowonjezera pepala latsopano mu Microsoft Excel

Ambiri amadziwika kuti mubuku limodzi la Excel (fayilo) pamakhala mapepala atatu omwe mungasinthe. Izi zimapangitsa kuti apange zikalata zingapo zokhudzana ndi fayilo imodzi. Koma choyenera kuchita chiyani ngati chiwerengero choyambirira cha ma tebulo owonjezera sichikwanira? Tiyeni tione momwe tingawonjezere chinthu chatsopano mu Excel.

Njira zowonjezera

Momwe mungasinthire pakati pa mapepala, amadziwa ambiri ogwiritsa ntchito. Kuti muchite izi, dinani pa maina awo, omwe ali pamwamba pa chikhomo pamtundu wa kumanzere.

Koma sikuti aliyense akudziwa kuwonjezera mapepala. Ogwiritsa ntchito ena samadziwa ngakhale kuti n'zotheka. Tiyeni tione momwe tingachitire izi m'njira zosiyanasiyana.

Njira 1: pogwiritsa ntchito batani

Njira yowonjezera yogwiritsidwa ntchito ndiyo kugwiritsa ntchito batani lotchedwa "Lowani Tsamba". Izi ndi chifukwa chakuti njirayi ndi yabwino kwambiri pa zonse zomwe zilipo. Bungwe lowonjezera likupezeka pamwamba pa bolodi la chikhalidwe kumanzere kwa mndandanda wa zinthu zomwe zalembedwa kale.

  1. Kuti uwonjezere pepala, ingomani pa batani pamwambapa.
  2. Dzina la pepala latsopano limapezeka nthawi yomweyo pazenera pamwamba pa barreti, ndipo wogwiritsa ntchito amalowa.

Njira 2: menyu yachidule

N'zotheka kuyika chinthu chatsopano pogwiritsa ntchito menyu.

  1. Dinani molondola pa mapepala aliwonse omwe ali kale m'bukuli. M'ndandanda wamakono imene ikuwonekera, sankhani chinthucho "Sakani ...".
  2. Zenera latsopano limatsegulidwa. M'menemo tidzasankha zomwe tikufuna kuziyika. Sankhani chinthu "Mapepala". Timakanikiza batani "Chabwino".

Pambuyo pake, pepala latsopanolo liziwonjezeredwa pa mndandanda wa zinthu zomwe zilipo pamwamba pa bar.

Njira 3: Chida cha tepi

Chinthu chinanso chokhazikitsa pepala latsopano chimaphatikizapo kugwiritsa ntchito zipangizo zomwe zaikidwa pa tepi.

Kukhala mu tab "Kunyumba" Dinani pa chithunzicho mwa mawonekedwe a triangle yosandulika pafupi ndi batani Sakanizaniyomwe imayikidwa pa tepi mu zida za zipangizo "Maselo". Mu menyu imene ikuwonekera, sankhani chinthucho "Lowani Tsamba".

Zitatha izi, chinthucho chimalowetsedwa.

Njira 4: Hotkeys

Ndiponso, kuti muchite ntchitoyi, mungagwiritse ntchito otchedwa mafungulo otentha. Ingoyimitsani njira yachinsinsi Shift + F11. Pepala latsopano silidzangowonjezedwa, koma lidzakhalanso yogwira ntchito. Izi zikutanthauza kuti, mwamsanga mutangowonjezerapo wogwiritsa ntchitoyo amasintha.

Phunziro: Keyi Zowonjezera mu Excel

Monga mukuonera, pali njira zinayi zosiyana zowonjezera pepala latsopano ku bukhu la Excel. Wosuta aliyense amasankha njira yomwe ikuwoneka ngati yabwino, popeza palibe kusiyana pakati pa zosankhazo. Inde, ndi mofulumira komanso mosavuta kugwiritsa ntchito mafungulo otentha pazinthu izi, koma sikuti munthu aliyense akhoza kusunga malingaliro ake, ndipo chifukwa chake ogwiritsa ntchito ambiri amagwiritsa ntchito njira zowonjezereka zowonjezera.