Me pēhea te ki te rapurongoā hapa ina whakaora koutou pukamahi Excel

Microsoft Excel ko te ripanga hangaia e Microsoft. Wātea i runga i maha ngā pūnaha whakahaere e ngā Windows, MacOS, iOS ko Android me tuku taputapu kaha rite whakairoiro, tātaitanga, tepu kaurori me ētahi atu ki te mahi i ngā mahi.

• Otinga 1: Hapa Me pēhea te ki te Raparongoā Excel
• Otinga 2: Tapia Excel Wordbooks ki Tool Tapia

He aha te momo o te hapa puta ina whakaora koutou kōnae Excel

A, no te ngana ki te whakaora i te kōnae Excel, taea e miharo ki nga mea katoa o ngā hapa koe. Waimarie i reira he rongoā mō ngā hapa mohiotia katoa. Kia arotake o etahi o nga hapa, me pehea ki te whakatika ia ratou.

I mua i te tīmata koe rapurongoā hapa Excel mā te whakamahi i ngā tikanga classing mā te whakamahi i te taputapu hanga Excel ranei, kia tino ki te whakaora i tō mahi kia rite ki pai rite taea e koe. kia ngā te tikanga e whai ake nei i te anō rorohiko, e taea arahi ki ngaro koutou raraunga Excel. Kia arotake o te tahi mau tikanga kimi ki te whakaora i tō Kōnae Excel tuatahi:

1. Ko te take kia meinga ai e te ingoa, na tamata i te rerekē kotahi:
   - I te kokonga maui runga o to koutou mata, pāwhiri i "Kōnae", me te ka pāwhiri i runga i "whakaora rite"
   - Kōwhiria he ingoa rerekē
2. Kōwhiritia tētahi atu momo kōnae mo koutou pukamahi Excel:
   - Pāwhiritia i runga i "Kōnae", ka "Tiaki Hei"
   - ka whakatuwhera te matapihi hou; i te raro e kite koe "Tiaki rite Momo", i roto i taua takaiho whiriwhiri tetahi putanga, rite .xlsm .xlsx ranei.
3. Tiakina tou pukamahi rite HTML:
   - Pāwhiritia i runga i "Kōnae", ka "Tiaki Hei"
   - hea ta te reira "Tiaki rite Momo", tīpako "Whārangi Tukutuku"
   - Whakaorangia tou kōnae Excel

Otinga 1: Hapa Me pēhea te ki te Raparongoā Excel

Na e te ora humarie koutou kōnae ki tō Rorohiko, ka taea e tīmata koe ki te rapurongoā hapa Excel . I roto i te tikanga ki te mahino e founga ki te hanga Excel, me matau koutou te mea kei te meinga te take i roto i te wahi tuatahi. He he torutoru take e taea meinga Excel ki arā:

1. Ko tētahi o nga take e taea kia e kore e hoatu e koe te whaiaronga Kōpaki whakaaetanga ki te whakaoti i tenei mahi. Me hoatu e koe he kōpaki nga whakaaetanga e whai ake nei:
   - Tuhia
   - Pānuitia
   - Mukua
   - Whakakētia
   
2. Ko tētahi atu take e taea meinga te raruraru e taea kia i te-rōpū tuatoru tāpiri-i roto i. Enei momo o hōtaka iti te āwhina Excel ki te whakaoti i ngā mahi rerekē. Ētahi tāpiri-mai, e preloaded ina tāuta koe MS Excel i taea ētahi atu te tāuta ā i ngā mātāpuna rerekē. I te tahi taime e taea enei tāpiri-mai meinga raruraru me ki kia tino tetahi o atu o ratou e ki kupu, ka taea e koe te whakatuwhera Excel i te aratau haumaru:
   - Tuatahi tata Excel rawa
   - Kimihia te wahi i koe MS Excel
   - Press te "CTRL" kī me mahue pāwhiri i runga i te MS Excel kawe ki te whakatuwhera i te reira. Mau i te taviri mana noa riro koe i te karere e whai ake nei "kua kitea Excel e pupuri koutou ki raro i te pātuhi CTRL. E hiahia ana koe ki te tīmata i Excel i te aratau haumaru? Pāwhiritia Āe.
   - Na e ko koe i roto i te aratau haumaru, tamata te whakatuwhera i te tārua o koutou pukamahi me te kite, ki te taea te whakaora e koe i te reira.
   

   Ki te taea ki te whakaora i te reira e koe, na te tikanga reira e tetahi maha ranei tāpiri-mai, e meinga te take, kia ka whai koutou ki te kitea i roto i nei tetahi, me te muku i te reira. I muri kitea e koe i te tāpiri-i roto i te raruraru, i te tohutohu pai ko ki te whakapā atu te kaiwhakawhanake o taua tāpiri-i roto i te motuhake rite kia whai ratou i te whakatika mo te take.

