Pehea e hana ai i faila kiʻi mai kahi pakuhi Excel a i ʻole e hoʻokuʻu aku iā Word a i ʻole PowerPoint

Ma hope o ka heluhelu ʻana i kēia ʻatikala, e aʻo ʻoe pehea e hana ai i kahi faila kiʻi ʻokoʻa (.png, .jpg, .bmp a i ʻole kekahi ʻano ʻē aʻe) mai kahi pakuhi ma Excel a i ʻole e hoʻokuʻu aku iā ia, no ka laʻana, i kahi palapala Word a i kahi hōʻike PowerPoint.

ʻO Microsoft Excel kekahi o nā noi noiʻi ʻikepili ikaika loa. I loko o kāna arsenal he nui nā mea hana a me nā hana no ka nānā ʻana i kēia ʻikepili. ʻO nā kiʻi (a i ʻole nā ​​kiʻi) kekahi mea hana. No ka hana ʻana i kahi pakuhi ma Excel, pono ʻoe e koho i ka ʻikepili a kaomi i ka ikona pakuhi ma ka ʻāpana papa kuhikuhi.

Akā, e kamaʻilio e pili ana i nā pono, pono e haʻi i nā nāwaliwali. ʻO ka mea pōʻino, ʻaʻohe ala maʻalahi ma Excel e mālama i kahi pakuhi ma ke kiʻi a i ʻole e hoʻokuʻu aku i kahi palapala ʻē aʻe. He mea maikaʻi inā hiki iā mākou ke kaomi pololei ma ka pakuhi a ʻike i kahi kauoha like Mālama e like me ke kaha kiʻi or mea hoʻolilo. Akā, no ka mea ʻaʻole mālama ʻo Microsoft i ka hana ʻana i ia mau hana no mākou, a laila e hana mākou i kahi mea iā mākou iho.

Ma kēia ʻatikala, e hōʻike wau iā ʻoe i nā ala 4 e mālama ai i kahi pakuhi Excel ma ke ʻano he kiʻi e hiki ai iā ʻoe ke hoʻopili ma hope i nā palapala Office ʻē aʻe, me Word a me PowerPoint, a i ʻole e hoʻohana iā ia e hana i kekahi mau infographics nani.

• E kope i ke kiʻikuhi i ka mea hoʻoponopono kiʻi a mālama ma ke ʻano he kiʻi
• E hoʻokuʻu aku i kahi pakuhi mai Excel i Word a i ʻole PowerPoint
• E mālama i nā pakuhi puke hana Excel ma ke ʻano he kiʻi
• Mālama i ka pakuhi ma ke ʻano he kiʻi me ka VBA Macro

E kope i ke kiʻikuhi i ka mea hoʻoponopono kiʻi a mālama ma ke ʻano he kiʻi

Ua haʻi mai kekahi hoaaloha iaʻu i kahi mea huna: hana maʻamau ʻo ia i kāna mau palapala mai Excel a i Paint. Hana ʻo ia i ka pakuhi a kaomi wale i kahi kī Nā ʻikepili, a laila wehe i ka pena a hoʻopili i ke kiʻi. Ma hope o kēlā, ʻoki ʻo ia i nā wahi i makemake ʻole ʻia o ke kiʻi a mālama i ke koena kiʻi i kahi faila. Inā ua hana like ʻoe i kēia manawa, e poina a mai hoʻohana hou i kēia ʻano kamaliʻi! E hana wikiwiki mākou a ʻoi aku ka naʻauao! 🙂

No ka laʻana, ma kaʻu Excel 2010, ua hana wau i kahi pakuhi paʻi XNUMX-D nani e hōʻike ana i ka ʻikepili e pili ana i ka demographics o kā mākou mau malihini kipa, a i kēia manawa makemake wau e hoʻokuʻu aku i kēia pakuhi mai Excel ma ke kiʻi. E hana pū kākou:

