6 nga huarahi ki te whakakore i te panui i roto i te Excel 2016

Ka taea te whakauru i te konae Excel ki te aratau panui-anake ka tohua te konae hei whakamutunga, ka tiakina hei panui-anake, ka maukati ranei te riipene, te hanganga pukamahi, aha atu. Heoi, ahakoa te awhina o te panui, ka taea hoki te aukati, ina koa kare koe e mohio ki te tango i te here.

I roto i tenei tuhinga, ka titiro tatou ki etahi o nga huarahi ki te monohia te panui i roto i te Excel 2016 ahakoa kei a koe te kupuhipa, kaore ranei.

Wāhanga 1. Tikanga noa ki te Mono Panui i Excel 2016 Kore Kupuhipa

Ko te whakakore i te waahanga panui-anake i roto i te Excel he uaua, ahakoa kaore e taea, ina kore koe e mohio ki te kupuhipa i whakamahia hei tuu i te here. Heoi ano, he taputapu kei te maakete hei awhina i a koe ki te whakakore i te panui i te Excel 2016 ngawari. Ko tetahi o nga mea tino pai Passper mo Excel .

Ko enei e whai ake nei etahi o nga ahuatanga ka tukuna e Passper for Excel:

• Ka tautokohia te tango momo katoa mai i te aratau panui-anake kore kupuhipa.
• Tango kupuhipa tuwhera a whakakorea te tiaki o panui noa i roto pepa mahi/pukapuka Excel 2016 me te kore e pa ki nga raraunga tuhinga.
• Wewete i nga tuhinga Excel ina kua wareware koe ki te kupuhipa, kaore e taea te kape i te ripanga, te raraunga pukamahi ranei, kaore e taea te ta i te ripanga/pukamahi, kaore e taea te whakatika i nga ihirangi o te tuhinga.
• I tua atu, ko te tino ngawari ki te whakamahi , na te mea ka taea e koe te whakakore i te panui i te paato kotahi.
• Ka tautoko i nga putanga katoa o nga tuhinga Excel, tae atu ki te Excel 96-Excel 2019.

Whakamātauria mō te kore utu

Anei me pehea te whakamahi i te Passper for Excel hei tango i te panui i tetahi tuhinga Excel:

Hipanga 1: Tikiake me te whakauru i te Passper for Excel ki runga i to rorohiko ka whakarewahia te kaupapa.

Hipanga 2: Paatohia te "Tangohia nga Rahui" ka paato i te "Tāpiri" ki te kimi i te tuhinga Excel kua herea i roto i te papatono.

Hipanga 3: Ina taapirihia te konae ki te papatono, pawhiria te "Muku" ka timata tonu a Passper for Excel ki te tango i nga here mai i te konae. I roto i etahi hēkona, ka taea e koe te uru atu ki te tuhinga Excel 2016 kaore he here.

Whakamātauria mō te kore utu

Wāhanga 2. 5 Take Rerekē hei Mono i te Panui i Excel 2016

E 5 te nuinga o nga keehi ka tohua to Excel 2016 hei panui-anake, ko ta raatau otinga ko te whakakore i te waahanga panui-anake.

Take 1: Ina mahia te tuhinga panui-anake i te wa e penapena ana

Ka taea e koe te whakamahi i te waahanga "Tiaki Hei" penei i raro nei hei whakaweto i te aratau panui i Excel 2016:

Hipanga 1: Me timata ma te whakatuwhera i te pukamahi Excel ka uru ki te kupuhipa mena e tika ana. Patohia te "Kōnae> Tiaki Hei" ka kowhiri i tetahi waahi pai ki to rorohiko hei tiaki i te konae.

Paahi 2: Patohia te pere taka-iho ki te taha o te paatene "Nga taputapu » ka kowhiri «Kōwhiringa whānui «.

Paahi 3: Mukua te kupuhipa ka puta mai i te pouaka "Kupuhipa hei whakarereke" ka paato i te "OK" ki te hiki i te aukati panui-anake. Pāwhiritia "OK."

Paahi 4: Ka mutu, pawhiria te "Tiaki" ki te whakaoti i te tukanga.

Take 2: Ina tohua te tuhinga hei whakamutunga

Ma te tohu i to tuhinga Excel 2016 hei "Whakamutunga" ka waiho he here panui-anake ki te tuhinga. Anei me pehea te whakakore i tenei here i runga i te tuhinga kua tohua hei whakamutunga.

Hipanga 1: Whakatuwheratia te tuhinga Excel 2016 kua herea ki to rorohiko.

Hipanga 2: I te tihi o te tuhinga, me kite koe i te paatene "Whakatika ahakoa «. Patohia ka whakakorehia te aukati panui-anake, ka taea e koe te whakatika i te tuhinga.

Take 3: I te wa e maukati ana te ripanga, te hanganga pukamahi ranei

Ka taea hoki te aukati panui-anake ina maukati te kaituhi o te tuhinga Excel 2016 i te hanganga o te raumahi, pukamahi ranei, kia kore ai te raumahi e whakatika. I tenei keehi, ka taea e koe te whakaoti i te raru i roto i nga huarahi ngawari e whai ake nei:

Hipanga 1: Whakatuwheratia te tuhinga Excel me te here panui-anake, ka paato «Arotake > Wewete pepa «.

Hipanga 2: Whakauruhia te kupuhipa ki te pouaka e tika ana ka paato "OK" ki te hiki i te here.

Take 4: Ina he mana panui-anake te tuhinga

Ka taea te whakakore i te panui i roto i te Excel 2016 ma te whakamahi i te kōwhiringa Āhuatanga Kōnae i Windows File Explorer. Koinei te huarahi e mahi ai koe:

Hipanga 1: I te File Explorer, whakatere ki te konae Excel kua herea. Pāwhiri-matau i te tuhinga, ka kowhiri "Ahuatanga" i roto i nga whiringa ka tukuna.

Hipanga 2: Wetetaki i te kōwhiringa "Panui anake "i roto i te waahanga «Huanga » ka paato i te «OK» ki te whakakore i nga here panui-anake.

Take 5: Ina hiahia te tuhinga Excel 2016 he kupuhipa

Ina hiahia koe ki te whakauru kupuhipa hei uru me te whakatika i te tuhinga Excel 2016, ka taea e koe te whai i enei mahi ngawari ki te hiki i tenei here:

Hipanga 1: Me timata ma te whakatuwhera i te tuhinga Excel 2016 e hiahia ana koe ki te whakaweto i te waahanga panui-anake.

Hipanga 2: Ka puta te pouaka kupuhipa, pawhiria "Panui anake » engari ka tuwhera te tuhinga ki te aratau Panui Anake.

Hipanga 3: Paatohia inaianei "Puranga > Tiaki hei » ka tāuru he ingoa kōnae kē. Paatohia te « Puritia » ki te tiaki i tetahi kape hou o te konae taketake.

Ko te konae hou i hangaia ka whakakapi i te tuhinga panui-anake, karekau he here o te tuhinga taketake.

Ko nga otinga i runga ake nei ka ngawari ki a koe te whakakore i te panui-anake i roto i te Excel 2016 ahakoa kei a koe te kupuhipa, kaore ranei. Whiriwhiria te tikanga e pai ana ki o hiahia me to ahuatanga. Me mohio mai mena ka taea e koe te hiki te here panui-anake i roto i te waahanga korero i raro nei.

Whakamātauria mō te kore utu