Astro's Blog

<p style="text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwtiLSE8IVJ81IIK6QVpR19PSPwu4UEaxnvxACMYwJQa9_o_YVqE2xAusqMwcWzQ4Ll0dPDKiHkzhv6nQ3VLaWrGBQqYTZ0B0DtUF3Gow8nVwRRJoKrdZWTqJKiWO82hK3KaGGnEp4YeBrpC1cfMJoh0TUo2sU7bH4tzP0Hr6m4vAoElmO0e330z307W0s/s1011/Excel002.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="624" data-original-width="1011" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwtiLSE8IVJ81IIK6QVpR19PSPwu4UEaxnvxACMYwJQa9_o_YVqE2xAusqMwcWzQ4Ll0dPDKiHkzhv6nQ3VLaWrGBQqYTZ0B0DtUF3Gow8nVwRRJoKrdZWTqJKiWO82hK3KaGGnEp4YeBrpC1cfMJoh0TUo2sU7bH4tzP0Hr6m4vAoElmO0e330z307W0s/w400-h248/Excel002.png" width="400" /></a><br /></p><div><b style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;"><br /></span></b></div><div><b style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;">[合併資料的分拆]</span></b></div><div><b style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;"><br /></span></b></div><div><span style="background-color: white;"><div class="separator" style="clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px; font-weight: bold; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaItoTcRo6QbeiQpSW8Ty5elF7MrW0UphCrHAzijBsp7ULqaQAC7MYPTVjWur1G-kFE1zmH_Dxw6feftCRh97ou1_bNLs0p-Unk-7NfsTDC6E0AMk10pXSIicB7s-jCsJbTuWQueFEyBZQ4f_l75aB-2ER87AEcPnVjwxB1AxjiCYapmTXWJ4NnclbTyOm/s1211/Sseparate.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="367" data-original-width="1211" height="194" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaItoTcRo6QbeiQpSW8Ty5elF7MrW0UphCrHAzijBsp7ULqaQAC7MYPTVjWur1G-kFE1zmH_Dxw6feftCRh97ou1_bNLs0p-Unk-7NfsTDC6E0AMk10pXSIicB7s-jCsJbTuWQueFEyBZQ4f_l75aB-2ER87AEcPnVjwxB1AxjiCYapmTXWJ4NnclbTyOm/w640-h194/Sseparate.png" width="640" /></a></div><br /><div style="text-align: left;">A欄中的每個儲存格包含了一些合併的資料，可以將這些合併的資料分割出來，並填入例如C欄的每一個空白儲存格中。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC_tECu8NfhSzj-6CkiNZkXOxIcsl2_lv6THdAdOKyvuEejnUFVCdAofxyg6F8I4L6Bz2s3_rcU35ZsHyjVE4rhFMiw7q20q2VvD2RLokrI9KVdKlV4knWlFkB4tOsLg6PlS_USHBf5CkV9X8mh_lm-1ZD2ugaGx68RzCPMslbsPUHrjfSz_V8WhmccyTB/s1124/Sseparate002.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="553" data-original-width="1124" height="314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC_tECu8NfhSzj-6CkiNZkXOxIcsl2_lv6THdAdOKyvuEejnUFVCdAofxyg6F8I4L6Bz2s3_rcU35ZsHyjVE4rhFMiw7q20q2VvD2RLokrI9KVdKlV4knWlFkB4tOsLg6PlS_USHBf5CkV9X8mh_lm-1ZD2ugaGx68RzCPMslbsPUHrjfSz_V8WhmccyTB/w640-h314/Sseparate002.png" width="640" /></a></div><br /><div style="text-align: left;">首先，選擇要分析的資料位置，然後按「資料」>「資料分析」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSOb6Bk6kNnoUtQDu7p5UJKhbDntMim_mI9EbQmQHGBcie9ha4kKslQl2XKfD9HjUbgLZNkSV5XedNw1gwqPG9DfmIWeGh9r-RB9ex93ui_OO5jFjD5d9XHxepC7sN-IDJp7A0wZbUOJkgrSXwe8EAOhj1R4nomErWl0E8i8z_3_kt4-8Rk1AFoGCvpLE1/s756/Sseparate003.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="573" data-original-width="756" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSOb6Bk6kNnoUtQDu7p5UJKhbDntMim_mI9EbQmQHGBcie9ha4kKslQl2XKfD9HjUbgLZNkSV5XedNw1gwqPG9DfmIWeGh9r-RB9ex93ui_OO5jFjD5d9XHxepC7sN-IDJp7A0wZbUOJkgrSXwe8EAOhj1R4nomErWl0E8i8z_3_kt4-8Rk1AFoGCvpLE1/w640-h486/Sseparate003.png" width="640" /></a></div><br /><div style="text-align: left;">原始資料類型選擇「分隔符號」，點擊「下一步」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg60QLye7kWW87rAdNgNoDJaei1KcW3ssXFgGPZabI1y_LnyspZ_n5vHnaeRO1_65nfDdI_8WgXkBXfJYF2gLffobEG_-7VRBzOSySoS8cVsa3uGa1tNT0czVzyi7M7-dLZ4FQR8OsjQUQ-AhirURTtd6NQNjeOuSMbcwOe0BPLYqaVweLywo_SGMA5MX1a/s720/Sseparate004.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="579" data-original-width="720" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg60QLye7kWW87rAdNgNoDJaei1KcW3ssXFgGPZabI1y_LnyspZ_n5vHnaeRO1_65nfDdI_8WgXkBXfJYF2gLffobEG_-7VRBzOSySoS8cVsa3uGa1tNT0czVzyi7M7-dLZ4FQR8OsjQUQ-AhirURTtd6NQNjeOuSMbcwOe0BPLYqaVweLywo_SGMA5MX1a/w640-h514/Sseparate004.png" width="640" /></a></div><br /><div style="text-align: left;">分隔符號點選其他，然後在空白位置上按下「Ctrl + J」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZsLgq_VrX38hrND_aTV7dzDzYoDPUw4QZQbcNm25jIXWNHBCzIbuO03dF4qTKR_qpQmdgASZSB_HBJ0GtvfOTEY2EWBXlrxfftXtIj6CubunBJaZHu5pi8BEg6EvPDMAaSMiNalsFvVN0tWQ10HcSqmPM1QkEwr73emZpaOPITYacWsdouAvo9VaQ31N7/s722/Sseparate005.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="567" data-original-width="722" height="502" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZsLgq_VrX38hrND_aTV7dzDzYoDPUw4QZQbcNm25jIXWNHBCzIbuO03dF4qTKR_qpQmdgASZSB_HBJ0GtvfOTEY2EWBXlrxfftXtIj6CubunBJaZHu5pi8BEg6EvPDMAaSMiNalsFvVN0tWQ10HcSqmPM1QkEwr73emZpaOPITYacWsdouAvo9VaQ31N7/w640-h502/Sseparate005.png" width="640" /></a></div><br /><div style="text-align: left;">按下「Ctrl + J」後，下方的預覽會即時顯示你所需的結果，然後點擊「下一步」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPsNgaa0XlfAvSnumDcX_EEe83jqB5AO3trnudHXvIQQSb270LTVsIQ-yHnOBd13ldtOgS62B60XIG0YXzkGGaF6ZEozt2f7wOVP1WPsjeLBPToaJOwkvMystyEhyuOhqiqqIEg8TDX_4k0caM9AJj6a2ILXBOyphQ-q7oi5VEd3ikIBfAos85PD220fdb/s878/Sseparate006.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="656" data-original-width="878" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPsNgaa0XlfAvSnumDcX_EEe83jqB5AO3trnudHXvIQQSb270LTVsIQ-yHnOBd13ldtOgS62B60XIG0YXzkGGaF6ZEozt2f7wOVP1WPsjeLBPToaJOwkvMystyEhyuOhqiqqIEg8TDX_4k0caM9AJj6a2ILXBOyphQ-q7oi5VEd3ikIBfAos85PD220fdb/w640-h478/Sseparate006.png" width="640" /></a></div><br /><div style="text-align: left;">在目標儲存格上點擊你想要貼上的其他儲存格的空白位置，例如 C2，然後按「完成」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIE8SZKrSd-JItGlwDCAT7EtD8zlloxQLduW6LAT-MUyG5W4WpHoRFHBde0LxPcW0IXgKNNszcJiVRCgJEEYAz929wvknZtMFIrmHThNMZUm9ktWgeU-_8uffk8yAT0FIcAR20YxOxKrk6EbgqmccBqXvlr5g9ffzOyxachEd1H-szJ7l8vXflS0rrxE9r/s615/Sseparate007.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="373" data-original-width="615" height="388" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIE8SZKrSd-JItGlwDCAT7EtD8zlloxQLduW6LAT-MUyG5W4WpHoRFHBde0LxPcW0IXgKNNszcJiVRCgJEEYAz929wvknZtMFIrmHThNMZUm9ktWgeU-_8uffk8yAT0FIcAR20YxOxKrk6EbgqmccBqXvlr5g9ffzOyxachEd1H-szJ7l8vXflS0rrxE9r/w640-h388/Sseparate007.png" width="640" /></a></div><br /><div style="text-align: left;">資料會立即被分拆到指定的空白位置上。</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;">                                     Fin                                   </u></div><div style="text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><br /></u></div><div style="text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><br /></u></div><div style="text-align: center;"><b style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;">[資料數值批量增加]</span></b></div><div style="text-align: center;"><b style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;"><br /></span></b></div><div style="text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqDyDzd9u98tLzEwXzmJfEgDLhNFV6bQZRUysWpvvvKhijMTp6GSOk2MN1zwkoEQsKUqvxGrJvsf2IPyIlAx23nhNR_5fckq93deyN8hrXpD4o7uW6tMhfz3e1ihyFadzw9iUFAg05PQdr-izSQ0829gBohcy8p_xqb14-_lWjWhFdM6B8HWYPljXZnH2p/s470/a001.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="326" data-original-width="470" height="278" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqDyDzd9u98tLzEwXzmJfEgDLhNFV6bQZRUysWpvvvKhijMTp6GSOk2MN1zwkoEQsKUqvxGrJvsf2IPyIlAx23nhNR_5fckq93deyN8hrXpD4o7uW6tMhfz3e1ihyFadzw9iUFAg05PQdr-izSQ0829gBohcy8p_xqb14-_lWjWhFdM6B8HWYPljXZnH2p/w400-h278/a001.png" width="400" /></a></div><br /></div><div style="text-align: left;">B欄中有相應的中文測驗分數。如果你想要批量將B欄的每個數值加上相同的數值，例如將E3儲存格中的 5 的數值加到每個分數上。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvYoeWNL4tRsfMYYfIs6jSU29cLLydH6S2rGhcWbjwFqIObbvo63kYqSMzbq30p5n_nVzJMklGj3Zd_LoP9UIdRWQZ7OQXe6Exx45qxmt4IQFPAJiAZhP76z51dN8cTg907-5DZ9vGjSPP2Dtw5FVWJY0DHHm_AnUaDeRwt0oQD1sn7RKevd2JJZrkdUtS/s482/a002.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="325" data-original-width="482" height="270" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvYoeWNL4tRsfMYYfIs6jSU29cLLydH6S2rGhcWbjwFqIObbvo63kYqSMzbq30p5n_nVzJMklGj3Zd_LoP9UIdRWQZ7OQXe6Exx45qxmt4IQFPAJiAZhP76z51dN8cTg907-5DZ9vGjSPP2Dtw5FVWJY0DHHm_AnUaDeRwt0oQD1sn7RKevd2JJZrkdUtS/w400-h270/a002.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">首先，選擇 E5 的數值並按複製 / (Ctrl + C)。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg04RS7VTR49PRbv4JrU8Igp0zOco-1LU_dDHkFo4JX0z704tjslClNy34FHkqASuODIeqAUKztyWuIM03Dxxh1uSHptOB43y5JgU47QfpLjnMor5Q-NYd5iOaC9aljJSB1iGlo4C9mw9HqobrjNb0r8L73VZAd0UaRaevkJkvtBeGtxY7q7tSYOMVvsbNk/s487/a003.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="352" data-original-width="487" height="289" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg04RS7VTR49PRbv4JrU8Igp0zOco-1LU_dDHkFo4JX0z704tjslClNy34FHkqASuODIeqAUKztyWuIM03Dxxh1uSHptOB43y5JgU47QfpLjnMor5Q-NYd5iOaC9aljJSB1iGlo4C9mw9HqobrjNb0r8L73VZAd0UaRaevkJkvtBeGtxY7q7tSYOMVvsbNk/w400-h289/a003.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">然後選擇需要批量更改數值的儲存格範圍。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTpENM5q0fe0pk0s3FoHFOzf_9iykULJUGmbeh41Fu1hVmZ-IlNsX6lpHCStLXDUuIj-BHh1248D8OYP73eC5LBoVWSYUDM503GUP_Sm55V_jdRbVhWR145paL_SYxukCg0H__slsbW2STRN3prK_GPGuOefxoFP2DkSmG9-3C_i2yozXP35eBTNkGGXj7/s482/a004.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="328" data-original-width="482" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTpENM5q0fe0pk0s3FoHFOzf_9iykULJUGmbeh41Fu1hVmZ-IlNsX6lpHCStLXDUuIj-BHh1248D8OYP73eC5LBoVWSYUDM503GUP_Sm55V_jdRbVhWR145paL_SYxukCg0H__slsbW2STRN3prK_GPGuOefxoFP2DkSmG9-3C_i2yozXP35eBTNkGGXj7/w400-h272/a004.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">按下滑鼠右鍵，然後選擇「選擇性貼上」。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-SvLEqcNI_iwBBvWOltjLjeOpZiUNxlbDyWWVm6hx2pUG_-HIUN-3TDCGiWol8DGbc4rfOesGTKgwLyUQ5UWVQVXDndgZQPjr1D_OmhEaOA0GlC0gRx0gK4ZzB_RHciW38Hm_dbf_lvtV_CA2zYG7lmo-W1HFSFhY9hB809stUpDIzQRUL-okXb1oQn9E/s834/a005.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="395" data-original-width="834" height="304" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-SvLEqcNI_iwBBvWOltjLjeOpZiUNxlbDyWWVm6hx2pUG_-HIUN-3TDCGiWol8DGbc4rfOesGTKgwLyUQ5UWVQVXDndgZQPjr1D_OmhEaOA0GlC0gRx0gK4ZzB_RHciW38Hm_dbf_lvtV_CA2zYG7lmo-W1HFSFhY9hB809stUpDIzQRUL-okXb1oQn9E/w640-h304/a005.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">在下方的運算選項中，選擇想要批量修改數值的運算方法，例如點擊「加」，然後再點擊「確定」。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi0BLsNLq2G5ZrncPIRo-IPye7E_I1VB-OzjzuOf5Q9n3ZAvW6u_6lLlt8hoHPcN4xH3xgWffWDOGzUw7pHOPCiuRMXMFeilW1QrV73ADEk8bRUoC7aqmB0ae-Vn7m1xTcw4JQ_jiPnMSHALIQb5ztXoIH37g0qSIIL_t8p2dgKAKZZ1VpfPHJcYw-W6NN/s481/a006.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="326" data-original-width="481" height="271" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi0BLsNLq2G5ZrncPIRo-IPye7E_I1VB-OzjzuOf5Q9n3ZAvW6u_6lLlt8hoHPcN4xH3xgWffWDOGzUw7pHOPCiuRMXMFeilW1QrV73ADEk8bRUoC7aqmB0ae-Vn7m1xTcw4JQ_jiPnMSHALIQb5ztXoIH37g0qSIIL_t8p2dgKAKZZ1VpfPHJcYw-W6NN/w400-h271/a006.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">範圍內的儲存格數值將全部加上5。</div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;">                                     Fin                                   </u></div><div class="separator" style="clear: both; text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><br /></u></div><div class="separator" style="clear: both; text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><br /></u></div><div class="separator" style="clear: both; text-align: center;"><b style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;">[刪除資料中空白儲存格]</span></b></div><div><span style="background-color: white;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTwHMGwE9Qh5ilNaKRJt7CvQ0A4Y40KoMxhiEjm9jw91BFfPsrLQ9CA3bUyWyRGrMrQmnDgWiqCqsKzLa0Oawb0EDdXyZRGllXJecS6JwswRFixiYYIcszTar3CEjSAy6px91N8n_mW2yjA88myeNuFMRt3Ncx85G9LcwQ5DphI1PeaqiW4XU1xpa1oMm9/s603/D001.png" style="background-color: transparent; margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="387" data-original-width="603" height="410" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTwHMGwE9Qh5ilNaKRJt7CvQ0A4Y40KoMxhiEjm9jw91BFfPsrLQ9CA3bUyWyRGrMrQmnDgWiqCqsKzLa0Oawb0EDdXyZRGllXJecS6JwswRFixiYYIcszTar3CEjSAy6px91N8n_mW2yjA88myeNuFMRt3Ncx85G9LcwQ5DphI1PeaqiW4XU1xpa1oMm9/w640-h410/D001.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">以上兩組數據中，各自都包含相應的空白儲存格。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_3j3fZ03DbzXUBcCQYCxGzrDjjSLrO0pv2cTdMdAj9Y0rUPG6gXUGC_QvCiswlM9TzayYUxlrXpVod0cZW1c2tPKvaingJB7qXXWfoN1hzxoBVJ0Ra5lW1xPKZ_NIalUNhQAOp0QV-wCRXuNeg0gp0MpBpcFksHGfIAZThCyhVUAtoNZnisLXz5tLLs9P/s608/D002.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="387" data-original-width="608" height="408" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_3j3fZ03DbzXUBcCQYCxGzrDjjSLrO0pv2cTdMdAj9Y0rUPG6gXUGC_QvCiswlM9TzayYUxlrXpVod0cZW1c2tPKvaingJB7qXXWfoN1hzxoBVJ0Ra5lW1xPKZ_NIalUNhQAOp0QV-wCRXuNeg0gp0MpBpcFksHGfIAZThCyhVUAtoNZnisLXz5tLLs9P/w640-h408/D002.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">按住「Ctrl」鍵，然後選擇兩組數據的儲存格範圍。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFYD1vFqRiCjG037KYP-QV4Gxbv0bMZBxOwvzEJeyPVWI2hf8wU0042hS8idBON55VVoeQRQxBOh3Y0EzegoIJA1sNBOY5bXgYnArK6x1X8pFPJXWwIh3di3JfiS5UejutAA5F9CEmHEC3nSqP_8F68rYEpSPhcC07VUcgmYNJGrmbBhiCnomTkPOojxtt/s930/D003.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="395" data-original-width="930" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFYD1vFqRiCjG037KYP-QV4Gxbv0bMZBxOwvzEJeyPVWI2hf8wU0042hS8idBON55VVoeQRQxBOh3Y0EzegoIJA1sNBOY5bXgYnArK6x1X8pFPJXWwIh3di3JfiS5UejutAA5F9CEmHEC3nSqP_8F68rYEpSPhcC07VUcgmYNJGrmbBhiCnomTkPOojxtt/w640-h272/D003.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">按「Ctrl + G」會進入參照位址的選單，然後再點擊「特殊」。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYn2Fqu6ORIiS51z3ug0PC9Q4mi0ClrnloPAhUMQTVXjH-te7Uqlxqno3UyQ5HTN7VG9X8-JqZPDrYsxbSUH9EKluIfLlwrmVQdL1C74ysexrLsIah43_xn7WcFAGZP2iD7-GB65MaIIi7M-dZ2vuvPYk9593CJgCRj48pB7WDGb-SzrMYVd9ppH3hthiV/s899/D004.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="443" data-original-width="899" height="316" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYn2Fqu6ORIiS51z3ug0PC9Q4mi0ClrnloPAhUMQTVXjH-te7Uqlxqno3UyQ5HTN7VG9X8-JqZPDrYsxbSUH9EKluIfLlwrmVQdL1C74ysexrLsIah43_xn7WcFAGZP2iD7-GB65MaIIi7M-dZ2vuvPYk9593CJgCRj48pB7WDGb-SzrMYVd9ppH3hthiV/w640-h316/D004.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">特殊目標點選「空格」，再點選「確定」。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdUeg1ZDnRkEJQ7NVnFYwfugIRFmIZ8vlMMUMgptvemQ0JTRdp6jhvLlkXloM0n7zgZcvBPnd3diOU39NX51_CunjYQ07b_9g_hciavBUsMRvNtYZV83-0AFUlLAsd3EQTga7Nhgerw9hz0RCKUvPqDn8Mf9X7bNNJTs_3nxVOaf0OhbRY4FfUxKX0U1DC/s611/D005.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="391" data-original-width="611" height="410" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdUeg1ZDnRkEJQ7NVnFYwfugIRFmIZ8vlMMUMgptvemQ0JTRdp6jhvLlkXloM0n7zgZcvBPnd3diOU39NX51_CunjYQ07b_9g_hciavBUsMRvNtYZV83-0AFUlLAsd3EQTga7Nhgerw9hz0RCKUvPqDn8Mf9X7bNNJTs_3nxVOaf0OhbRY4FfUxKX0U1DC/w640-h410/D005.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">相應數據範圍中的空白儲存格將全部被選擇。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibgUpOAWmZzvhbtb1LCpzPyy8htQj0bhXzqlBu9Fkj40ZKOiG0S82-BdrZUOKi06LTSFG_0gOBzzGmO_z2gLB5TGyM3pU0q4UY6mHYlhMbJZ5xl9HCT3J6o0vv7Boc1sBY4SEdfGFawsrxdFTN3f7bKHs_2CWU0zERIPeIdkaA-QbKttGwUvlBTyP3qyta/s838/D006.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="545" data-original-width="838" height="416" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibgUpOAWmZzvhbtb1LCpzPyy8htQj0bhXzqlBu9Fkj40ZKOiG0S82-BdrZUOKi06LTSFG_0gOBzzGmO_z2gLB5TGyM3pU0q4UY6mHYlhMbJZ5xl9HCT3J6o0vv7Boc1sBY4SEdfGFawsrxdFTN3f7bKHs_2CWU0zERIPeIdkaA-QbKttGwUvlBTyP3qyta/w640-h416/D006.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">點選上方的「常用」，然後點選「刪除」即可。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnh6E6cskVPhNPOC1cU8yuT94vO3qHFYHQiU5cJ6PO5lFZTKm8LlQgiGiAAHBYyjm0isMpPTFiTgFKnq_37pI-gv53vtfk27UEx1uOyw5tVWLMDap9TviaN5XMgA-mScbZ92DevrsfpORJF_XkI7AQ9P_ywcvwNp5fLXdB8WAJAP_gmISqpmq9H_M_7yQp/s605/D007.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="386" data-original-width="605" height="408" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnh6E6cskVPhNPOC1cU8yuT94vO3qHFYHQiU5cJ6PO5lFZTKm8LlQgiGiAAHBYyjm0isMpPTFiTgFKnq_37pI-gv53vtfk27UEx1uOyw5tVWLMDap9TviaN5XMgA-mScbZ92DevrsfpORJF_XkI7AQ9P_ywcvwNp5fLXdB8WAJAP_gmISqpmq9H_M_7yQp/w640-h408/D007.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">刪除後，空白的儲存格預設會被下一行的資料填補並移上來。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div></span><span face="Verdana, Geneva, sans-serif" style="background-color: white; color: #333333; font-size: 14px;"><div style="text-align: center;">(待續....)</div></span></div><p></p>

Excel 實用小技巧 (二)

[合併資料的分拆] A欄中的每個儲存格包含了一些合併的資料，可以將這些合併的資料分割出來，並填入例如C欄的每一個空白儲存格中。首先，選擇要分析的資料位置，然後按「資料」>「資料分析」。原始資料類型選擇「分隔符號」，點擊「下一步」。分隔符號點選其他，然後在空白位置上...

Payme QR Code		Alipay QR Code
	或
或轉數快 ID: 169288891 CHAN N* H*

數字配對挑戰 (v1.0)

Excel 實用小技巧 (二)

網誌所有文章

聯絡人表單

搜尋網誌