1. Kaomi pololei ma ka ʻāpana o ka pakuhi a kaomi ke kope (Kopi). ʻAʻohe pono e kaomi i ka pakuhi pono'ī, no ka mea, e koho kēia i nā mea hoʻokahi, ʻaʻole ke kiʻi holoʻokoʻa, a me ke kauoha. ke kope (Kopi) ʻaʻole e ʻike ʻia.
2. E wehe i ka pena a hoʻopili i ka pakuhi me ke kiʻiona hookomo (Paste) tab Home (Home) a kaomi Ctrl + V.
3. I kēia manawa, e mālama wale i ke kiʻi ma ke ʻano he faila kiʻi. Kaomi E mālama i (E mālama iā ʻoe) a koho i kekahi o nā ʻano i manaʻo ʻia (.png, .jpg, .bmp a i ʻole .gif). Inā makemake ʻoe e koho i kahi ʻano ʻokoʻa, kaomi Nā palapala ʻē aʻe (nā ʻano ʻē aʻe) ma ka hope o ka papa inoa.

ʻAʻole hiki ke maʻalahi! No ka mālama ʻana i kahi pakuhi Excel ma kēia ʻano, e hana kekahi mea hoʻoponopono kiʻi.

E hoʻokuʻu aku i kahi pakuhi mai Excel i Word a i ʻole PowerPoint

Inā pono ʻoe e hoʻokuʻu aku i kahi pakuhi mai Excel i kekahi palapala Office ʻē aʻe, e like me Word, PowerPoint, a i ʻole Outlook, ʻo ke ala maikaʻi loa e hana ai i kēia ma o ka clipboard.

1. E kope i ka pakuhi mai Excel e like me ka laʻana mua ma 'anuʻu 1.
2. Ma kahi palapala Word a i ʻole hōʻike PowerPoint, kaomi ma kahi āu e makemake ai e hoʻokomo i ka pakuhi a kaomi Ctrl + V. A i ʻole ma kahi o ke kaomi ʻana Ctrl + V, kaomi ʻākau ma nā wahi a pau o ka palapala, a e wehe ʻia nā koho hou aʻe i mua ou ma ka ʻāpana Hoʻopili i nā koho (E hoʻopili i nā koho).

ʻO ka pōmaikaʻi nui o kēia ʻano hana, ʻo ia ka mea e lawe ʻia ai kahi pakuhi Excel piha i kahi faila ʻē aʻe, ʻaʻole i kahi kiʻi wale nō. E hoʻomau ʻia ka pakuhi i ka pepa Excel kumu a e hōʻano hou i ka wā e hoʻololi ai ka ʻikepili i kēlā pepa Excel. ʻO ia ke ʻano ʻaʻole pono ʻoe e kope a paʻi hou i ka pakuhi me kēlā me kēia hoʻololi i ka ʻikepili i hoʻohana ʻia no ke kūkulu ʻana.

E mālama i kahi pakuhi ma Word a me PowerPoint ma ke ʻano he kiʻi

Ma nā polokalamu Office 2007, 2010, a me 2013, hiki ke kope ʻia kahi pakuhi Excel ma ke kiʻi. I kēia hihia, e hana ia e like me ke kiʻi maʻamau a ʻaʻole e hoʻonui ʻia. No ka laʻana, e hoʻokuʻu aku i kahi pakuhi Excel i kahi palapala Word 2010.

1. Ma kahi puke hana Excel, e kope i ka pakuhi, a laila e wehe i kahi palapala Word, e kau i ka piko ma kahi āu e makemake ai e hoʻopili i ka pakuhi, a kaomi i ka pua ʻeleʻele liʻiliʻi ma lalo o ke pihi. hookomo (Paste), aia ma ka pā Home (Home).
2. Ma ka papa kuhikuhi e wehe ana, makemake mākou i ka mea Hoʻopili kūikawā (Paste Special) - Hōʻike ʻia ia e kahi pua ma ke kiʻi ma luna. Kaomi iā ia - e wehe ʻia kahi pahu kamaʻilio o ka inoa like me kahi papa inoa o nā palapala kiʻi i loaʻa, me Bitmap (bitmap), GIF, PNG a me JPEG.
3. E koho i ka palapala makemake a kaomi OK.