3. Ki te he tonu, tino pea te Kōpae engari ka taea e tupu te reira. Me ūkui koe etahi wāhi.
4. Ka taea e tētahi wheori aruaru te tukanga tiaki o koutou pukamahi Excel. Te nuinga o pūmanawa wheori poto whakapōnānā tukanga rite te matawai ratou i te reira, ki te karo i te huaketo pūrongo teka e pā ana ki te kōnae kore ranei. Ki te whai koe i te wheori kaha, tamata whakihauā reira, anake kia kite, ki te taea e koe te whakaora koe Excel pukamahi.
5. Ki te kei te whakamahi koe i te pukamahi tiri me te ngana tetahi tangata ki te whakaora i te Excel kōnae te wa taua rite e koe. Ki te ko te take tenei, i te huarahi māmā, ko te ki te korero i te tangata ki te tatari tatari tika he meneti, me te ngana anō ranei.
6. Ki te he roa atu i 218 pūāhua te roa o te ingoa kōnae ka riro koe i te karere hapa "e kore ko Ingoakōnae tika", me te whakarerekē koutou te ingoa i roto i tenei take.

Otinga 2: Tapia Excel Wordbooks ki Tool Tapia

He hapa e e kore e mahi i enei tikanga matarohia. Waimarie i reira he Stellar Tapia Phoenix Excel i te mea waiwai te taputapu hanga Excel. Tōtika e taea te reira i hanga kōnae kino Excel ranei e kore e taea te whakatuwheratia, kahore hanga i tetahi huringa ki tou pukamahi. Tenei ko te torutoru o nga painga matua:

Hipanga ki te hanga hapa kōnae Excel:

Hipanga 1 Rere te kōnae whakamahi ki te whakatuwhera Stellar taputapu Phoenix hanga. Na ka pāwhiri i te kōwhiringa "Tāpiri kōnae" ki te whiriwhiri i tō kōnae.

Hipanga 2 Ka puta te matapihi i runga i to koutou mata. I tenei wāhi, kei ki te whai koe i te kōnae kotahi maha ranei ki te hanga, te whiriwhiri i te "Tīpakohia Kōnae" ranei "Tīpakohia Kōpaki" kōwhiringa.

Hipanga 3 Kia kua tū koe tou kōnae kōpaki ranei, i roto i te taputapu hanga Excel , pāwhiri i te pātene "Matawai".

Hipanga 4 I muri i te torutoru noa hēkona ka whai koe i te arokite o te kōnae Excel hanga ko.

Hipanga 5 Whakaorangia te kōnae ki te puku rohe.

Oranga Phoenix Ko te taputapu hanga Excel kaha. Ko te kuware ki te whakamahi i atanga, me te āheinga tukatuka nohopuku tauturu kino tona hanga kaiwhakamahi kōnae Excel nohopuku kia taea tonu e ratou to ratou mahi.

He tohutohu torutoru, ka pā ana ki te kōnae Excel kino:

• Katia rere pukamahi Excel katoa i mua i te ngana ki te hanga i tētahi kōnae kino .
• Tiaki i tō mahi ki te aroaro o te rapurongoā koe hapa Excel.
• I mua i te whiwhi ki kaupae raparongoā faingataa, tīmata ki te tuatahi nga mea ngāwari.