He mea nui te tiaki i tētahi tuhinga Excel mā te kupuhipa, hei tiaki i te pono o tētahi ripanga tātai Excel, ahakoa e kite ana mātou he mea whakararuraru anō hoki tēnei mēnā kei te ngana koe ki te "Whakatuwhera" me te "Whakarerekē" rānei i tētahi kōnae Excel. Mā tēnei tuhinga ka whakaratohia he aratohu āwhina hei tango i te tiaki kupuhipa mai i te Excel. I te mutunga o tēnei tuhinga, kua ako angitu koe me pēhea te tango i te tiaki kupuhipa mai i tētahi ripanga tātai Excel, ā, ka taea e koe te whakatuwhera me te whakarerekē ngāwari i tō Mahi Excel me te kore e manukanuka!
Te tango i tētahi Kupuhipa e mōhiotia ana mai i tētahi Pukapuka Mahi Excel
He tino māmā noa te tango i tētahi kupuhipa e mōhiotia ana. Me whai noa i ngā tohutohu māmā e whai ake nei hei tango i ngā here whakatuwheratanga, whakarerekētanga rānei, ā, ka whai urunga katoa koe ki tō kōnae excel.
Te Tango i te Here Whakatuwheratanga
Mā ēnei mahi ka āwhina i a koe ki te whakakore i te kupuhipa e hiahiatia ana hei whakatuwhera i te tuhinga.
Hipanga 1: Whakatuwheratia te kōnae mā te whakauru i tōna kupuhipa, kātahi ka haere ki "Kōnae" > "Mōhiohio" > "Tiaki Pukapuka Mahi".
Hipanga 2: Tīpakohia "Whakamunatia ki te Kupuhipa". Ka puta ake he matapihi iti me te kupuhipa whetū e whakaaturia ana. Mukua noa ngā pūāhua katoa i roto i te pouaka kupuhipa, kātahi ka pāwhiri i te "ĀE".
Hipanga 3: Kia mahara ki te "Tiaki" ki te kōnae hei whakatinana i te huringa.
Kāore tō tuhinga e tiakina ki te kupuhipa mai i nāianei!
Te Tango i te Here Whakarerekē
Tērā pea ka pā he raruraru mēnā kua herea te ripanga Excel e hiahia ana koe ki te whakarerekē ki te Whakatika, he tino māmā te tango i tēnei here mēnā kua mōhio kē koe ki te Kupuhipa.
Hipanga 1: Whakatuwheratia te kōnae Excel e tika ana, ka tīpako i te ripa "Arotake".
Hipanga 2: Pāwhiritia te kōwhiringa "Tangohia te Rau" i te wāhanga "Hurihanga". Ka puta ake he matapihi iti me te kupuhipa whetū e whakaatuhia ana. Mukua noa ngā pūāhua katoa i roto i te pouaka kupuhipa, kātahi ka pāwhiri i te "ĀE".
Hipanga 3: "Tiaki" te kōnae, ā, kāore tō pepa e tiakina pai, ā, kua rite hoki mō te whakarerekē!
Te tango i tētahi Kupuhipa Kāore i te Mōhiotia mai i tētahi Pukapuka Mahi Excel
He mahi uaua pea ngā kupuhipa, inā koa me maumahara koe ki ngā waehere maha e pā ana ki ngā kōnae rerekē. Ko te tikanga o tēnei he tino uaua te pupuri i ngā Kupuhipa rerekē i ētahi wā. I tēnei take, kāore he huarahi whakauru mana hei tango i te kupuhipa mai i te pukapuka mahi Excel. Koinei te wāhi e tino whai hua ai ngā taputapu o waho pēnei i te Whakaora Kupuhipa Passper Excel tomo mai.
He whānuitanga o ngā āhuatanga a Passper hei āwhina nui i a koe ki te karo i te Kupuhipa o tētahi pepa Excel. Kei roto i ēnei āhuatanga:
- Te tango i te kupuhipa e whakarerekē ana.
- Te tautuhi me te tango i te kupuhipa whakatuwheratanga.
- Te pono me te whai huatanga katoa.
Te Tango i te Here Whakatuwheratanga
I muri i te tāutanga o te hōtaka, whai i ngā mahi kua hoatu hei tango i te kupuhipa mai i te ripanga Excel:
Hipanga 1: Tuwhera Pāhi mō Excel i runga i tō rorohiko, ā, ka kite koe i ngā kōwhiringa e rua e wātea ana ki a koe. Tīpakohia te "Whakaora Kupuhipa" i tēnei mata tahua matua.
Hipanga 2: Haere ki te pātene "+" ka pēhi hei uta i te pukapuka mahi Excel e tika ana. Whai muri i tēnei, ka taea e koe te whiriwhiri mai i ngā momo aratau whakaeke kua whakaritea kia pā ki tō horopaki. Pāwhiritia te "Whakaora" ina kua whiriwhiria e koe te aratau whakaeke e pai ana ki a koe.
Ka tīmata a Passper i te tukanga tiki i tō kupuhipa i muri i tō pēhi i te "Whakaora". Me mōhio ko te roa o te tiki ka whakawhirinaki ki te uauatanga o tō kupuhipa, me te aratau whakaeke i whiriwhiria e koe.
Kia angitu te whakaora i te kupuhipa, ka whakaaturia hei tārua māu, hei tiaki hoki. Ka taea e koe te whakamahi i te kupuhipa hou hei tango i ngā parenga mai i tō kōnae Excel, me titiro koe ki te wāhanga "Tangohia te Kupuhipa ina mōhiotia" kia kite ai me pēhea te uru atu ki tō ripanga tātai i muri i te whakaora kupuhipa.
Te Tango i te Here Whakarerekē
Mena kua whakawhāitihia ngā āheinga whakatika o tētahi pepa Excel, ka raru pea mēnā kua tukuna ki a koe te kawenga ki te whakatika me te whakarite i te kōnae e tika ana. Anō, ka kite tātou i tērā Pāhi mō Excel e whakarato ana i te taputapu tino pai hei whakakore i ngā here whakatika katoa, ā, ka taea hoki e koe te whakatika i tō kōnae kia rite ki tō hiahia!
Me whai noa i ngā kaupae kua hoatu:
Hipanga 1: Whakarewahia te Passper mō Excel i muri i te tāutanga. I te mata matua, tīpakohia te "Tangohia ngā Here" mai i ngā kōwhiringa e rua e wātea ana.
Hipanga 2: Pēhia te ata "+" ka tīpako i te kōnae Excel e hiahia ana koe ki te tango i ngā here mai. Pēhia te "Tangohia" hei whakakore i ngā here whakatika katoa.
Kia oti, ka mukua angitu te kupuhipa i aukati i te whakatika i tō tuhinga, ko te tikanga ka taea te whakarite i tō kōnae me te kore he arai whakarihariha!
Whakamutunga
Nō reira, e kite ana mātou kua whakautua whānuitia te pātai, "me pēhea te tango i te kupuhipa mai i te Excel". He mahi uaua te mahi me ngā pepa Excel e tiakina ana e te kupuhipa, ko te tumanako ka māmā ake te wheako i te akoranga i whakaratohia i runga ake nei.
He mārama kei
Pāhi mō Excel
Ka tino āwhina i tō wheako Excel mā te huri i ngā mahi uaua ki ngā otinga "Pāwhiritia, ka Haere" ngāwari.
Tikiake Koreutu