He mea paahana paha Hoʻopili kūikawā Loaʻa (Paste Special) i nā mana mua o Office, akā i kēlā manawa ʻaʻole wau i hoʻohana, no laila ʻaʻole wau e ʻōlelo 🙂

E mālama i nā pakuhi puke hana Excel ma ke ʻano he kiʻi

Maikaʻi nā ʻano hana a mākou i kamaʻilio ai i ka wā e pili ana i kahi helu liʻiliʻi o nā kiʻi. He aha inā inā pono ʻoe e kope i nā palapala āpau mai kahi puke hana Excel? Inā ʻoe e kope a paʻi i kēlā me kēia o lākou, hiki ke lōʻihi ka manawa. Ua wikiwiki au e ʻoluʻolu iā ʻoe - ʻaʻole pono ʻoe e hana i kēia! Aia kahi ala e mālama ai i nā pakuhi āpau mai kahi puke hana Excel i ka manawa hoʻokahi.

1. A pau ʻoe i ka hana ʻana i nā pakuhi i kāu puke hana, kaomi i ka File (File) a kaomi i ke pihi E mālama i (Save as).
2. E hōʻike ʻia kahi pahu kamaʻilio Mālama i kahi palapala (Save as). Ma ka papa inoa hāʻule iho Pūnae Puna (Save as type) koho Веб-страница (Papa pūnaewele, *.htm, *.html). E nānā pū i kēlā ma ka ʻāpana Save (E mālama) koho ʻia Buke holookoa (Puke Hana holoʻokoʻa) e like me ka mea i hōʻike ʻia ma ke kiʻi ma lalo nei:
3. E koho i kahi waihona e mālama ai i nā faila a kaomi i ke pihi Save (Mālama).

I ka waihona i koho ʻia me nā faila .html ʻO nā pakuhi a pau i loko o ka puke hana Excel e kope ʻia nā faila . Png. Hōʻike ka paʻi kiʻi ma lalo i nā mea o ka waihona kahi aʻu i mālama ai i kaʻu puke hana. ʻO kaʻu puke hana Excel he ʻekolu ʻāpana me kahi pakuhi ma kēlā me kēia - a ma ka waihona aʻu i koho ai, ʻike mākou i ʻekolu mau palapala i mālama ʻia e like me nā faila kiʻi. . Png.

E like me kāu e ʻike ai, ʻo PNG kekahi o nā ʻano hoʻopiʻi kiʻi maikaʻi loa kahi i nele ai ka maikaʻi. Inā makemake ʻoe e hoʻohana i nā ʻano kiʻi ʻē aʻe, a laila e hoʻohuli iā lākou i .jpg, . ʻO Gif, .bmp a i ʻole e paʻakikī kekahi.

Mālama i ka pakuhi ma ke ʻano he kiʻi me ka VBA Macro

Inā makemake pinepine ʻoe e hoʻokuʻu aku i nā pakuhi Excel ma ke ʻano he kiʻi, hiki iā ʻoe ke hoʻokaʻawale i kēia hana me ka hoʻohana ʻana i kahi macro VBA. ʻO ka mea pōmaikaʻi, nui nā macros i kākau mua ʻia, no laila ʻaʻole pono mākou e hana hou i ka huila 🙂

No ka laʻana, hiki iā ʻoe ke hoʻohana i ka hoʻonā hoʻāʻo a ʻoiaʻiʻo i kau ʻia e John Peltier ma kāna blog. He maʻalahi loa kāna macro:

ActiveChart.Export "D:My ChartsSpecialChart.png"

