{"id":2965,"date":"2023-11-21T11:44:20","date_gmt":"2023-11-21T11:44:20","guid":{"rendered":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/"},"modified":"2023-12-07T04:48:33","modified_gmt":"2023-12-07T04:48:33","slug":"%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/","title":{"rendered":"Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?"},"content":{"rendered":"<div class=\"excel-\" id=\"excel-2968982400\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>\u5148\u9031\u3001\u65c5\u884c\u4e2d\u306b\u79c1\u306b\u77e5\u7684\u306a\u8cea\u554f\u3092\u3057\u3066\u304d\u305f\u4eba\u306b\u4f1a\u3044\u307e\u3057\u305f\u3002\u5f7c\u306f\u9759\u304b\u306b\u30e9\u30c3\u30d7\u30c8\u30c3\u30d7\u3067\u4f5c\u696d\u3057\u3066\u3044\u3066\u3001\u7a81\u7136\u79c1\u306b\u3053\u3046\u5c0b\u306d\u307e\u3057\u305f\u3002<\/p><p> <strong>\u300c\u306d\u3048\u3001Excel \u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u8a18\u53f7\u3092\u633f\u5165\u3059\u308b\u65b9\u6cd5\u3092\u77e5\u3063\u3066\u3044\u307e\u3059\u304b?<\/strong> \u300c<\/p><p>\u305d\u3057\u3066\u3001\u5f7c\u304c\u9867\u5ba2\u306e\u30ea\u30b9\u30c8\u3092\u6301\u3063\u3066\u304a\u308a\u3001\u4f1a\u3063\u305f\u5404\u9867\u5ba2\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u8ffd\u52a0\u3057\u305f\u3044\u3068\u8003\u3048\u3066\u3044\u305f\u3053\u3068\u306b\u6c17\u3065\u304d\u307e\u3057\u305f\u3002<\/p><p>\u305d\u3046\u3067\u3059\u306d\u3001\u79c1\u306f\u5f7c\u306b\u7c21\u5358\u306a\u65b9\u6cd5\u3092\u6559\u3048\u307e\u3057\u305f\u3001\u305d\u3057\u3066\u5f7c\u306f\u305d\u308c\u306b\u6e80\u8db3\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u3057\u304b\u3057\u3001\u3064\u3044\u306b\u4eca\u65e5\u306e\u671d\u3001\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u5165\u308c\u308b\u65b9\u6cd5\u306f\u8907\u6570\u3042\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3044\u3064\u304d\u307e\u3057\u305f\u3002<\/p><p>\u305d\u3057\u3066\u5e78\u904b\u306a\u3053\u3068\u306b\u3001\u305d\u306e\u305f\u3081\u306e\u65b9\u6cd5\u304c\u3044\u304f\u3064\u304b\u3042\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002\u305d\u3053\u3067\u3001\u4eca\u65e5\u3053\u306e\u8a18\u4e8b\u3067\u306f\u300110\u306e\u7570\u306a\u308b\u65b9\u6cd5\u3092\u4f7f\u7528\u3057\u3066Excel\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3068\u3001\u3053\u308c\u3089\u306e\u65b9\u6cd5\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3059\u3079\u3066\u306e\u72b6\u6cc1\u3092\u8aac\u660e\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p><p><span style=\"font-size: 1em;\">\u3053\u308c\u3089\u306e 10 \u306e\u65b9\u6cd5 \u3055\u3089\u306b\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u66f8\u5f0f\u8a2d\u5b9a\u3057\u3001\u7bc4\u56f2\u5185\u306e\u30bb\u30eb\u304b\u3089\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u3082\u8aac\u660e\u3057\u307e\u3057\u305f\u3002<\/span><\/p><h2 class=\"wp-block-heading\"><span style=\"color: #ea493f;\">\u7c21\u5358\u306a\u30e1\u30e2<\/span><\/h2><ul><li>Excel \u3067\u306f\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u306f Wingding \u30d5\u30a9\u30f3\u30c8\u6587\u5b57\u3067\u3059\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u30bb\u30eb\u306b\u633f\u5165\u3059\u308b\u3068\u304d\u306f\u5e38\u306b\u3001\u305d\u306e\u30bb\u30eb\u306b\u306f\u30a6\u30a3\u30f3\u30b0 \u30d5\u30a9\u30f3\u30c8 \u30b9\u30bf\u30a4\u30eb\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059 (\u4ed6\u306e\u5834\u6240\u304b\u3089\u30b3\u30d4\u30fc\u3057\u306a\u3044\u9650\u308a)\u3002<\/li><li>\u3053\u308c\u3089\u306e\u65b9\u6cd5\u306f\u3001Excel \u306e\u3059\u3079\u3066\u306e\u30d0\u30fc\u30b8\u30e7\u30f3 (2007\u30012010\u30012013\u30012016\u30012019\u3001\u304a\u3088\u3073 Office 365) \u3067\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/li><\/ul><h2 class=\"wp-block-heading\"> Excel \u3067\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408<\/h2><p>\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u307e\u305f\u306f\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306f\u3001\u300c\u306f\u3044\u300d\u3092\u793a\u3057\u305f\u308a\u3001\u300c\u5b8c\u4e86\u300d\u307e\u305f\u306f\u300c\u5b8c\u4e86\u300d\u3092\u793a\u3057\u305f\u308a\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u30de\u30fc\u30af\u3067\u3059\u3002<\/p><p>\u3057\u305f\u304c\u3063\u3066\u3001To Do \u30ea\u30b9\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3044\u3066\u3001\u4f55\u304b\u304c\u5b8c\u4e86\u3057\u305f\u3053\u3068\u3001\u5b8c\u4e86\u3057\u305f\u3053\u3068\u3001\u307e\u305f\u306f\u30c1\u30a7\u30c3\u30af\u304c\u5165\u3063\u305f\u3053\u3068\u3092\u30de\u30fc\u30af\u3057\u305f\u3044\u5834\u5408\u3001\u6700\u826f\u306e\u65b9\u6cd5\u306f\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> 1. \u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u8ffd\u52a0\u3059\u308b\u30ad\u30fc\u30dc\u30fc\u30c9 \u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8<\/h2><p>\u30ad\u30fc\u30dc\u30fc\u30c9 \u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3088\u308a\u901f\u3044\u3082\u306e\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u8a18\u53f7\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f\u3001\u30ad\u30fc\u30dc\u30fc\u30c9 \u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3060\u3051\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p><p>\u6ce8\u610f\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u3053\u3068\u306f\u305f\u3060 1 \u3064\u3060\u3051\u3067\u3059\u3002\u30b7\u30f3\u30dc\u30eb\u3092\u8ffd\u52a0\u3059\u308b\u30bb\u30eb\u306b\u306f\u3001\u30d5\u30a9\u30f3\u30c8 \u30b9\u30bf\u30a4\u30eb\u3068\u3057\u3066 wingding \u304c\u5fc5\u8981\u3067\u3059\u3002\u4ee5\u4e0b\u306f\u3001\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u7c21\u5358\u306a\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3067\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\" sizes=\"\" srcset=\"\" alt=\"Excel\u306b\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u5165\u308c\u308b\"><\/figure><\/div><ol><li> Windows \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u6b21\u306e\u624b\u9806\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002 \u8ffd\u52a0\u3059\u308b\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li> <strong>Alt + 0 2 5 2 \u3092\u4f7f\u7528\u3057\u307e\u3059<\/strong>(\u5fc5\u305a Alt \u30ad\u30fc\u3092\u62bc\u3057\u305f\u5f8c\u3001\u30c6\u30f3\u30ad\u30fc\u3067\u300c0252\u300d\u3068\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044)\u3002 <br><img decoding=\"async\" title=\"Excel \u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b Windows \u30ad\u30fc\u30dc\u30fc\u30c9\u306e\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/raccourci-clavier-windows-pour-inserer-une-coche-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"windows-keyboard-shortcut-to-insert-a-checkmark-in-excel\"><\/li><li> Mac \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u8ffd\u52a0\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/li><li> <strong>Option \u30ad\u30fc + 0 2 5 2<\/strong>\u3092\u4f7f\u7528\u3057\u307e\u3059 (\u5fc5\u305a\u30ad\u30fc\u3092\u62bc\u3057\u305f\u307e\u307e\u3001\u30c6\u30f3\u30ad\u30fc\u3067\u300c0252\u300d\u3068\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044)\u3002 <br><img decoding=\"async\" title=\"Excel \u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u305f\u3081\u306e mac \u30ad\u30fc\u30dc\u30fc\u30c9 \u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/raccourci-clavier-mac-pour-inserer-une-coche-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"mac-keyboard-shortcut-to-insert-a-checkmark-in-excel\"><\/li><\/ol><h2 class=\"wp-block-heading\"> 2. \u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7\u3092\u30b3\u30d4\u30fc\u3057\u3066\u30bb\u30eb\u306b\u8cbc\u308a\u4ed8\u3051\u307e\u3059<\/h2><p>\u666e\u6bb5\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u4f7f\u7528\u3057\u306a\u3044\u5834\u5408\u306f\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u3069\u3053\u304b\u304b\u3089\u30b3\u30d4\u30fc\u3057\u3066\u8cbc\u308a\u4ed8\u3051\u3066\u30bb\u30eb\u306b\u633f\u5165\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059<\/p><p>\u3053\u3053\u3067\u306f\u6570\u5f0f\u3001\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3001\u307e\u305f\u306f VBA \u3092\u4f7f\u7528\u3057\u3066\u3044\u306a\u3044\u305f\u3081\u3067\u3059 (\u3053\u3053\u304b\u3089\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u30b3\u30d4\u30fc\u3057\u3066\u8cbc\u308a\u4ed8\u3051\u307e\u3059 \u2713)\u3002<\/p><p>\u307e\u305f\u306f\u3001 <a href=\"https:\/\/www.google.com\/search?q=check+mark&amp;sca_esv=584275836&amp;sxsrf=AM9HkKkV41ajk1YDfsvPBSGYZsbdreKIfw%3A1700569357142\" target=\"_blank\" rel=\"nofollow external noopener noreferrer\" data-wpel-link=\"external\">Google \u3067\u691c\u7d22\u3057<\/a>\u3066\u30b3\u30d4\u30fc\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u30b3\u30d4\u30fc \u30a2\u30f3\u30c9 \u30da\u30fc\u30b9\u30c8\u65b9\u6cd5\u306e\u6700\u3082\u512a\u308c\u305f\u70b9\u306f\u3001\u30d5\u30a9\u30f3\u30c8 \u30b9\u30bf\u30a4\u30eb\u3092\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u306a\u3044\u3053\u3068\u3067\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> 3.<span style=\"color: #ea493f;\">\u30b7\u30f3\u30dc\u30eb\u30aa\u30d7\u30b7\u30e7\u30f3\u304b\u3089\u76f4\u63a5<\/span>\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3057\u307e\u3059\u3002<\/h2><p> Excel \u306b\u306f [\u8a18\u53f7] \u30aa\u30d7\u30b7\u30e7\u30f3\u304b\u3089\u633f\u5165\u3067\u304d\u308b\u8a18\u53f7\u304c\u591a\u6570\u3042\u308a\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3082\u305d\u306e 1 \u3064\u3067\u3059\u3002<\/p><p>\u30b7\u30f3\u30dc\u30eb\u304b\u3089\u30bb\u30eb\u306b\u30b7\u30f3\u30dc\u30eb\u3092\u633f\u5165\u3059\u308b\u306e\u306f\u7c21\u5358\u3067\u3059\u3002\u6b21\u306e\u624b\u9806\u306b\u5f93\u3046\u3060\u3051\u3067\u3059\u3002<\/p><ol><li>\u307e\u305a\u3001\u8ffd\u52a0\u3059\u308b<strong>\u30bb\u30eb\u3092\u9078\u629e\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a<\/strong>\u307e\u3059\u3002<\/li><li>\u305d\u306e\u5f8c\u3001 <strong>[\u633f\u5165] \u30bf\u30d6 \u279c \u8a18\u53f7 \u279c \u8a18\u53f7\u306e\u9806\u306b\u79fb\u52d5\u3057\u307e\u3059<\/strong>\u3002 <br><img decoding=\"async\" title=\"\u6700\u5c0f\u8a18\u53f7\u304b\u3089 Excel \u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-Excel-a-partir-du-symbole-min-1.png\" sizes=\"\" srcset=\"\" alt=\"insert checkmark in excel from symbol min\"><\/li><li><strong>\u30b7\u30f3\u30dc\u30eb\u30dc\u30bf\u30f3 \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b<\/strong>\u3068\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li><li>\u6b21\u306b\u3001\u3053\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u3001\u30d5\u30a9\u30f3\u30c8\u306e\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u304b\u3089<strong>\u300cWinding\u300d\u3092\u9078\u629e\u3057\u307e\u3059<\/strong>\u3002<\/li><li>\u305d\u3057\u3066\u6587\u5b57\u30b3\u30fc\u30c9\u6b04\u306b\u300c252\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/li><li>\u3053\u3046\u3059\u308b\u3053\u3068\u3067\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7\u304c\u5373\u5ea7\u306b\u9078\u629e\u3055\u308c\u308b\u305f\u3081\u3001\u305d\u308c\u3092\u898b\u3064\u3051\u308b\u5fc5\u8981\u304c\u306a\u304f\u306a\u308a\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"Excel \u306e\u9078\u629e\u8a18\u53f7\u304b\u3089\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-Excel-a-partir-du-symbole-de-selection-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li>\u6700\u5f8c\u306b<strong>\u300c\u633f\u5165\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057<\/strong>\u3066\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u9589\u3058\u307e\u3059\u3002<\/li><\/ol><p>\u3053\u308c\u306f\u300cWinding\u300d\u30d5\u30a9\u30f3\u30c8\u306a\u306e\u3067\u3001\u30bb\u30eb\u306b\u633f\u5165\u3059\u308b\u3068\u3001Excel \u306b\u3088\u3063\u3066\u30bb\u30eb\u306e\u30d5\u30a9\u30f3\u30c8 \u30b9\u30bf\u30a4\u30eb\u304c\u300cWinding\u300d\u306b\u5909\u66f4\u3055\u308c\u307e\u3059\u3002<\/p><p>\u5358\u7d14\u306a\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u306e\u307b\u304b\u306b\u3001<strong>\u30dc\u30c3\u30af\u30b9\u5185\u306e\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af<\/strong>(254) \u3082\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p><p>\u3059\u3067\u306b\u30c6\u30ad\u30b9\u30c8\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u8a18\u53f7\u3092\u633f\u5165\u3059\u308b\u5834\u5408\u306f\u3001\u305d\u306e\u30bb\u30eb\u3092\u7de8\u96c6\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059 (F2 \u3092\u4f7f\u7528)\u3002<\/p><p>\u4e0a\u8a18\u306e\u65b9\u6cd5\u306f\u5c11\u3057\u9577\u3044\u3067\u3059\u304c\u3001\u6570\u5f0f\u3084\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8 \u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u306f\u306a\u304f\u3001\u30bb\u30eb\u306b\u8ffd\u52a0\u3057\u305f\u3089\u30b3\u30d4\u30fc\u3057\u3066\u8cbc\u308a\u4ed8\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> 4.<span style=\"color: #ea493f;\">\u30aa\u30fc\u30c8\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/span>\u3092\u4f5c\u6210\u3057\u3066\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306b\u5909\u63db\u3057\u307e\u3059<\/h2><p>\u30ad\u30fc\u30dc\u30fc\u30c9 \u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3092\u4f7f\u7528\u3057\u305f\u5f8c\u3001\u6700\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u306f\u3001\u30bb\u30eb\u306b\u76ee\u76db\/\u76ee\u76db\u8a18\u53f7\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3067\u3059\u3002\u3064\u307e\u308a\u3001AUTOCORRECT \u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p><p> Excel \u306b\u306f\u3001\u30b9\u30da\u30eb\u30df\u30b9\u306e\u3042\u308b\u5358\u8a9e\u3092\u4fee\u6b63\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u3059\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u300cclear\u300d\u3068\u5165\u529b\u3059\u308b\u3068\u3001\u300cClear\u300d\u306b\u5909\u63db\u3055\u308c\u3001\u305d\u308c\u304c\u6b63\u3057\u3044\u5358\u8a9e\u306b\u306a\u308a\u307e\u3059\u3002<\/p><p>\u3053\u308c\u306b\u3088\u308a\u3001\u5358\u8a9e\u306e\u81ea\u52d5\u4fee\u6b63\u3092\u4f5c\u6210\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u63d0\u4f9b\u3055\u308c\u3001Excel \u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306b\u5909\u63db\u3059\u308b\u5358\u8a9e\u3092\u5b9a\u7fa9\u3067\u304d\u307e\u3059\u3002<\/p><p>\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u624b\u9806\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p><ol><li>\u307e\u305a\u3001\u300c\u30d5\u30a1\u30a4\u30eb\u300d\u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001 <strong>\u300cExcel \u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u3092\u958b\u304d\u307e\u3059<\/strong>\u3002 <br><img decoding=\"async\" title=\"\u30d5\u30a1\u30a4\u30eb\u30aa\u30d7\u30b7\u30e7\u30f3\u30bf\u30d6\u3092\u958b\u3044\u3066Excel\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u8ffd\u52a0\u3059\u308b\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-les-options-de-longlet-fichier-pour-ajouter-une-coche-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"open-options-from-file-tab-to-add-checkmark-in-excel\"><\/li><li>\u305d\u306e\u5f8c\u3001\u300c\u6821\u6b63\u300d\u306b\u79fb\u52d5\u3057\u3001<a href=\"https:\/\/exceladvisor.org\/ja\/\u30aa\u30fc\u30c8\u30b3\u30ec\u30af\u30c8\/\"><strong>\u81ea\u52d5\u4fee\u6b63\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u958b\u304d\u307e\u3059<\/strong><\/a>\u3002 <br><img decoding=\"async\" title=\"\u30aa\u30fc\u30c8\u30b3\u30ec\u30af\u30c8 \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u958b\u3044\u3066\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u4f5c\u6210\u3057\u307e\u3059\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-loption-de-correction-automatique-pour-creer-une-coche-dans-une-cellule-1.png\" sizes=\"\" srcset=\"\" alt=\"open-autocorrect-option-to-create-checkmark-in-a-cell\"><\/li><li>\u3053\u306e\u30c0\u30a4\u30a2\u30ed\u30b0 \u30dc\u30c3\u30af\u30b9\u306e [\u7f6e\u63db] \u30dc\u30c3\u30af\u30b9\u306b\u3001Excel<strong>\u304c\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u8a18\u53f7\u3092\u8fd4\u3059\u5358\u8a9e\u3092\u5165\u529b\u3057\u307e\u3059<\/strong>(\u3053\u3053\u3067\u306f CMRK \u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059)\u3002<\/li><li>\u6b21\u306b\u3001\u300cWith:\u300d\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u3053\u3053\u304b\u3089\u30b3\u30d4\u30fc\u3067\u304d\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"\u81ea\u52d5\u4fee\u6b63\u30aa\u30d7\u30b7\u30e7\u30f3\u306b\u7f6e\u63db\u3092\u8ffd\u52a0 - Excel \u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-remplacement-dans-loption-de-correction-automatique-inserer-une-coche-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"add-a-replacement-in-autocorrect-option-insert-a-checkmark-in-excel\"><\/li><li>\u6700\u5f8c\u306b\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li><\/ol><p>\u4eca\u5f8c\u3001CHMRK \u3092\u5165\u529b\u3059\u308b\u305f\u3073\u306b\u3001Excel \u306f\u305d\u308c\u3092\u5b9f\u969b\u306e\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u306b\u5909\u63db\u3057\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-en-utilisant-la-correction-automatique-1.gif\" sizes=\"\" srcset=\"\" alt=\"\u30aa\u30fc\u30c8\u30b3\u30ec\u30af\u30c8\u3092\u4f7f\u7528\u3057\u3066 Excel \u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\"><\/figure><\/div><p>\u3053\u306e\u81ea\u52d5\u4fee\u6b63\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306b\u3064\u3044\u3066\u306f\u3001\u6ce8\u610f\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u70b9\u304c\u3044\u304f\u3064\u304b\u3042\u308a\u307e\u3059\u3002<\/p><ul><li>\u30aa\u30fc\u30c8\u30b3\u30ec\u30af\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3068\u304d\u306f\u3001\u5927\u6587\u5b57\u3068\u5c0f\u6587\u5b57\u304c\u533a\u5225\u3055\u308c\u308b\u3053\u3068\u306b\u6ce8\u610f\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u6700\u5584\u306e\u65b9\u6cd5\u306f\u3001\u540c\u3058\u5358\u8a9e\u3092\u4f7f\u7528\u3057\u3066 2 \u3064\u306e\u7570\u306a\u308b\u30aa\u30fc\u30c8\u30b3\u30ec\u30af\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/li><li>\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3068\u3057\u3066\u4fee\u6b63\u5bfe\u8c61\u306b\u6307\u5b9a\u3057\u305f\u5358\u8a9e\u306f\u3001\u5225\u306e\u5358\u8a9e\u3068\u3057\u3066\u5165\u529b\u3057\u305f\u5834\u5408\u306e\u307f\u5909\u63db\u3055\u308c\u307e\u3059\u3002 Task1CHMRK \u3068\u5165\u529b\u3057\u3066\u3082\u3001Task1 \u306b\u306f\u5909\u63db\u3055\u308c\u306a\u3044\u3068\u3057\u307e\u3059\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u30c6\u30ad\u30b9\u30c8\u306f Task1 CHMRK \u3067\u3042\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/li><li>\u3059\u3079\u3066\u306e Office \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u9069\u7528\u3055\u308c\u308b\u81ea\u52d5\u4fee\u6b63\u30aa\u30d7\u30b7\u30e7\u30f3\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u306e\u30aa\u30fc\u30c8\u30b3\u30ec\u30af\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3068\u3001\u4ed6\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u3082\u305d\u308c\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/li><\/ul><h2 class=\"wp-block-heading\"> 5. \u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u5165\u308c\u308b\u30de\u30af\u30ed<\/h2><p>\u52b4\u529b\u3068\u6642\u9593\u3092\u7bc0\u7d04\u3057\u305f\u3044\u5834\u5408\u306f\u3001VBA \u30b3\u30fc\u30c9\u3092\u4f7f\u7528\u3057\u3066\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3067\u304d\u307e\u3059\u3002\u30b3\u30fc\u30c9\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub addCheckMark() Dim rng As Range For Each rng In Selection With rng .Font.Name = \"Wingdings\" .Value = \"\u00fc\" End With Next rng End Sub<\/code><\/pre><p class=\"qt-tip\"><strong><span style=\"color: #000000;\">\u30d7\u30ed\u306e\u30d2\u30f3\u30c8:<\/span><\/strong>\u3053\u306e\u30b3\u30fc\u30c9\u3092\u3059\u3079\u3066\u306e\u30d5\u30a1\u30a4\u30eb\u3067\u4f7f\u7528\u3059\u308b\u306b\u306f\u3001\u305d\u308c\u3092<a href=\"https:\/\/exceladvisor.org\/ja\/\u500b\u4eba\u7684\u306a\u30de\u30af\u30ed\u30ce\u30fc\u30c8\/\">\u500b\u4eba\u7528\u30de\u30af\u30ed \u30d5\u30a9\u30eb\u30c0\u30fc<\/a>\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p><h3 class=\"wp-block-heading\">\u3053\u306e\u30b3\u30fc\u30c9\u304c\u3069\u306e\u3088\u3046\u306b\u6a5f\u80fd\u3059\u308b\u304b\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/h3><p>\u30bb\u30eb\u307e\u305f\u306f\u30bb\u30eb\u7bc4\u56f2\u3092\u9078\u629e\u3057\u3066\u3053\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u5404\u30bb\u30eb\u3092\u8abf\u3079\u3066\u30d5\u30a9\u30f3\u30c8 \u30b9\u30bf\u30a4\u30eb\u3092\u300cWingdings\u300d\u306b\u5909\u66f4\u3057\u3001\u5024\u300c\u00fc\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p><h3 class=\"wp-block-heading\"> QAT\u306b\u30de\u30af\u30ed\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0<\/h3><p>\u3053\u308c\u306f\u3001\u4ed5\u4e8b\u3067\u3053\u306e\u30b3\u30fc\u30c9\u3092\u3088\u308a\u983b\u7e41\u306b\u4f7f\u7528\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u5834\u5408\u306b\u4f7f\u7528\u3067\u304d\u308b PRO \u306e\u30d2\u30f3\u30c8\u3067\u3059\u3002\u3053\u308c\u3092\u884c\u3046\u306b\u306f\u3001\u6b21\u306e\u7c21\u5358\u306a\u624b\u9806\u306b\u5f93\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p><ol><li>\u307e\u305a\u3001\u300c\u30af\u30a4\u30c3\u30af\u30a2\u30af\u30bb\u30b9\u30c4\u30fc\u30eb\u30d0\u30fc\u300d\u306e\u4e0b\u77e2\u5370\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u305d\u306e\u4ed6\u306e\u30b3\u30de\u30f3\u30c9\u300d\u3092\u958b\u304d\u307e\u3059\u3002<\/li><li>\u6b21\u306b\u3001\u300c\u30b3\u30de\u30f3\u30c9\u306e\u9078\u629e\u300d\u304b\u3089\u300c\u30de\u30af\u30ed\u300d\u3092\u9078\u629e\u3057\u3001\u300c\u8ffd\u52a0&gt;&gt;\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3053\u306e\u30de\u30af\u30ed \u30b3\u30fc\u30c9\u3092 QAT \u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/li><li>\u6700\u5f8c\u306b\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li><\/ol><h3 class=\"wp-block-heading\"> <span style=\"color: #0000ee;\">VBA\u3067\u306e\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u65b9\u6cd5<\/span><\/h3><p>To Do \u30ea\u30b9\u30c8\u3067\u3001\u30bb\u30eb\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3057\u305f\u3044\u3068\u3057\u307e\u3059\u3002<\/p><p>\u3053\u308c\u306f\u3001VBA \u306e\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af \u30a4\u30d9\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001\u30b3\u30fc\u30c9\u306e\u4e0b\u306b\u540c\u3058\u30b3\u30fc\u30c9\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserez-une-coche-dans-exce-en-utilisant-la-methode-1-du-double-clic-vba.gif\" sizes=\"\" srcset=\"\" alt=\"vba \u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066 Excel \u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 2 Then Cancel = True Target.Font.Name = \"Wingdings\" If Target.Value = \"\" Then Target.Value = \"\u00fc\" Else Target.Value = \"\" End If End If End Sub<\/code><\/pre><h4 class=\"wp-block-heading\"><strong>\u3053\u306e\u30b3\u30fc\u30c9\u306e\u4f7f\u7528\u65b9\u6cd5<\/strong><\/h4><ol><li>\u307e\u305a\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8 VBA \u30b3\u30fc\u30c9 \u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u958b\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u306b\u306f\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8 \u30bf\u30d6\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u30b3\u30fc\u30c9\u306e\u8868\u793a\u3092\u9078\u629e\u3057\u307e\u3059\u3002 <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-la-fenetre-de-code-pour-ajouter-du-code-dans-la-feuille-de-calcul-pour-ajouter-une-coche-dans-une-cellule-en-double-cliquant-1.png\" sizes=\"\" srcset=\"\" alt=\"\u30b3\u30fc\u30c9\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u958b\u3044\u3066\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u3001\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u8ffd\u52a0\u3057\u307e\u3059\"><\/li><li>\u305d\u306e\u5f8c\u3001\u3053\u306e\u30b3\u30fc\u30c9\u3092\u3053\u3053\u306b\u8cbc\u308a\u4ed8\u3051\u3066\u3001VB \u30a8\u30c7\u30a3\u30bf\u3092\u9589\u3058\u307e\u3059\u3002<\/li><li>\u6b21\u306b\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u623b\u308a\u3001\u5217 B \u306e\u4efb\u610f\u306e\u30bb\u30eb\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3057\u307e\u3059\u3002<\/li><\/ol><h4 class=\"wp-block-heading\">\u3053\u306e\u30b3\u30fc\u30c9\u306f\u3069\u306e\u3088\u3046\u306b\u6a5f\u80fd\u3059\u308b\u306e\u304b<\/h4><p>\u30bb\u30eb\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u3053\u306e\u30b3\u30fc\u30c9\u304c\u5b9f\u884c\u3055\u308c\u3001\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u305f\u30bb\u30eb\u304c\u5217 2 \u306b\u3042\u308b\u304b\u3069\u3046\u304b\u304c\u30c1\u30a7\u30c3\u30af\u3055\u308c\u307e\u3059\u3002<\/p><p>\u305d\u3057\u3066\u3001\u3053\u306e\u30bb\u30eb\u304c\u5217 2 \u306e\u5834\u5408\u3001\u305d\u306e\u30d5\u30a9\u30f3\u30c8 \u30b9\u30bf\u30a4\u30eb\u3092\u300cWrap\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002\u305d\u306e\u5f8c\u3001\u3053\u306e\u30bb\u30eb\u304c\u7a7a\u304b\u3069\u3046\u304b\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u30bb\u30eb\u304c\u7a7a\u306e\u5834\u5408\u306f\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u306b\u5909\u308f\u308b\u5024\u300c\u00fc\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u30d5\u30a9\u30f3\u30c8 \u30b9\u30bf\u30a4\u30eb\u306f\u3059\u3067\u306b\u30bb\u30eb\u306b\u9069\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p><p>\u30bb\u30eb\u306b\u3059\u3067\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u304c\u4ed8\u3044\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> 6. \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u8a2d\u5b9a\u3067<span style=\"color: #44b682;\">\u7dd1\u8272\u306e\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af<\/span>\u3092\u8ffd\u52a0\u3059\u308b<\/h2><p>\u3082\u3063\u3068\u30d5\u30a1\u30f3\u30ad\u30fc\u3067\u30af\u30ea\u30a8\u30a4\u30c6\u30a3\u30d6\u306b\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306b\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p><p>\u4ee5\u4e0b\u306f\u30bf\u30b9\u30af\u306e\u30ea\u30b9\u30c8\u3067\u30011 \u3064\u306e\u5217\u306b 1 \u3064\u306e\u30bf\u30b9\u30af\u304c\u3042\u308a\u3001\u3082\u3046 1 \u3064\u306e\u5217\u306b\u306f\u30bf\u30b9\u30af\u304c\u5b8c\u4e86\u3057\u305f\u5834\u5408\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3057\u305f\u3044\u3068\u3057\u307e\u3059\u3002<\/p><p>\u4ee5\u4e0b\u306b\u5f93\u3046\u624b\u9806\u3092\u793a\u3057\u307e\u3059\u3002 <\/p><ul id=\"block-07017e43-b219-485c-9f14-ebfb8d24ef79\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"07017e43-b219-485c-9f14-ebfb8d24ef79\" data-type=\"core\/list\" data-title=\"List\"><li>\u307e\u305a\u3001\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u9069\u7528\u3059\u308b<strong>\u5bfe\u8c61\u306e\u30bb\u30eb\u307e\u305f\u306f\u30bb\u30eb\u7bc4\u56f2\u3092\u9078\u629e\u3057\u307e\u3059<\/strong>\u3002<\/li><li>\u305d\u306e\u5f8c\u3001[\u30db\u30fc\u30e0] \u30bf\u30d6 \u279c \u30b9\u30bf\u30a4\u30eb \u279c \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f \u279c \u30a2\u30a4\u30b3\u30f3 \u30bb\u30c3\u30c8 \u279c \u305d\u306e\u4ed6\u306e\u30eb\u30fc\u30eb\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/li><li>\u6b21\u306b\u3001\u30eb\u30fc\u30e9\u30fc \u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u6b21\u306e\u64cd\u4f5c\u3092\u884c\u3044\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"Excel \u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u6761\u4ef6\u4ed8\u304d\u6700\u5c0f\u66f8\u5f0f\u8a2d\u5b9a\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-la-mise-en-forme-conditionnelle-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/li><li>\u30a2\u30a4\u30b3\u30f3 \u30bb\u30c3\u30c8\u304b\u3089\u7dd1\u8272\u306e\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af \u30b9\u30bf\u30a4\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li> \u300c\u30a2\u30a4\u30b3\u30f3\u306e\u307f\u3092\u8868\u793a\u300d\u30aa\u30d7\u30b7\u30e7\u30f3\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u307e\u3059\u3002<\/li><li>\u7dd1\u8272\u306e\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306e\u5024\u3068\u3057\u3066\u300c1\u300d\u3092\u5165\u529b\u3057\u3001\u7a2e\u985e\u304b\u3089\u6570\u5024\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li>\u6700\u5f8c\u306b\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li><\/ul><p>\u305d\u308c\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u30bb\u30eb\u306b 1 \u3092\u5165\u529b\u3057\u307e\u3059\u3002\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u8a2d\u5b9a\u306b\u3088\u308a\u3001\u5b9f\u969b\u306e\u30bb\u30eb\u5024\u306a\u3057\u3067\u7dd1\u8272\u306e\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-Excel-vert-avec-mise-en-forme-conditionnelle-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u8a2d\u5b9a\u3092\u4f7f\u7528\u3057\u3066 Excel \u7dd1\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3057\u307e\u3059\u3002\"><\/figure><\/div><p>\u3053\u306e\u66f8\u5f0f\u8a2d\u5b9a\u3092 1 \u3064\u306e\u30bb\u30eb\u307e\u305f\u306f\u7bc4\u56f2\u304b\u3089\u5225\u306e\u7bc4\u56f2\u306b\u9069\u7528\u3059\u308b\u5834\u5408\u306f\u3001 format Painter \u3092\u4f7f\u7528\u3057\u3066\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> 7. \u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b<span style=\"color: #ea493f;\">\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8<\/span>\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/h2><p>\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u30b3\u30d4\u30fc\u3057\u3066\u8cbc\u308a\u4ed8\u3051\u305f\u304f\u306a\u3044\u5834\u5408\u3084\u3001\u6570\u5f0f\u3092\u8ffd\u52a0\u3057\u305f\u304f\u306a\u3044\u5834\u5408\u306f\u3001\u30c7\u30fc\u30bf\u691c\u8a3c\u3092\u4f7f\u7528\u3057\u3066\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u3092\u4f5c\u6210\u3057\u3001\u3053\u306e\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u3092\u4f7f\u7528\u3057\u3066\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u3053\u3068\u304c\u6700\u5584\u306e\u65b9\u6cd5\u3067\u3042\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p>\u958b\u59cb\u3059\u308b\u524d\u306b\u3001<strong><span style=\"color: #ff0000;\">\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7 \u2713 \u3092\u30b3\u30d4\u30fc\u3057\u3066\u304b\u3089\u3001\u3053\u306e\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3059\u308b\u30bb\u30eb\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<\/span><\/strong>\u3002\u305d\u306e\u5f8c\u3001\u6b21\u306e\u7c21\u5358\u306a\u624b\u9806\u306b\u5f93\u3063\u3066\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u8ffd\u52a0\u3059\u308b\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002 <\/p><ul id=\"block-0336b7f1-e9f7-4a57-8ec5-8ef77980d5e5\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"0336b7f1-e9f7-4a57-8ec5-8ef77980d5e5\" data-type=\"core\/list\" data-title=\"List\"><li>\u307e\u305a\u3001[\u30c7\u30fc\u30bf] \u30bf\u30d6 \u27a8 \u30c7\u30fc\u30bf \u30c4\u30fc\u30eb \u27a8 \u30c7\u30fc\u30bf\u691c\u8a3c \u27a8 \u30c7\u30fc\u30bf\u691c\u8a3c \u306b\u79fb\u52d5\u3057\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"\u30c7\u30fc\u30bf\u691c\u8a3c\u30c0\u30a4\u30a2\u30ed\u30b0\u3092\u958b\u3044\u3066\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-la-boite-de-dialogue-de-validation-des-donnees-pour-creer-une-liste-deroulante-pour-inserer-une-coche-1.png\" sizes=\"\" srcset=\"\" alt=\"open-the-data-validation-dialog-box-to-create-a-drop-down-for-inserting-a-checkmark\"><\/li><li>\u6b21\u306b\u3001\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3067\u3001\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30ea\u30b9\u30c8\u304b\u3089\u300c\u30ea\u30b9\u30c8\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li>\u305d\u306e\u5f8c\u3001\u30b3\u30d4\u30fc\u3057\u305f\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u300c\u30bd\u30fc\u30b9\u300d\u306b\u8cbc\u308a\u4ed8\u3051\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"\u30ea\u30b9\u30c8\u3092\u9078\u629e\u3057\u3066\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7\u3092\u8cbc\u308a\u4ed8\u3051\u308b\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-la-liste-et-collez-le-symbole-de-coche-1.png\" sizes=\"\" srcset=\"\" alt=\"select-list-and-paste-the-checkmark-symbol\"><\/li><li>\u6700\u5f8c\u306b\u3001\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-avec-un-menu-deroulant-1.png\" sizes=\"\" srcset=\"\" alt=\"insert-a-check-mark-with-a-drop-down\"><\/li><\/ul><p>\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u4ed8\u304d\u306e\u5341\u5b57\u8a18\u53f7 \u2716 \u3092\u8ffd\u52a0\u3057\u3066\u3001\u5fc5\u8981\u306a\u3068\u304d\u306b\u305d\u308c\u3089\u306e\u3044\u305a\u308c\u304b\u3092\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u30ab\u30f3\u30de\u4ed8\u304d\u5341\u5b57\u8a18\u53f7\u3092\u8ffd\u52a0\u3057\u3066 [OK] \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p><p>\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u306b\u306f\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3068\u30d0\u30c4\u5370\u4ee5\u5916\u306e\u30bb\u30eb\u5185\u306e\u5024\u3092\u7981\u6b62\u3067\u304d\u308b\u3068\u3044\u3046\u3082\u3046 1 \u3064\u306e\u5229\u70b9\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p> [\u30a8\u30e9\u30fc \u30a2\u30e9\u30fc\u30c8] \u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001[\u7121\u52b9\u306a\u30c7\u30fc\u30bf\u5165\u529b\u5f8c\u306b\u30a8\u30e9\u30fc \u30a2\u30e9\u30fc\u30c8\u3092\u8868\u793a\u3059\u308b] \u30dc\u30c3\u30af\u30b9\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3001\u30bf\u30a4\u30d7\u3001\u30bf\u30a4\u30c8\u30eb\u3001\u304a\u3088\u3073\u5225\u306e\u5024\u304c\u5165\u529b\u3055\u308c\u305f\u3068\u304d\u306b\u8868\u793a\u3059\u308b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u9078\u629e\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p><p><strong>\u95a2\u9023\u3057\u3066\u3044\u308b<\/strong><\/p><ul><li><a href=\"https:\/\/exceladvisor.org\/ja\/\u52d5\u7684\u30ea\u30b9\u30c8\/\" data-wpel-link=\"internal\">Excel \u3067\u4f9d\u5b58\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5<\/a><\/li><li>Excel \u3067\u52d5\u7684\u306a\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3 \u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5<\/li><\/ul><h2 class=\"wp-block-heading\">8. CHAR\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b<\/h2><p>\u5fc5\u305a\u3057\u3082\u81ea\u5206\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u6570\u5f0f\u3092\u4f7f\u7528\u3057\u3066\u81ea\u52d5\u5316\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u5225\u306e\u30bb\u30eb\u306e\u5024\u306b\u57fa\u3065\u3044\u3066\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u3068\u3057\u307e\u3059\u3002<\/p><p>\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001\u5217 C \u306b\u5024\u3092\u5165\u529b\u3059\u308b\u3068\u3001\u6570\u5f0f\u306f\u5217 A \u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u8fd4\u3057\u307e\u3059\u3002\u3053\u306e\u3088\u3046\u306a\u6570\u5f0f\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001CHAR \u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p> CHAR(\u6570\u5024) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-Excel-via-la-formule-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h3 class=\"wp-block-heading\">\u7c21\u5358\u306a\u7d39\u4ecb: CHAR \u95a2\u6570<\/h3><p>CHAR \u95a2\u6570\u306f\u3001ASCII \u5024\u3068 Macintosh \u6587\u5b57\u30bb\u30c3\u30c8\u306b\u57fa\u3065\u3044\u3066\u6587\u5b57\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p><p>\u69cb\u6587\uff1a<\/p><p> CHAR(\u6570\u5024)<\/p><h3 class=\"wp-block-heading\"> \u2026\u4f7f\u3044\u65b9<\/h3><p>\u5148\u307b\u3069\u3082\u8a00\u3044\u307e\u3057\u305f\u304c\u3001CHAR \u306f\u6570\u5024\u3092 ANSI \u6587\u5b57 (Windows) \u3068 Macintosh \u6587\u5b57\u30bb\u30c3\u30c8 (Mac) \u306b\u5909\u63db\u3059\u308b\u95a2\u6570\u3067\u3059\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u306e ANSI \u30b3\u30fc\u30c9\u3067\u3042\u308b 252 \u3092\u5165\u529b\u3059\u308b\u3068\u3001\u6570\u5f0f\u306f\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> 9.<span style=\"color: #ea493f;\">\u30b0\u30e9\u30d5\u30a3\u30c3\u30af\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af<\/span><\/h2><p>\u79c1\u3068\u540c\u3058\u3088\u3046\u306b OFFICE 365 \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u30ea\u30dc\u30f3\u306b\u300cDraw\u300d\u3068\u3044\u3046\u540d\u524d\u306e\u65b0\u3057\u3044\u30bf\u30d6\u304c\u3042\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/dessinez-une-coche-dans-un-tableur-a-laide-dun-stylo-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u30da\u30f3\u3092\u4f7f\u7528\u3057\u3066\u30b9\u30d7\u30ec\u30c3\u30c9\u30bb\u30c3\u30c8\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u63cf\u304f\" width=\"697\" height=\"134\"><\/figure><\/div><p>\u3053\u3053\u3067\u5927\u4e8b\u306a\u3053\u3068\u306f\u3001\u3053\u306e\u30bf\u30d6\u306b\u306f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u76f4\u63a5\u63cf\u753b\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308b\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002\u4f7f\u7528\u3067\u304d\u308b\u30da\u30f3\u3084\u30de\u30fc\u30ab\u30fc\u306f\u3055\u307e\u3056\u307e\u3067\u3059\u3002<\/p><p>\u7c21\u5358\u306a\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u63cf\u304f\u3060\u3051\u3067\u3001Excel \u304c\u305d\u308c\u3092\u30b0\u30e9\u30d5\u3068\u3057\u3066\u633f\u5165\u3057\u307e\u3059\u3002<\/p><p><strong><span style=\"color: #000000;\">\u6700\u3082\u512a\u308c\u3066\u3044\u308b\u70b9<\/span><\/strong>\u306f\u3001\u4ed6\u306e\u4eba\u3068\u5171\u6709\u3059\u308b\u3068\u3001\u4ed6\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306e Excel \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3067\u3082\u3001\u30b0\u30e9\u30d5\u3068\u3057\u3066\u8868\u793a\u3055\u308c\u308b\u3053\u3068\u3067\u3059\u3002\u6d88\u53bb\u30dc\u30bf\u30f3\u3082\u3042\u308a\u307e\u3059\u3002\u5148\u306b\u9032\u3093\u3067\u3053\u306e\u300c\u63cf\u753b\u300d\u30bf\u30d6\u3092\u63a2\u7d22\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u30bf\u30d6\u3092\u4f7f\u7528\u3057\u3066\u3067\u304d\u308b\u7d20\u6674\u3089\u3057\u3044\u3053\u3068\u304c\u305f\u304f\u3055\u3093\u3042\u308a\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> 10. \u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3092\u30bb\u30eb\u306e\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b<\/h2><p>\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3092\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u3053\u306e 2 \u3064\u306b\u306f\u5c0f\u3055\u306a\u9055\u3044\u304c\u3042\u308a\u307e\u3059\u3002<\/p><ol><li>\u30c1\u30a7\u30c3\u30af \u30dc\u30c3\u30af\u30b9\u306f\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306e\u6700\u4e0a\u90e8\u306b\u914d\u7f6e\u3055\u308c\u308b\u30ec\u30a4\u30e4\u30fc\u72b6\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3059\u304c\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u306f\u30bb\u30eb\u306b\u633f\u5165\u3067\u304d\u308b\u8a18\u53f7\u3067\u3059\u3002<\/li><li>\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306f\u5225\u500b\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308a\u3001\u30bb\u30eb\u306e\u5185\u5bb9\u3092\u524a\u9664\u3057\u3066\u3082\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306f\u4e00\u7dd2\u306b\u524a\u9664\u3055\u308c\u307e\u305b\u3093\u3002\u4e00\u65b9\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306f\u30bb\u30eb\u5185\u306b\u914d\u7f6e\u3059\u308b\u8a18\u53f7\u3067\u3059\u3002<\/li><\/ol><p>\u3053\u3053\u3067\u306f\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306b\u3064\u3044\u3066\u5b66\u3073\u3001\u6b63\u3057\u304f\u4f7f\u7528\u3059\u308b\u306e\u306b\u5f79\u7acb\u3064\u8a73\u7d30\u306a\u30ac\u30a4\u30c9\u3092\u793a\u3057\u307e\u3059\u3002<\/p><h2 class=\"wp-block-heading\"> 11. \u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3057\u307e\u3059\uff08\u30a4\u30f3\u30e9\u30a4\u30f3\uff09<\/h2><p> Excel \u306e\u30aa\u30f3\u30e9\u30a4\u30f3 \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u5225\u306e\u65b9\u6cd5\u306b\u5f93\u3063\u3066\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u4ed8\u3051\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><p>\u554f\u984c\u306f\u3001\u30db\u30c3\u30c8\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u3059\u304c\u3001\u300cWinding\u300d\u30d5\u30a9\u30f3\u30c8\u304c\u306a\u3044\u305f\u3081\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306b\u5909\u63db\u3067\u304d\u306a\u3044\u3053\u3068\u3067\u3059\u3002 CHAR\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u3082\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306b\u306f\u5909\u63db\u3055\u308c\u307e\u305b\u3093\u3002<\/p><p>\u76ee\u6a19\u2026\u76ee\u6a19\u2026\u76ee\u6a19\u2026<\/p><p> Excel online \u306b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3001\u30b7\u30f3\u30dc\u30eb\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u7c21\u5358\u306a\u65b9\u6cd5\u3092\u898b\u3064\u3051\u307e\u3057\u305f\u3002\u4ee5\u4e0b\u306b\u5f93\u3046\u624b\u9806\u3092\u793a\u3057\u307e\u3059\u3002 <\/p><ul id=\"block-1628af31-3129-4f27-a04a-1e1d605f4b63\" class=\"block-editor-rich-text__editable block-editor-block-list__block wp-block is-selected rich-text\" tabindex=\"0\" role=\"group\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Block: List\" data-block=\"1628af31-3129-4f27-a04a-1e1d605f4b63\" data-type=\"core\/list\" data-title=\"List\"><li>\u307e\u305a\u3001[\u633f\u5165] \u279c [\u30a2\u30c9\u30a4\u30f3] \u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001[Office \u30a2\u30c9\u30a4\u30f3] \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"\u30a2\u30c9\u30a4\u30f3\u3092\u958b\u3044\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u633f\u5165\u3057\u3001\u30aa\u30f3\u30e9\u30a4\u30f3 Excel \u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u8ffd\u52a0\u3059\u308b\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-des-complements-pour-inserer-une-application-pour-ajouter-une-coche-dans-Excel-en-ligne-1.png\" sizes=\"\" srcset=\"\" alt=\"open-add-ins-to-insert-an-app-to-add-checkmark-in-online-excel\"><\/li><li>\u6b21\u306b\u3001\u30a2\u30c9\u30a4\u30f3 \u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u30b9\u30c8\u30a2\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u30b7\u30f3\u30dc\u30eb\u300d\u3092\u63a2\u3057\u307e\u3059\u3002<\/li><li>\u3053\u3053\u306b\u306f\u300c\u30b7\u30f3\u30dc\u30eb\u3068\u6587\u5b57\u300d\u3068\u3044\u3046\u540d\u524d\u306e\u30a2\u30c9\u30aa\u30f3\u304c\u3042\u308a\u3001\u300c\u8ffd\u52a0\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"\u691c\u7d22\u30d0\u30fc\u304b\u3089\u306e\u691c\u7d22\u30b7\u30f3\u30dc\u30eb\u30a2\u30d7\u30ea\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/rechercher-lapplication-de-symboles-dans-la-barre-de-recherche-1.png\" sizes=\"\" srcset=\"\" alt=\"search-for-the-symbol-app-from-the-search-bar\"><\/li><li>\u305d\u306e\u5f8c\u3001[\u30a2\u30c9\u30a4\u30f3] \u30bf\u30d6\u306b\u79fb\u52d5\u3057\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3070\u304b\u308a\u306e\u30a2\u30c9\u30a4\u30f3\u3092\u958b\u304d\u307e\u3059\u3002<\/li><li>\u3053\u306e\u6642\u70b9\u3067\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u8a18\u53f7\u3092\u898b\u3064\u3051\u3066\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u30bb\u30eb\u306b\u633f\u5165\u3067\u304d\u308b\u30b5\u30a4\u30c9 \u30da\u30a4\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <br><img decoding=\"async\" title=\"\u691c\u7d22\u30d0\u30fc\u304b\u3089\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u691c\u7d22\u3057\u3001\u30af\u30ea\u30c3\u30af\u3057\u3066\u633f\u5165\u3057\u307e\u3059\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherchez-la-coche-dans-la-barre-de-recherche-et-cliquez-dessus-pour-linserer-1.png\" sizes=\"\" srcset=\"\" alt=\"search-for-the-checkmark-from-the-searchbar-and-click-on-it-to-insert-it\"><\/li><\/ul><p>\u306f\u3044\u3001\u305d\u308c\u3060\u3051\u3067\u3059\u3002<\/p><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coche.zip\" rel=\"nofollow\" data-wpel-link=\"internal\"><strong>\u2026\u5fc5\u305a\u3053\u3053\u304b\u3089\u3053\u306e\u30b5\u30f3\u30d7\u30eb \u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3057\u3066\u3001\u624b\u9806\u306b\u5f93\u3063\u3066\u3001\u81ea\u5206\u3067\u8a66\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/strong><\/a><\/p><h2 class=\"wp-block-heading\">\u5b66\u3076\u5fc5\u8981\u304c\u3042\u308b<span style=\"color: #ea493f;\">\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8<\/span>\u306e\u3044\u304f\u3064\u304b<\/h2><p>\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306e\u4f7f\u7528\u306b\u3064\u3044\u3066\u5b66\u3076\u5fc5\u8981\u304c\u3042\u308b\u3053\u3068\u304c\u3044\u304f\u3064\u304b\u3042\u308a\u307e\u3059\u3002<\/p><h3 class=\"wp-block-heading\"> 1. \u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3059\u308b<\/h3><p>\u7279\u306b\u4f55\u304b\u3092\u691c\u8a3c\u3059\u308b\u30c7\u30fc\u30bf\u3092\u64cd\u4f5c\u3059\u308b\u5834\u5408\u306b\u306f\u3001\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306e\u66f8\u5f0f\u8a2d\u5b9a\u304c\u5fc5\u8981\u306b\u306a\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u4ed8\u3051\u308b\u3068\u3067\u304d\u308b\u3053\u3068\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p><ul><li><strong>\u592a\u5b57<\/strong>\u304b\u3064<em>\u659c\u4f53\u306b<\/em>\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li><li>\u8272\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/li><li>\u30d5\u30a9\u30f3\u30c8\u30b5\u30a4\u30ba\u3092\u62e1\u5927\u307e\u305f\u306f\u7e2e\u5c0f\u3057\u307e\u3059\u3002<\/li><li>\u4e0b\u7dda\u3092\u9069\u7528\u3057\u307e\u3059\u3002<\/li><\/ul><h3 class=\"wp-block-heading\"> 2. \u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u5916\u3057\u307e\u3059<\/h3><p>\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u524a\u9664\u3059\u308b\u306e\u306f\u7c21\u5358\u3067\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u306e\u3042\u308b\u30bb\u30eb\u3092\u9078\u629e\u3057\u3066 Delete \u30ad\u30fc\u3092\u62bc\u3059\u3060\u3051\u3067\u3059\u3002<\/p><p>\u307e\u305f\u306f\u3001\u30bb\u30eb\u5185\u306b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u304c\u4ed8\u3044\u3066\u3044\u308b\u30c6\u30ad\u30b9\u30c8\u304c\u3042\u308b\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u3044\u305a\u308c\u304b\u306e\u65b9\u6cd5\u3092\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p><ol><li><strong><span style=\"color: #000000;\">\u307e\u305a<\/span><\/strong>\u3001\u30bb\u30eb\u3092\u7de8\u96c6\uff08F2\uff09\u3057\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u5916\u3057\u307e\u3059\u3002<\/li><li><strong><span style=\"color: #000000;\">\u6b21\u306b<\/span><\/strong>\u3001<a href=\"https:\/\/exceladvisor.org\/ja\/\u691c\u7d22\u7f6e\u63db\/\" data-wpil=\"url\" data-wpel-link=\"internal\">\u691c\u7d22\u3068\u7f6e\u63db\u30aa\u30d7\u30b7\u30e7\u30f3<\/a>\u3092\u4f7f\u7528\u3057\u3066\u3001\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u6587\u5b57\u306a\u3057\u3067\u7f6e\u304d\u63db\u3048\u307e\u3059\u3002<\/li><\/ol><h3 class=\"wp-block-heading\"> 3. \u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u6570\u3048\u307e\u3059<\/h3><p>\u30bb\u30eb\u7bc4\u56f2\u5185\u306b\u3042\u308b\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7\u3092\u6570\u3048\u305f\u3044\u3068\u3057\u307e\u3059\u3002 COUNTIF \u3068 CHAR \u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u6570\u5f0f\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u305d\u306e\u6570\u5f0f\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002 <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">=COUNTIF(G3:G9,CHAR(252))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-simple-formule-countif-pour-compter-les-symboles-de-coche-a-partir-dune-plage-de-cellules-1.png\" sizes=\"\" srcset=\"\" alt=\"\u30bb\u30eb\u7bc4\u56f2\u306e\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u3092\u6570\u3048\u308b\u7c21\u5358\u306a\u6570\u5f0f\" width=\"-476\" height=\"-319\"><\/figure><\/div><p>\u3053\u306e\u6570\u5f0f\u3067\u306f\u3001COUNTIF \u3092\u4f7f\u7528\u3057\u3066\u3001CHAR \u306b\u3088\u3063\u3066\u8fd4\u3055\u308c\u308b\u6587\u5b57\u3092\u30ab\u30a6\u30f3\u30c8\u3057\u307e\u3057\u305f\u3002<\/p><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coche.zip\" rel=\"nofollow\" data-wpel-link=\"internal\"><strong>\u2026\u5fc5\u305a\u3053\u3053\u304b\u3089\u3053\u306e\u30b5\u30f3\u30d7\u30eb \u30d5\u30a1\u30a4\u30eb\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u3001\u624b\u9806\u306b\u5f93\u3063\u3066\u3001\u81ea\u5206\u3067\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/strong><\/a><\/p><h2 class=\"wp-block-heading\">\u6700\u5f8c\u306b\u3001<\/h2><p>\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u306f<span style=\"font-size: 1em; letter-spacing: 0px;\">\u30ea\u30b9\u30c8\u3092\u7ba1\u7406\u3059\u308b\u3068\u304d\u306b\u4fbf\u5229\u3067\u3059\u3002<\/span><\/p><p> Excel \u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u4ed8\u304d\u306e\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u306f\u300110 \u4ee5\u4e0a\u306e\u65b9\u6cd5\u3092\u77e5\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u4eca\u3067\u306f\u554f\u984c\u306b\u306a\u308a\u307e\u305b\u3093\u3002\u4e0a\u8a18\u306e\u3059\u3079\u3066\u306e\u65b9\u6cd5\u306e\u4e2d\u3067\u3001\u79c1\u306f\u5e38\u306b\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u4f7f\u7528\u3059\u308b\u306e\u304c\u597d\u304d\u3067\u3001\u5834\u5408\u306b\u3088\u3063\u3066\u306f\u30b3\u30d4\u30fc \u30a2\u30f3\u30c9 \u30da\u30fc\u30b9\u30c8\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p><p>\u81ea\u5206\u306b\u6700\u9069\u3060\u3068\u601d\u3046\u3082\u306e\u3092\u3069\u308c\u3067\u3082\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u30d2\u30f3\u30c8\u304c\u3042\u306a\u305f\u306e\u65e5\u5e38\u696d\u52d9\u306b\u5f79\u7acb\u3064\u3053\u3068\u3092\u9858\u3063\u3066\u3044\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u4eca\u4e00\u3064\u3060\u3051\u8a00\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p><p><strong>\u4e0a\u8a18\u306e\u65b9\u6cd5\u306e\u3044\u305a\u308c\u304b\u3092\u4f7f\u7528\u3057\u305f\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u304b?\u3069\u306e\u65b9\u6cd5\u304c\u304a\u6c17\u306b\u5165\u308a\u3067\u3059\u304b?<\/strong><\/p><p>\u305c\u3072\u30b3\u30e1\u30f3\u30c8\u6b04\u3067<strong>\u3054\u610f\u898b\u3092\u304a\u805e\u304b\u305b<\/strong>\u304f\u3060\u3055\u3044\u3002\u305c\u3072\u3054\u610f\u898b\u3092\u304a\u5f85\u3061\u3057\u3066\u304a\u308a\u307e\u3059\u3002\u305d\u3057\u3066\u3001\u3053\u306e\u6295\u7a3f\u3092\u53cb\u9054\u3068\u5171\u6709\u3059\u308b\u3053\u3068\u3092\u5fd8\u308c\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\u304d\u3063\u3068\u697d\u3057\u3093\u3067\u3082\u3089\u3048\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/ja\/\u30a8\u30af\u30bb\u30eb\u306e\u57fa\u672c\/\">Microsoft Excel \u306e\u57fa\u672c (\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3001\u30d1\u30fc\u30c4\u3001\u304a\u3088\u3073\u30ca\u30ec\u30c3\u30b8 \u30ce\u30fc\u30c8)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\">\u95a2\u9023\u3059\u308b\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb<\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/ja\/\u8ca0\u306e\u6570\u3092\u6b63\u306e\u6570\u306b\u5909\u66f4\u3059\u308b\/\">Excel \u3067\u8ca0\u306e\u6570\u3092\u6b63\u306e\u6570\u306b\u5909\u63db\u3059\u308b<\/a><\/li><li>Excel\u306b\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u633f\u5165\u3059\u308b<\/li><li><a href=\"https:\/\/exceladvisor.org\/ja\/\u30ce\u30df\/\">Excel \u306b\u7b87\u6761\u66f8\u304d\u3092\u633f\u5165\u3059\u308b<\/a><\/li><li><a href=\"https:\/\/exceladvisor.org\/ja\/\u77e2\u5370\u3092\u633f\u5165\u3059\u308b\/\">Excel \u306e\u30bb\u30eb\u306b\u77e2\u5370\u3092\u633f\u5165\u3059\u308b<\/a><\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2965","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?<\/title>\n<meta name=\"description\" content=\"\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001Excel \u306e\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u6700\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u3092\u3044\u304f\u3064\u304b\u5b66\u3073\u307e\u3059\u3002\u79c1\u306e\u65b9\u6cd5\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/ja\/\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af2\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?\" \/>\n<meta property=\"og:description\" content=\"\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001Excel \u306e\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u6700\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u3092\u3044\u304f\u3064\u304b\u5b66\u3073\u307e\u3059\u3002\u79c1\u306e\u65b9\u6cd5\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ja\/\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-07T04:48:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/\",\"url\":\"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/\",\"name\":\"\u25b7 Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\",\"datePublished\":\"2023-11-21T11:44:20+00:00\",\"dateModified\":\"2023-12-07T04:48:33+00:00\",\"description\":\"\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001Excel \u306e\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u6700\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u3092\u3044\u304f\u3064\u304b\u5b66\u3073\u307e\u3059\u3002\u79c1\u306e\u65b9\u6cd5\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u5bb6\",\"item\":\"https:\/\/exceladvisor.org\/ja\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ja\/\",\"name\":\"Excel Advisor\",\"description\":\"\u30c7\u30fc\u30bf\u3092\u652f\u914d\u3059\u308b\u305f\u3081\u306e\u7a76\u6975\u306e\u30ac\u30a4\u30c9!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ja\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ja\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?","description":"\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001Excel \u306e\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u6700\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u3092\u3044\u304f\u3064\u304b\u5b66\u3073\u307e\u3059\u3002\u79c1\u306e\u65b9\u6cd5","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/ja\/\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af2\/","og_locale":"ja_JP","og_type":"article","og_title":"\u25b7 Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?","og_description":"\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001Excel \u306e\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u6700\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u3092\u3044\u304f\u3064\u304b\u5b66\u3073\u307e\u3059\u3002\u79c1\u306e\u65b9\u6cd5","og_url":"https:\/\/exceladvisor.org\/ja\/\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-07T04:48:33+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/","url":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/","name":"\u25b7 Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ja\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif","datePublished":"2023-11-21T11:44:20+00:00","dateModified":"2023-12-07T04:48:33+00:00","description":"\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001Excel \u306e\u30bb\u30eb\u306b\u30c1\u30a7\u30c3\u30af \u30de\u30fc\u30af\u3092\u633f\u5165\u3059\u308b\u6700\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u3092\u3044\u304f\u3064\u304b\u5b66\u3073\u307e\u3059\u3002\u79c1\u306e\u65b9\u6cd5","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-coche-dans-excel-avec-la-touche-de-raccourci-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/ja\/%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9e%e3%83%bc%e3%82%af2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u5bb6","item":"https:\/\/exceladvisor.org\/ja\/"},{"@type":"ListItem","position":2,"name":"Excel\u3067\u30c1\u30a7\u30c3\u30af\u30de\u30fc\u30af\u8a18\u53f7(\u2713)\u3092\u633f\u5165\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ja\/#website","url":"https:\/\/exceladvisor.org\/ja\/","name":"Excel Advisor","description":"\u30c7\u30fc\u30bf\u3092\u652f\u914d\u3059\u308b\u305f\u3081\u306e\u7a76\u6975\u306e\u30ac\u30a4\u30c9!","publisher":{"@id":"https:\/\/exceladvisor.org\/ja\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ja\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ja\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ja\/","logo":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ja\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ja\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/2965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/comments?post=2965"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/2965\/revisions"}],"predecessor-version":[{"id":3891,"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/pages\/2965\/revisions\/3891"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ja\/wp-json\/wp\/v2\/media?parent=2965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}