Me pēhea te ki te Whakatika Hapa Tātai Kōnae Excel

Ko ahau mohio e mohio he tokomaha o nga kaipānui e Microsoft Excel ko te pūmanawa whakawhanakehia e Microsoft te tuatahi hoki Windows me mac OS, a ka i roto i te tau whakamutunga ratou whakarewa noa putanga pūkoro mō te Android me iOS. Na fele, te reira te hōtaka ripanga e homai te aravihi kaiwhakamahi ki te hanga tātai matatini te whakamahi tātai engineered, taputapu kauwhata, tepu, me te hōtaka tonotono hoki noa atu matatini taupānga tātaitanga. Ka taea e ara Excel te āwhina whakaoti koe whārite pārōnaki o ahupūngao pāngarau, me te tahi atu mea matatau. I tčnei wā, whakamahi reira hōputu rerekē e rua: "xls" me "xlsx".

• Wāhanga 1: Tool Hapa Tapia Tātai Kōnae Excel
• Wāhanga 2: Rongoā ki Whakatika Hapa Tātai Kōnae Excel

I mohio koe e kore i te pūmanawa ripanga tuatahi whakawhanakehia e Microsoft noa i te atanga kaiwhakamahi me i rere ai ki runga ki MS-DOS? Waihoki, ko Microsoft Excel te pūmanawa ripanga tuatahi i whakaaetia te kaiwhakamahi ki te tautuhi kāhua me te whakahōputu ki te pūtau. Whakaurua hoki Excel makona-aunoa, tō-me te maturuturunga iho, me ngā taputapu kauwhata whānui. Ki te tau, hei Excel kua tino papara, me te kupu kua oti hāngai e muru. Ki te whiwhi tō rorohiko huaketo huaketo, ranei malfunctions reira, ka taea e kia kino, me te pānui i ngā kōnae. I roto i tenei tuhinga, ka ako koe me pehea ki te whakatika kaka kōnae hapa tātai mā te whakamahi i te taputapu hanga Excel e pai kōrero e pā ana ki i muri i runga i.

Overview o Hapa Tātai Kōnae Excel

E rave rahi mau taime i roto i te Excel ki te tomo koutou he tātai e he hē, ka whakaatu i te hōtaka i te uara hapa i roto i te mara tomokanga tātai. He Excel uara hapa rerekē, me te ratou te tikanga tīmata ki tohu hashtag ( "#") Ki te whakatika kaka hapa tātai kōnae koe te tuatahi i ki te kitea i roto i te mea i meinga tenei hapa me te whakatika te mutunga te tātai. whakaae ahau, e he ana ki te rapu i te hapa i taua i roto i te tuhinga 14 rau kia tangi rite rite te kimi te ngira i roto i te tāke hei. Te mana'o nei au e waiho hei tīmatanga pai ki te waia koe ki enei hapa, ki te mohio ki ta e meinga ratou e ka ako e founga ki te whakatika ratou, ranei noa whakamahi i tētahi taputapu hanga Excel ki te rave i te reira.

Ētahi pūtau kei roto tohutoro ki ētahi atu pūtau e tino here i roto i ngā o te raraunga kia whakaatu ratou. Hei tauira, ki te he te tātai e whakaatu te hua i roto i A2 te pūtau A1 me taua tātai kua he uara hapa, ka whakaatu A2 te uara hapa rite te pai. Ko tenei he aha hanga reira na uaua ki te kitea te pūtau e kua te tātai hē. Etahi o nga hapa, he: # Tiwihana / 0- e te tikanga e e ngana ana koe ki te wehe i te kore, #NAME - ka kore e mohio ki Excel he ingoa, #NULL?! te kaihanga hoki kōkuhu koe he wāhi hei utu o te piko i te whakatika i te tautohe mahi, #TAU -! ka reira te mea he raruraru ki te tokomaha i roto i te tātai, me pera i runga i.

Wāhanga 1: Tool Hapa Tapia Tātai Kōnae Excel