Hoʻokumu kēia laina code i kahi faila kiʻi ma ka waihona i hāʻawi ʻia . Png a lawe aku i ke kiʻikuhi i laila. Hiki iā ʻoe ke hana i kāu macro mua i kēia manawa ma 4 mau ʻanuʻu maʻalahi, ʻoiai inā ʻaʻole ʻoe i hana ma mua o kou ola.

Ma mua o kou hoʻomaka ʻana e kākau i kahi macro, e hoʻomākaukau i kahi waihona no ka lawe ʻana i ka pakuhi. I kā mākou hihia, ʻo ia ka waihona ʻO kaʻu mau palapala ma ka diski D. No laila, pau ka hoʻomākaukau ʻana, e hana kākou i ka macro.

1. Ma kāu puke hana Excel, wehe i ka pā mea haku polokalamu (Developer) a ma ka ʻāpana Code (Code) kaomi ikona macros (Macros).

'Ōlelo Aʻo: Inā ʻoe e hana i kahi macro no ka manawa mua, a laila, ʻoi aku paha, ʻo ka tab mea haku polokalamu (Developer) e hūnā ʻia. I kēia hihia, e hele i ka pā File (File), kaomi kiko'î (Nā koho) a wehe i ka ʻāpana Hoʻonohonoho lipine (Hoʻopilikino i nā Lipine). Ma ka ʻaoʻao ʻākau o ka puka aniani, ma ka papa inoa Nā papa nui (Main Tabs) e nānā i ka pahu ma ka ʻaoʻao mea haku polokalamu (Developer) a kaomi OK.

2. E hāʻawi i inoa i ka macro hou, no ka laʻana, SaveSelectedChartAsImage, a e hoʻolako iā ia no kēia puke hana wale nō.
3. Kaomi i ka pihi Hoʻoulu (E hana), e wehe kēia i ka puka makani hoʻoponopono Visual Basic, kahi e hōʻike ʻia ai ka hoʻomaka a me ka hopena o ka macro hou. Ma ka laina ʻelua, e kope i kēia kikokikona macro:

   ActiveChart.Export "D:My ChartsSpecialChart.png"

   

4. E pani i ka Visual Basic Editor a ma ka pā File (Filet) kawili E mālama i (Save as). E mālama i kāu puke hana e like me Puke hana Excel i hiki ke Macro (Puke Hana Macro-Enabled Excel, *.xlsm). ʻO ia, ua hana ʻoe!

I kēia manawa, e holo kāua i ka macro a mākou i hana ai e ʻike pehea e hana ai. E kali i kekahi minuke… Aia kekahi mea hou a mākou e hana ai. Pono mākou e koho i ka pakuhi Excel a mākou e makemake ai e hoʻokuʻu aku no ka mea hana wale kā mākou macro me ka pakuhi i koho ʻia. Kaomi ma kahi o ka lihi o ka pakuhi. ʻO ke kiʻi hina hina e ʻike ʻia a puni ke kiʻikuhi e hōʻike ana ua koho piha ʻia.

E wehe hou i ka pā mea haku polokalamu (Developer) a kaomi i ka ikona macros (makoko). E wehe ʻia kahi papa inoa o nā macros i kāu puke hana. Kahakaha SaveSelectedChartAsImage A e kaomi i holo (Holo).

I kēia manawa e wehe i ka waihona āu i kuhikuhi ai e mālama i ka faila - pono ke kiʻi . Png me ke kiʻikuhi i lawe ʻia aku. Hiki iā ʻoe ke mālama i nā pakuhi ma ke ʻano like ʻole. No ka hana ʻana i kēia, ua lawa ia e hoʻololi i ka macro . Png on .jpg or . ʻO Gif - e like me kēia:

ActiveChart.Export "D:My ChartsSpecialChart.jpg"

ʻO ia wale nō no kēia lā, a ke manaʻolana nei au ua hauʻoli ʻoe i ka heluhelu ʻana i kēia ʻatikala. Mahalo iā ʻoe no ka nānā ʻana!