{"id":9527,"date":"2020-02-28T17:17:42","date_gmt":"2020-02-28T08:17:42","guid":{"rendered":"https:\/\/itport.cloud\/?p=9527"},"modified":"2020-02-28T17:17:43","modified_gmt":"2020-02-28T08:17:43","slug":"post-9527","status":"publish","type":"post","link":"https:\/\/itport.cloud\/?p=9527","title":{"rendered":"(\u7b2c2\u56de)Excel\u3092\u6d3b\u7528\u3057\u305f\u696d\u52d9\u52b9\u7387\u5316\u3000\u4fbf\u5229\u6a5f\u80fd\u7d39\u4ecb\u2461"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"e79baee6aca1-1\">\u76ee\u6b21<\/h2>\n\n\n\n<p><a href=\"#Excel-0\">\u306f\u3058\u3081\u306b<\/a><br><a href=\"#Excel-1\">\u533a\u5207\u308a\u4f4d\u7f6e\u306b\u3088\u308b\u5206\u5272<\/a><br><a href=\"#Excel-2\">\u30d5\u30a3\u30eb<\/a><br><a href=\"#Excel-3\">\u30de\u30af\u30ed\u306e\u8a18\u9332\u6a5f\u80fd<\/a><br><a href=\"#Excel-4\">\u30a2\u30c9\u30a4\u30f3\u306e\u767b\u9332<\/a><br><a href=\"#Excel-5\">\u7d42\u308f\u308a\u306b<\/a><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Excel-0\">\u306f\u3058\u3081\u306b<\/h2>\n\n\n\n<p>\u524d\u56de\u306fExcel\u306e\u4fbf\u5229\u6a5f\u80fd\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<br>\u4eca\u56de\u306f\u524d\u56de\u7d39\u4ecb\u3067\u304d\u306a\u304b\u3063\u305f\u6a5f\u80fd\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<br><\/p>\n\n\n\n<figure class=\"wp-block-embed-wordpress wp-block-embed is-type-rich is-provider-it-port\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"EsgMWZ6yUx\"><a href=\"https:\/\/itport.cloud\/?p=7456\">(\u7b2c1\u56de)Excel\u3092\u6d3b\u7528\u3057\u305f\u696d\u52d9\u52b9\u7387\u5316\u3000\u4fbf\u5229\u6a5f\u80fd\u7d39\u4ecb\u2460<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;(\u7b2c1\u56de)Excel\u3092\u6d3b\u7528\u3057\u305f\u696d\u52d9\u52b9\u7387\u5316\u3000\u4fbf\u5229\u6a5f\u80fd\u7d39\u4ecb\u2460&#8221; &#8212; IT PORT\" src=\"https:\/\/itport.cloud\/?p=7456&#038;embed=true#?secret=EsgMWZ6yUx\" data-secret=\"EsgMWZ6yUx\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Excel-1\">\u533a\u5207\u308a\u4f4d\u7f6e\u306b\u3088\u308b\u5206\u5272<\/h2>\n\n\n\n<p>\u7279\u5b9a\u306e\u6587\u5b57\u3092\u533a\u5207\u308a\u6587\u5b57\u3068\u3057\u3066\u30bb\u30eb\u5185\u306e\u5024\u3092\u5206\u5272\u3057\u307e\u3059\u3002<br><br> CSV\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u306e\u8cbc\u308a\u4ed8\u3051\u6642\u306a\u3069\u306b\u4f7f\u7528\u3059\u308b\u3068\u4fbf\u5229\u3067\u3059\u3002 <br>(CSV\u30d5\u30a1\u30a4\u30eb\u306f\u30c7\u30fc\u30bf\u3092\u30ab\u30f3\u30de\u3067\u533a\u5207\u3089\u308c\u305f\u30d5\u30a1\u30a4\u30eb\u3067\u3042\u308a\u3001<br> Excel\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u95a2\u9023\u4ed8\u3051\u3055\u308c\u3001Excel\u306b\u3066\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u4e8b\u304c\u3067\u304d\u307e\u3059\u3002)<br><br>\u4e0b\u56f3\u306fCSV\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u3092\u30b3\u30d4\u30fc\u3057\u3066Excel\u30b7\u30fc\u30c8\u4e0a\u3078\u8cbc\u308a\u4ed8\u3051\u305f\u3082\u306e\u3067\u3059\u3002<br> \u30ea\u30dc\u30f3\u306e&#8221;\u30c7\u30fc\u30bf&#8221;\u2192&#8221;\u533a\u5207\u308a\u4f4d\u7f6e&#8221;\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"983\" height=\"753\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_1.jpg\" alt=\"\" class=\"wp-image-10032\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_1.jpg 983w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_1-300x230.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_1-768x588.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_1-418x320.jpg 418w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_1-835x640.jpg 835w\" sizes=\"auto, (max-width: 983px) 100vw, 983px\" \/><\/a><\/figure>\n\n\n\n<p>\u4e0b\u56f3\u306e\u3088\u3046\u306a\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<br>\u4f8b\u3067\u306f\u8868\u793a\u3055\u308c\u305f\u30c0\u30a4\u30a2\u30ed\u30b0\u306b\u3066\u533a\u5207\u308a\u6587\u5b57\u306b\u3088\u3063\u3066\u533a\u5207\u3089\u308c\u305f\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3001<br>&#8220;\u6b21\u3078&#8221;\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"711\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2-1024x711.jpg\" alt=\"\" class=\"wp-image-10033\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2-1024x711.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2-300x208.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2-768x534.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2-140x96.jpg 140w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2-450x313.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2-900x625.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_2.jpg 1068w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u4f8b\u3067\u306f\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u3057\u305f\u3044\u306e\u3067\u3001\u30c1\u30a7\u30c3\u30af\u3092\u30ab\u30f3\u30de\u306e\u307f\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"711\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3-1024x711.jpg\" alt=\"\" class=\"wp-image-10034\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3-1024x711.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3-300x208.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3-768x534.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3-140x96.jpg 140w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3-450x313.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3-900x625.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_3.jpg 1068w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3\u304b\u3089\u66f8\u5f0f\u3092\u9078\u629e\u3057\u3001\u533a\u5207\u3063\u305f\u5f8c\u66f8\u5f0f\u3092\u9069\u7528\u3057\u305f\u3044\u5217\u3092&#8221;\u30c7\u30fc\u30bf\u306e\u30d7\u30ec\u30d3\u30e5\u30fc&#8221;\u304b\u3089\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"713\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4-1024x713.jpg\" alt=\"\" class=\"wp-image-10035\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4-1024x713.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4-300x209.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4-768x535.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4-140x96.jpg 140w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4-450x313.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4-900x626.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_4.jpg 1066w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"712\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5-1024x712.jpg\" alt=\"\" class=\"wp-image-10036\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5-1024x712.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5-300x209.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5-768x534.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5-140x96.jpg 140w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5-450x313.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5-900x626.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/1_5.jpg 1068w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p> <br>\u4e0a\u56f3\u3067\u8a2d\u5b9a\u3057\u305f\u901a\u308a\u3001\u5206\u5272\u5f8c\u306e\u30bb\u30eb\u306f\u6587\u5b57\u5217\u5f62\u5f0f\u306b\u306a\u308a\u307e\u3059\u3002<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Excel-2\">\u30d5\u30a3\u30eb<\/h2>\n\n\n\n<p>\u30d5\u30a3\u30eb\u3068\u306f\u9023\u7d9a\u3057\u305f\u30c7\u30fc\u30bf\u3092\u751f\u6210\u3059\u308b\u6a5f\u80fd\u3067\u3059\u3002<br>Ctrl + D\u3067\u9078\u629e\u7bc4\u56f2\u306e\u4e00\u756a\u4e0a\u306e\u30bb\u30eb\u3092\u4e0b\u65b9\u5411\u3078\u3001<br>Ctrl + R\u3067\u9078\u629e\u7bc4\u56f2\u306e\u4e00\u756a\u5de6\u306e\u30bb\u30eb\u3092\u53f3\u65b9\u5411\u3078\u540c\u3058\u5024\u3092\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<br>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u64cd\u4f5c\u3059\u308b\u969b\u306b\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3092\u899a\u3048\u3066\u304a\u304f\u3068\u4fbf\u5229\u3067\u3059\u3002<br><br>\u4e0b\u56f3\u306f\u305d\u308c\u305e\u308cCtrl + D\u3067C4\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u3068<br>C4:C8\u306e\u7bc4\u56f2\u3092D\u5217\u306bCtrl + R\u3067\u30b3\u30d4\u30fc\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002<br>\u30bb\u30eb\u306e\u95a2\u6570\u5f0f\uff65\u66f8\u5f0f\u3082\u30b3\u30d4\u30fc\u3055\u308c\u307e\u3059\u3002<br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_1-1024x669.jpg\" alt=\"\" class=\"wp-image-10037\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_1-1024x669.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_1-300x196.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_1-768x502.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_1-450x294.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_1-900x588.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_1.jpg 1316w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_2-1024x669.jpg\" alt=\"\" class=\"wp-image-10038\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_2-1024x669.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_2-300x196.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_2-768x502.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_2-450x294.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_2-900x588.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_2.jpg 1316w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u30de\u30a6\u30b9\u64cd\u4f5c\u3092\u4f7f\u7528\u3059\u308b\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067\u306f\u9023\u756a\u30c7\u30fc\u30bf\u3092\u751f\u6210\u3067\u304d\u307e\u3059\u3002<br>\u9023\u7d9a\u30c7\u30fc\u30bf\u306e\u4f5c\u6210\u304b\u3089\u9023\u756a\u306e\u8a73\u7d30\u306a\u8a2d\u5b9a\u304c\u884c\u3048\u307e\u3059\u3002<br>\u5897\u52a0\u5e45\u306e\u8a2d\u5b9a\u306e\u4ed6\u3001\u52a0\u7b97\u3067\u306f\u306a\u304f\u4e57\u7b97\u306a\u3069\u3082\u884c\u3048\u307e\u3059\u3002<br><br>\u307e\u305f\u3001Excel2013\u4ee5\u964d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u306fCtrl + E\u3067\u5b9f\u884c\u3067\u304d\u308b\u6a5f\u80fd\u306b\u30d5\u30e9\u30c3\u30b7\u30e5\u30d5\u30a3\u30eb\u304c\u3042\u308a\u307e\u3059\u3002<br>\u6cd5\u5247\u6027\u3092\u81ea\u52d5\u3067\u5224\u65ad\u3057\u4e0b\u65b9\u5411\u3078\u540c\u3058\u51e6\u7406\u3092\u5b9f\u884c\u3057\u307e\u3059(\u6cd5\u5247\u6027\u304c\u4e0d\u660e\u306a\u5834\u5408\u306f\u4e0b\u65b9\u5411\u3078\u306e\u30b3\u30d4\u30fc\u306b\u306a\u308a\u307e\u3059)\u3002<br>\u4e0b\u56f3\u306fD4\u306e\u30bb\u30eb(B4\u3068C4\u306e\u5024\u306e\u7d50\u5408)\u3068\u540c\u3058\u3088\u3046\u306b\u306a\u308b\u51e6\u7406\u3092\u5b9f\u884c\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_3.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_3-1024x669.jpg\" alt=\"\" class=\"wp-image-10039\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_3-1024x669.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_3-300x196.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_3-768x502.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_3-450x294.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_3-900x588.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/2_3.jpg 1316w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Excel-3\">\u30de\u30af\u30ed\u306e\u8a18\u9332\u6a5f\u80fd<\/h2>\n\n\n\n<p>\u30ea\u30dc\u30f3\u306e\u8868\u793a\u2192\u30de\u30af\u30ed\u2192\u30de\u30af\u30ed\u306e\u8a18\u9332\u304b\u3089Excel\u306e\u64cd\u4f5c\u3092\u8a18\u9332\u3057\u3066<br>VBA\u30de\u30af\u30ed\u3092\u751f\u6210\u3059\u308b\u4e8b\u304c\u3067\u304d\u307e\u3059\u3002<br>\u8a18\u9332\u304c\u7d42\u308f\u308b\u3068\u30b3\u30fc\u30c9\u306e\u78ba\u8a8d\u304c\u3067\u304d\u307e\u3059\u3002<br><br>\u751f\u6210\u3055\u308c\u305f\u30b3\u30fc\u30c9\u306f\u305d\u306e\u307e\u307e\u3067\u306f\u7e70\u308a\u8fd4\u3057\u306e\u4f7f\u7528\u306b\u306f\u5411\u304b\u306a\u3044\u305f\u3081\u3001<br>\u672c\u683c\u7684\u306a VBA\u30de\u30af\u30ed\u306e\u4f5c\u6210\u306b\u306f\u4f7f\u7528\u3057\u307e\u305b\u3093\u304c\u3001<br>\u30de\u30af\u30ed\u3067\u306e\u30b3\u30fc\u30c9\u306e\u5b9f\u88c5\u65b9\u6cd5\u3092\u8abf\u3079\u305f\u308a\u3001<br>\u76ee\u7684\u306e\u64cd\u4f5c\u3092\u5b9f\u884c\u3059\u308b\u51e6\u7406\u304c\u5b9f\u88c5\u3055\u308c\u3066\u3044\u308b\u304b\u306e\u78ba\u8a8d\u306b\u4fbf\u5229\u3067\u3059\u3002<br>\u30ea\u30dc\u30f3\u306e\u8868\u793a\u2192\u30de\u30af\u30ed\u306e\u8a18\u9332\u3092\u5b9f\u884c\u3059\u308b\u4e8b\u3067\u30de\u30af\u30ed\u306e\u4fdd\u5b58\u5148\u3092\u8a2d\u5b9a\u3059\u308b\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u3001<br>\u30c0\u30a4\u30a2\u30ed\u30b0\u306e&#8221;OK&#8221;\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u64cd\u4f5c\u306e\u8a18\u9332\u304c\u958b\u59cb\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"226\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_1-1024x226.jpg\" alt=\"\" class=\"wp-image-10040\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_1-1024x226.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_1-300x66.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_1-768x169.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_1-450x99.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_1-900x198.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_1.jpg 1316w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u30b5\u30f3\u30d7\u30eb\u3068\u3057\u30665\u3064\u306e\u30bb\u30eb\u306b\u305d\u308c\u305e\u308c&#8221;b&#8221;\uff65&#8221;c&#8221;\uff65&#8221;d&#8221;\uff65&#8221;e&#8221;\uff65&#8221;f&#8221;\u3068\u5165\u529b\u3057\u307e\u3059\u3002<br>&#8220;\u8a18\u9332\u7d42\u4e86&#8221;\u3067\u64cd\u4f5c\u306e\u8a18\u9332\u3092\u7d42\u4e86\u3057\u307e\u3059\u3002 <\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"659\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_2-1024x659.jpg\" alt=\"\" class=\"wp-image-10041\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_2-1024x659.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_2-300x193.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_2-768x494.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_2-450x290.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_2-900x579.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_2.jpg 1318w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Alt + F11\u3067VBA\u306e\u30a8\u30c7\u30a3\u30bf\u3092\u958b\u304f\u3068\u30b3\u30fc\u30c9\u304c\u8a18\u9332\u3055\u308c\u3066\u3044\u308b\u306e\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002 <\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_4.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"487\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_4-1024x487.jpg\" alt=\"\" class=\"wp-image-10043\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_4-1024x487.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_4-300x143.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_4-768x365.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_4-450x214.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_4-900x428.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/3_4.jpg 1808w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Excel-4\">\u30a2\u30c9\u30a4\u30f3\u306e\u767b\u9332<\/h2>\n\n\n\n<p>VBA\u3067\u30de\u30af\u30ed\u3092\u4f5c\u6210\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u3088\u304f\u4f7f\u3046\u30de\u30af\u30ed\u306f\u30a2\u30c9\u30a4\u30f3\u3068\u3057\u3066\u4f5c\u6210\u3057\u3001\u767b\u9332\u3057\u3066\u304a\u304f\u3068\u4fbf\u5229\u3067\u3059\u3002<br>\u767b\u9332\u3057\u305f\u30a2\u30c9\u30a4\u30f3\u306f\u624b\u8efd\u306b\u547c\u3073\u51fa\u3057\u3066\u5b9f\u884c\u3059\u308b\u4e8b\u304c\u3067\u304d\u307e\u3059\u3002<br><br>\u4e0b\u56f3\u306f\u30ea\u30dc\u30f3\u306b\u30de\u30af\u30ed\u3092\u767b\u9332\u3057\u3066\u5b9f\u884c\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002<br>\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u30a2\u30c9\u30a4\u30f3\u2192\u8a2d\u5b9a\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u30c0\u30a4\u30a2\u30ed\u30b0\u5185\u306e&#8221;\u53c2\u7167&#8221;\u3092\u9078\u629e\u3057\u3066\u30de\u30af\u30ed\u3092\u4f5c\u6210\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u53c2\u7167\u3057\u307e\u3059\u3002<br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"670\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_1-1024x670.jpg\" alt=\"\" class=\"wp-image-10044\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_1-1024x670.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_1-300x196.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_1-768x503.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_1-450x295.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_1-900x589.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_1.jpg 1314w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u53c2\u7167\u304b\u3089\u30de\u30af\u30ed\u3092\u4f5c\u6210\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_2-1024x669.jpg\" alt=\"\" class=\"wp-image-10045\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_2-1024x669.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_2-300x196.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_2-768x502.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_2-450x294.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_2-900x588.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_2.jpg 1316w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u4e0b\u56f3\u306e\u3088\u3046\u306b\u30ea\u30dc\u30f3\u306e&#8221;\u30e6\u30fc\u30b6\u30fc\u8a2d\u5b9a&#8221;\u304b\u3089\u30ea\u30dc\u30f3\u3092\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3057\u3066\u767b\u9332\u3057\u3066\u304a\u304f\u3068\u4f7f\u3044\u3084\u3059\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<br>(\u901a\u5e38\u306f\u30a2\u30c9\u30a4\u30f3\u3092\u81ea\u52d5\u767b\u9332\u3059\u308b\u30de\u30af\u30ed\u3084VBScript\u3092<br>\u4e00\u7dd2\u306b\u4f5c\u6210\u3055\u308c\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u3042\u307e\u308a\u4f7f\u7528\u3059\u308b\u6a5f\u4f1a\u306f\u7121\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c)<br>\u4e0b\u56f3\u306f\u30ea\u30dc\u30f3\u306b\u767b\u9332\u3057\u305f\u30a2\u30c9\u30a4\u30f3\u3092\u8ffd\u52a0\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_3.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"670\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_3-1024x670.jpg\" alt=\"\" class=\"wp-image-10046\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_3-1024x670.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_3-300x196.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_3-768x502.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_3-450x294.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_3-900x589.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_3.jpg 1315w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u306b&#8221;test&#8221;\u3068\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8868\u793a\u3059\u308b\u30de\u30af\u30ed\u3092\u5b9f\u884c\u3057\u3066\u3044\u307e\u3059\u3002 <\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_4.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_4-1024x669.jpg\" alt=\"\" class=\"wp-image-10047\" srcset=\"https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_4-1024x669.jpg 1024w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_4-300x196.jpg 300w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_4-768x502.jpg 768w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_4-450x294.jpg 450w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_4-900x588.jpg 900w, https:\/\/itport.cloud\/wp-content\/uploads\/2020\/02\/4_4.jpg 1315w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Excel-5\">\u7d42\u308f\u308a\u306b<\/h2>\n\n\n\n<p>\u4eca\u56de\u3082\u4fbf\u5229\u6a5f\u80fd\u3092\u7d39\u4ecb\u3055\u305b\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u304c\u3001\u7d39\u4ecb\u3057\u305f\u306e\u306f\u307e\u3060\u307e\u3060Excel\u306e\u6a5f\u80fd\u306e\u4e00\u90e8\u3067\u3059\u3002<br>Excel\u3067\u306e\u4f5c\u696d\u306e\u304a\u5f79\u306b\u7acb\u3066\u3070\u3068\u601d\u3044\u307e\u3059\u3002<br>\u6b21\u56de\u306f\u95a2\u6570\u3084\u30de\u30af\u30ed\u4f5c\u6210\u306b\u3064\u3044\u3066\u7d39\u4ecb\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u76ee\u6b21 \u306f\u3058\u3081\u306b\u533a\u5207\u308a\u4f4d\u7f6e\u306b\u3088\u308b\u5206\u5272\u30d5\u30a3\u30eb\u30de\u30af\u30ed\u306e\u8a18\u9332\u6a5f\u80fd\u30a2\u30c9\u30a4\u30f3\u306e\u767b\u9332\u7d42\u308f\u308a\u306b \u306f\u3058\u3081\u306b \u524d\u56de\u306fExcel\u306e\u4fbf\u5229\u6a5f\u80fd\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u524d\u56de\u7d39\u4ecb\u3067\u304d\u306a\u304b\u3063\u305f\u6a5f\u80fd\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002 https:\/\/itport.cloud\/?p=7456 \u533a\u5207\u308a\u4f4d\u7f6e\u306b\u3088\u308b\u5206\u5272 \u7279\u5b9a\u306e\u6587\u5b57\u3092\u533a\u5207\u308a\u6587\u5b57\u3068\u3057\u3066\u30bb\u30eb\u5185\u306e\u5024\u3092\u5206\u5272\u3057\u307e\u3059\u3002 CSV\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u306e\u8cbc\u308a\u4ed8\u3051\u6642\u306a\u3069\u306b\u4f7f\u7528\u3059\u308b\u3068\u4fbf\u5229\u3067\u3059\u3002 (CSV\u30d5\u30a1\u30a4\u30eb\u306f\u30c7\u30fc\u30bf\u3092\u30ab\u30f3\u30de\u3067\u533a\u5207\u3089\u308c\u305f\u30d5\u30a1\u30a4\u30eb\u3067\u3042\u308a\u3001 Excel\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u95a2\u9023\u4ed8\u3051\u3055\u308c\u3001Excel\u306b\u3066\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u4e8b\u304c\u3067\u304d\u307e\u3059\u3002)\u4e0b\u56f3\u306fCSV\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u3092\u30b3\u30d4\u30fc\u3057\u3066Excel\u30b7\u30fc\u30c8\u4e0a\u3078\u8cbc\u308a\u4ed8\u3051\u305f\u3082\u306e\u3067\u3059\u3002 \u30ea\u30dc\u30f3\u306e&#8221;\u30c7&hellip;","protected":false},"author":4,"featured_media":10592,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58],"tags":[59],"class_list":{"0":"post-9527","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-season18"},"_links":{"self":[{"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/posts\/9527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9527"}],"version-history":[{"count":11,"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/posts\/9527\/revisions"}],"predecessor-version":[{"id":10807,"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/posts\/9527\/revisions\/10807"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/media\/10592"}],"wp:attachment":[{"href":"https:\/\/itport.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}