Ki te kitea e koe i te reira i te pikaunga maere ki te whakatika kaka tātai kōnae hapa, pea kia whakaaro koe te whakamahi i te taputapu hanga Excel. To tatou huri hoki i tenei ra he Stellar Tapia Phoenix Excel . Taea ki te whakatika noa katoa Excel kōnae hapa pirau, rawa te hunga tai ki runga ki te hōputu te mōhiotia, kōnae pānui, ara ngā kōnae e kore e taea te whakatuwheratia i te katoa ranei tenei pūmanawa ko. E kore e mea faufaa te reira, ki te he te "xls" ranei hōputu "xlsx" tou kōnae. He mea pai e pā ana ki reira, ko te meka e taea ki te tiaki i te hōputu o te kōnae e e ora koe i tenei hōtaka ko. Kia hoki ora koe tuhinga ki tātai engineering matatini.

Me te tahi mea i i pa ki tou pūnaha me koutou kōnae katoa Excel e whakaatu hapa, ka taea e tenei pūmanawa te āwhina ora koutou kōnae maha i roto i te wātū hanga kotahi. Mā te whakamahi i te putanga whakamātautau homai koe koe te kaha ki te arokite i te kōnae kua tīpakohia i mua whakaora, Heoi whai koe ki te hoko i te raihana tonu ki te whakaora i tetahi kōnae. Tenei pūmanawa whakarato tautoko mō tetahi putanga Microsoft Excel, a taea te rere i runga i tetahi putanga Pūnaha Whakahaere Microsoft Windows. kia rere ano hoki e koe te tenei hōtaka i runga i te Pūnaha Mahi mac. Ētahi atu āhuatanga ngā: takiuru pūrongo, me ngāwari ki te whakamahi i atanga.

Wāhanga 2: Rongoā ki Whakatika Hapa Tātai Kōnae Excel

I mua i te tīmata i to tatou akoranga i runga i te āhua o ki te whakatika kaka kōnae tātai tēnā hapa tiki i te taputapu hanga Excel kua matou korero e pā ana ki i roto i te putanga o mua. Ki te kitea e koe koe i te mutunga o te tukanga tāuta, tika pato te pātene whakamutunga, me te tatari mo te pūnaha ki te whakarewa i te pūmanawa. A pee i te kaupae muri:

Hipanga 1 Ki te hiahia koe i te pūnaha ki te kitea te kōnae mo koutou, tīpako i te tauwāhi puku hanga te tahua taka-iho, ka pato i te "Kimi Kōnae (s)" pātene. Kore, pāwhiri "Tīpakohia Kōpaki", ranei "Tīpakohia Kōnae", me te haere tiki he kōnae i roto i te wāhi motuhake;

Hipanga 2 Next, e hiahia ana koe ki te tīpako i te tahi kōnae e hiahia ana koe ki te ora i te pouaka hua rapu e kua tika kua kapi ki ngā kōnae. Paoa i te pātene "Karapa";

Hipanga 3 I muri i te tukanga matawai e meatia, kei te hangaia arokite o te kōnae. E mau ki te titiro me te whakatau e te kōnae ki te whakaora;

Hipanga 4 Hei kaweake he tārua o te tuhinga ora ake, pato te pātene "Tiaki", tiki i te wāhi kōnae, ka pāwhiri i te pātene "Āe".

Ae, whakaae ahau e te reira i te mea pai ki te ako ki te whakamahi i ngā tātai i roto i Excel, engari te mea, ko te e hoki whai koe ki te ako e founga ki te kimihia me ngā hapa tika i roto i ngā tātai. Ko te mea tuatahi e hiahia ana koe ki te mahi i te mea ako te mea ia hapa tikanga. Ka rite ki matau koutou te mea ai te reira e pai te whakatika koe e hira hapa tātai kōnae. Tenei ko te torutoru tohutohu tere i runga i to tatou kaupapa:

• Kei te faaiteraa i to tatou taputapu Excel hanga etahi wāhanga ki Microsoft Excel, na i mua i te tīmata i tetahi wātū whakaora, tēnā katia Excel mo te ia;
• Ki te nga kōnae hiahia koe ki te ora he tātai engineering, e hiahia ana koe ki te tāuta i te "MōkīUtauta Tātaritanga". Ki te taea tonu e koe te whakatuwhera i te tuhinga kino, whakatere ki Tools> Tāpiri-mai, me te tiki "MōkīUtauta Tātaritanga";
• Ko te hapa #REF tikanga e reira ko te tohutoro kore-tika i roto i to koutou tātai. Kaua rawa e muku i ngā pūtau, tīwae, rarangi ranei tika rite taua, ki te hiahia ki te karo i tēnei hapa.