Ka rite ki zaparoleny Excel-kōnae, ka tango tiaki

I teie mahana, e aparau i tatou pehea zaparoleny Excel-kōnae. Tenei taputapu Ko wāhanga o Microsoft Office. taea hōtaka Excel ki a koutou te hanga tepu o rerekē whīwhiwhi, te whakamahi tātai, me te hoahoa takitahi. tautoko katoa putanga o te tono o nāianei whirihoranga kupuhipa.

ako

puta tatou ki te wāhanga o te whakaahuatanga tukanga o te āhua o te Excel-kōnae record whakaora. whakaratohia ana tēnei āheinga i roto i te hōputu kōnae * .xls, rite ki tetahi atu tuhinga Microsoft Office, tae atu Kupu me te Access. Na, i muri i te mutunga o te tuhinga pēhi te pātene "Kōnae", kei nei i roto i te tahua i te runga matapihi Microsoft Excel. I roto i te rārangi e puta, tahuri ki te "rite Tiaki" mā te pāwhiri i runga taua mea kotahi ki te pātene kiore maui. Ko te pouaka kōrero ki te whakaora i te tuhinga, i reira te mea he tahua "Utauta", pāwhiri i te tapatoru Taupokia, a ka whakamahi i te mahi hou "tautuhinga General".

whakatikatikanga

puta tatou ki te wāhanga i muri o te whakatau pehea zaparoleny Excel-kōnae. puta wāhanga "Tautuhinga General" i runga i te mata. Here me tomo koutou te kupuhipa ki te huri whakatuwhera i te tuhinga ranei. I tua atu, ki te whakahohe koe i te mahi "Pānuitia anake" ka ngana ki te whakatuwhera i te kōnae Excel tiaki-kupuhipa, te paeutauta ka taunoa ki hauā.

Ki te tāuta koe i te tiaki anake ki te rere i te tuhinga, ka puta he tono mō te tāuru wa katoa whakatuwhera koe i te tepu. I roto i tenei take, ngā kaiwhakamahi katoa te hunga e mohio i te huinga ngaro, ka taea ki te hanga me te huānga whakatika raraunga. I runga i te pātai o te pehea, ki te whakatuwhera i te kōnae tiaki-kupuhipa Excel, ki te te whakaturia tiaki te ki te huri i te rauemi, ka tango i te whakarewatanga wahi rite paerewa, kahore tetahi uiui. Heoi, ki te tāpiri koe ki te raraunga hou tepu, me te ngana ki te whakaora i te tuhinga, ka ui te taupānga mō te huinga ngaro.

A, no te hiahiatia momo e rua o kupuhipa, urunga rua i roto i te whakaohonga me whakaweto o te rauemi. He mea nui ki te mohio e taea e koe whakaturia rerekē kupuhipa mō te whakatika me te whakatuwhera i te kōnae.

Haere hoki ki te tautuhinga. A, no te he kupuhipa (te korohū ranei) whakaturia te, pāwhiri i te "tautuhinga General" pātene «OK». I roto i te Windows Explorer, te ingoa tuhinga tomo te, whakaorangia te kōnae mā te whakamahi i te mahi e tika ana.

tango tiaki

Next, a aparau i tatou pehea te tutakina iho te kupuhipa i roto i Excel. Hei whakaoti i te raruraru e kore e hiahia ana tetahi atu pūmanawa, no te mea e whakaratohia ana te mahi e tono taputapu hanga-i roto i.

Run Excel. Whakatūwhera te tuhinga e hiahia ana koe ki te maka o te tiaki kupuhipa. "Kōnae" whakamahi tahua. Tauwhāiti "Tiaki Hei", a ka whakatuwhera i te tahua "Ratonga". Haere ki te "Tautuhinga General", te whakamahi i te kiore pāwhiri-rua i runga i te atú i roto i te wawe kupuhipa. Whakamahia te «Del» pātene mo te mahi e hiahiatia ana. whakau tatou i te mahi e «OK» pātene te pēhi. Pāwhiritia "Save" a ka "Ae" i roto i te matapihi hou.

Ko te katoa i roto i te kupuhipa pukamahi Excel nekehia. Ki te whārangi katoa puta i roto i te tikanga ōrite. Whakatūwhera te tahua "Utauta", te whakamahi i te whakahau "Wewete". Hei whakaū i te mahi whakakorenga i koe ki te tomo i te kupuhipa whakaritea i mua. Na e matau ana koutou e founga zaparoleny-kōnae Excel, me te whakakore i te tiaki, ki te tika.