5 mau ala e wehe ai i ka hiʻona heluhelu-wale mai Excel 2021/2019/2016/2013/2010/2007
A pau kāu hoʻoponopono ʻana i ka puke haʻawina, hiki iā ʻoe ke kau i nā kapu heluhelu wale nō ma luna a hiki i nā mea āu e kaʻana like ai ke heluhelu ia, akā ʻaʻole hiki iā lākou ke hoʻoponopono i ka palapala ma kekahi ʻano. Eia naʻe, ʻo ka hoʻohana ʻana i ka heluhelu wale nō hiki ke lilo i mea keakea inā pono ʻoe e hoʻololi i ka palapala. Malia paha ua haʻi aku kekahi hoaaloha a hoa hana i ka puke haʻawina Excel heluhelu wale nō me ʻoe a poina iā ʻoe e kaʻana like me ʻoe pehea e wehe ai i kēia kaohi.
Hiki ke hoʻonohonoho ʻia ʻo Excel i ka heluhelu-wale me nā koho he nui. Ma kēia ʻatikala, papa inoa mākou i nā hihia āpau a me nā hopena pili i hiki iā ʻoe ke ʻike pehea e wehe ai i ka heluhelu mai excel i kekahi mau hihia.
Hana ʻia ʻo Excel i ka heluhelu-wale me ka hoʻohana ʻana iā "Mark as Final"
ʻO kekahi o nā kumu i heluhelu wale ʻia ai ka palapala Excel iā ʻoe, ʻo ia ka mea i hōʻailona hope ʻia e ka mea hoʻoponopono. Inā ʻo ia ka hihia, pono ʻoe e ʻike i kahi leka ma luna o ka palapala e ʻōlelo ana "Marked as final."
Ke hōʻailona hope ʻia kahi palapala, ʻaʻole hiki ke hoʻololi i ia palapala. ʻAʻole hiki iā ʻoe ke kākau, hoʻoponopono a hoʻāʻo paha i ka palapala ma kēia mokuʻāina. Akā, maʻalahi hoʻi e wehe. E kaomi wale i ka pihi "Edit anyway" ma ka hope o ka memo a hiki iā ʻoe ke hoʻopau i ka hiʻohiʻona heluhelu wale nō ma Excel.
Lilo ka faila Excel i waihona heluhelu wale nō i ʻōlelo ʻia e "Save As"
ʻO kahi kūlana ʻē aʻe no ka ʻike ʻana aia kahi palapala Excel ma ke ʻano heluhelu-wale nō e koi ʻia ʻoe e wehe i ka palapala ma ke ʻano heluhelu-wale nō ke ʻole ʻoe e hoʻololi iā ia. Inā ʻaʻole ʻoe makemake e hoʻololi i ka palapala, kaomi wale "ʻAe." A inā makemake ʻoe e hoʻoponopono i ka palapala, kaomi wale "ʻAʻole" e wehe ai.
Inā makemake ʻoe e wehe i kahi faila excel heluhelu wale nō, e hahai i kēia mau hana maʻalahi:
KaʻAnuʻu 1: Ke wehe mua ʻoe i ka palapala Excel a loaʻa iā ʻoe ka leka e hāʻawi ana iā ʻoe i ʻekolu mau koho e wehe i ka palapala heluhelu-wale nō, kaomi wale iā "ʻAe" e wehe i ka faila ma ke ʻano heluhelu wale nō.
KaʻAnuʻu 2: Inā hoʻololi ʻoe i ka ʻike o ka palapala a hoʻāʻo e mālama i nā hoʻololi, ʻike ʻia kahi leka hou e noi ana iā ʻoe e mālama i kahi kope o ka faila a hoʻololi i ka inoa. Kaomi iā "OK" e wehe i ka pahu kūkākūkā "Save As", a laila kaomi i "Tools> General Options."
KaʻAnuʻu 3: I ka "General Options" dialog box i hōʻike ʻia, wehe i ka koho "Recommended reading only" a kaomi iā "OK."
KaʻAnuʻu 4: Ma hope o ka "Save As" dialog box, kaomi "Save." E hana kēia i kope o ka faila Excel kumu. ʻAʻole e heluhelu wale ʻia ka faila i kope ʻia a hiki iā ʻoe ke hoʻomau i ka hoʻoponopono ʻana e like me kou makemake.
E wehe kēia i ka palena heluhelu-wale mai ka palapala Excel.
Paʻa a heluhelu wale ʻia ke ʻano o nā pepa Excel a me nā puke hana
Inā aia ka waihona Excel ma ke ʻano heluhelu wale nō no ka mea ua laka ʻia ka pepa haʻawina a i ʻole ka papa hana, hiki iā ʻoe ke wehe i ka palena heluhelu wale nō Excel inā ʻike ʻoe i ka ʻōlelo huna. Penei ʻoe e hana ai:
KaʻAnuʻu 1: E wehe i ka faila Excel i pale ʻia, no laila hiki iā ʻoe ke ʻike i nā pepa hana āpau a me kā lākou ʻike.
KaʻAnuʻu 2: Kaomi "Review" ma ka papa kuhikuhi nui a laila koho i ka "Unprotect Sheet" ma lalo o "Changes." E hoʻokomo i ka ʻōlelo huna e hoʻopau i ke kaʻina hana.
KaʻAnuʻu 3 : Inā ʻo ia ka ʻōnaehana puke hana i pale ʻia, kaomi i ka "Unprotect Workbook" a laila e hoʻokomo i ka ʻōlelo huna e wehe i ka palena.
E mālama i ka palapala a e wehe ʻia ke kapu heluhelu wale nō.
Ua kapu ʻia ka ʻōlelo huna a Excel ma ke ʻano he heluhelu wale nō
I kekahi manawa ke wehe ʻoe i kahi faila Excel i hoʻopili ʻia, e noi ʻia ʻoe e hoʻokomo i ka ʻōlelo huna no ke komo kākau ʻana a i ʻole e wehe iā ia i ka heluhelu wale nō. Kaomi ma ka koho "Read only" a e kaupalena ʻia ka faila Excel i ka hoʻololi a me ka heluhelu ʻana. E hahai i kēia mau ʻanuʻu e wehe i ka faila Excel heluhelu wale nō:
KaʻAnuʻu 1. E mālama i ka faila Excel i kēia manawa he heluhelu-wale nō ma ke kaomi ʻana i File > Save As.
KaʻAnuʻu 2. E mālama wale iā ia ma ke ʻano he palapala Excel ʻē aʻe a kaomi iā "Save" e hoʻomau.
I kēia manawa hiki iā ʻoe ke wehe i ke kope o ka faila Excel a hoʻololi iā ia.
Manaʻo Bonus: Wehe iā Excel heluhelu wale me ka ʻole o ka ʻōlelo huna (no nā hihia āpau ma luna)
Inā makemake ʻoe e wehe i ke ʻano "heluhelu-wale" o Excel hoʻonohoʻia e nā koho a pau i hoʻokahi kaomi wale nō me ka ʻōlelo huna ʻole , a laila ʻo kekahi o nā ala maikaʻi loa e hana ai i kēia me ka hoʻohana ʻana i kahi mea hana wehe ʻōlelo huna Excel e like me Passper no Excel .
Passper no Excel He mea hana ia e hiki ai iā ʻoe ke wehe i nā hoʻonohonoho heluhelu-wale nō me ka hoʻohana ʻana iā Mark as Final and Save As, wehe i nā palena o ke ʻano o nā pepa Excel a me nā puke hana, a wehe i ka ʻōlelo huna ma kekahi palapala Excel i laka ʻia.
No laila, he mea pono loa ia inā ʻaʻole hiki iā ʻoe ke wehe a hoʻoponopono i kahi palapala Excel heluhelu wale nō. ʻO kēia kekahi o kāna mau hiʻohiʻona:
Passper for Excel: Hoʻopau i ka heluhelu ʻana iā Excel i 2 kekona:
- Hoʻopili ʻia nā hihia a pau: Hoʻopau a hoʻopau paha i ka heluhelu ʻana iā Excel i nā hihia āpau.
- Ka helu lanakila kiʻekiʻe: ʻO ka algorithm holomua e hōʻoiaʻiʻo a 100% ka wehe ʻana .
- Maʻalahi e hoʻohana : He mea maʻalahi hoʻi e hoʻohana. Me ia, hiki iā ʻoe ke hoʻihoʻi hou i ka ʻōlelo huna i loko o kekahi mau ʻanuʻu maʻalahi a wehe i nā mea paʻa i hoʻokahi kaomi.
Pehea e wehe ai i nā faila Excel heluhelu-wale me Passper no Excel
Eia pehea e hoʻohana ai iā Passper for Excel e wehe i nā kapu heluhelu wale nō mai kahi palapala Excel:
KaʻAnuʻu 1: Hoʻoiho a hoʻouka Passper no Excel ma kāu kamepiula a laila wehe. Ma ka puka makani nui, koho "Wehe i nā kapu «.
KaʻAnuʻu 2: Kaomi "Add" e hoʻokomo i ka palapala i kaupalena ʻia i Passper.
KaʻAnuʻu 3: Ke hoʻokomo pono ʻia ka palapala i ka papahana, kaomi "E hoopau » a e hoʻopau ʻia nā kapu heluhelu wale nō ma ka palapala Excel.
Manaʻo kōkua: E like me kā mākou i ʻōlelo ai ma mua, hiki ke hoʻohana ʻia ʻo Passper for Excel e hoʻihoʻi hou i nā ʻōlelo huna. Inā ua nalowale ʻoe i ka ʻōlelo huna e wehe ai i kāu faila Excel a i ʻole ua loaʻa iā ʻoe kahi faila Excel i pale ʻia me kahi ʻōlelo huna wehe, hiki iā ʻoe ke hoʻāʻo.
Ka hopena
ʻO nā mea i luna nei nā ala maikaʻi loa 5 no ʻoe inā ʻaʻole ʻoe ʻike pehea e wehe ai i ka heluhelu mai excel . E ʻoluʻolu e hoʻomaopopo he nui paha nā kumu i hiki ʻole ai iā ʻoe ke komo i ka palapala Excel, ʻoiai ʻo kekahi o nā mea maʻamau ʻo ia ke "hōʻailona hope ʻia" ka palapala. Passper no Excel hiki iā ʻoe ke komo maʻalahi i ka palapala me ka nānā ʻole i nā kaohi i kau ʻia, me kahi palapala mālama ʻōlelo huna.