Ž¢¤Á¤ç¤Ã¤È¤·¤¿¥³¥ÄŽ£¤Ç¥¨¥¯¥»¥ëºî¶È¤Î¸úΨ¤Ï3Çܤˤʤë¡Ä¥Þ¥ó¥¬¤Ç¤ï¤«¤ëŽ¢¥¨¥¯¥»¥ëÁàºî¤Î2Âç¶Ë°ÕŽ£
¢¨ËܹƤϡ¢±©ÌÓÅÄËÓÅڴƽ¤¡¢¤¢¤¤Ð¤µ¤ä¤«Ì¡²è¡Ø¥Þ¥ó¥¬¤Ç¤ï¤«¤ë Excel¡Ù¡ÊKADOKAWA¡Ë¤Î°ìÉô¤òºÆÊÔ½¸¤·¤¿¤â¤Î¤Ç¤¹¡£
¢£¥·¥ç¡¼¥È¥«¥Ã¥È¤ò»È¤¨¤Ð¡Ö¸úΨ¤¬3Çܡפˤʤë
Excel¤Î¥·¥ç¡¼¥È¥«¥Ã¥È¤È¸À¤¨¤Ð¡¢¥³¥Ô¡¼¡ÖCtrl¡ÜC¡×¡¢Å½¤êÉÕ¤±¡ÖCtrl¡ÜV¡×¡¢¸µ¤ËÌ᤹¡ÖCtrl¡ÜZ¡×¤Ê¤É¤¬¤¢¤ë¡£¤³¤Î¤¢¤¿¤ê¤Ï¤Þ¤À¤·¤â¡¢¥·¥ç¡¼¥È¥«¥Ã¥È¤Ï̵¿ô¤¢¤ê¡¢ÊØÍø¤Ê¤â¤Î¤¬¤¢¤ë¤¬³Ð¤¨¤Ë¤¯¤¤¡Ä¡Ä˺¤ì¤Æ¤·¤Þ¤¦¡Ä¡Ä¤È¤¤¤¦·Ð¸³¤ò¤·¤¿Êý¤â¿¤¤¤À¤í¤¦¡£
±©ÌÓÅÄËÓÅÚ¤µ¤ó¤¤¤ï¤¯¡¢¥·¥ç¡¼¥È¥«¥Ã¥È¤ò»È¤¦¤¿¤á¤Î¶Ë°Õ¤Ï2¤Ä¡£
¶Ë°Õ¤½¤Î2¡¡Ìµ°Õ¼±¤Ë»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ë¤Ù¤·¡ª
¡Ö̵°Õ¼±¡×¤È¤¤¤¦¤Ï¡¢¼«Å¾¼Ö¤Î±¿Å¾¤ÈƱ¤¸¤³¤È¤À¡£¼«Å¾¼Ö¤Î±¿Å¾¤ò¤¹¤ë¤È¤¤Ë¡¢¡Ö¼¡¤Ï¥Ï¥ó¥É¥ë¤ò±¦¤Ë¡ª¡×¤È»×¤Ã¤Æ±¿Å¾¤ò¤·¤Ê¤¤¤À¤í¤¦¡£¥¨¥¯¥»¥ë¤ò»È¤¦¤È¤¤â¡¢¡Ö¥³¥Ô¡¼¤Î¥·¥ç¡¼¥È¥«¥Ã¥È¥¡¼¤ÏCtrl¡ÜC¤À¤«¤é¡¢Ctrl¥¡¼¤Ï¤³¤³¤Ë¤¢¤ë¤Ï¤º¡Ä¡Ä¡×¤È¤¤¤¦¤è¤¦¤Ë¡¢¤¤¤Á¤¤¤Á°Õ¼±¤ò¤·¤Æ¤¤¤Æ¤Ï¤¤¤±¤Ê¤¤¤Î¤À¡£
¤µ¤é¤Ë¡¢±©ÌÓÅÄËÓÅÚ¤µ¤ó¤Ï¡¢Ìµ°Õ¼±¤Ë»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ë¤¿¤á¤Ë¤Ï¡¢¤¤¤¤Ê¤êÁ´Éô¤Ç¤Ï¤Ê¤¯¡¢1¤Ä2¤Ä¤È¡¢¤Ç¤¤ë¤â¤Î¤«¤éÂΤË᤹þ¤à¤è¤¦¤Ë»È¤Ã¤Æ¤¤¤¯¤³¤È¤¬Âç»ö¤À¤È¤¤¤¦¡£
¡Ê2¡Ëºî¶ÈÃæ¤Ë·«¤êÊÖ¤·Æ±¤¸¥·¥ç¡¼¥È¥«¥Ã¥È¤ò»È¤¤¡¢ÂΤ˳Ф¨¤µ¤»¤ë
¡Ê3¡Ë1½µ´Ö¤Û¤É»È¤¤Â³¤±¤ë¤È¡¢¼«Á³¤Ë¼ê¤¬Æ°¤¯¤è¤¦¤Ë¤Ê¤ë
¤È¤¤¤Ã¤¿Î®¤ì¤Ç᤹þ¤ó¤Ç¤¤¤¯¤³¤È¤¬¤ª¤¹¤¹¤á¡£¤½¤³¤Þ¤ÇÎý½¬¤·¤Æ¤â³Ð¤¨¤é¤ì¤Ê¤¤¤Ê¤é¡¢¤¢¤Þ¤ê»È¤ï¤Ê¤¤¥·¥ç¡¼¥È¥«¥Ã¥È¤ÈȽÃǤ·¤Æ¤â¤¤¤¤¤È¤¤¤¦¡£
¢£´ðËÜÃæ¤Î´ðËܡ֤褯»È¤¦¥·¥ç¡¼¥È¥«¥Ã¥È¡×¤È¤Ï
¢£¥»¥ë¤ä¹Ô¡¿Îó¤Îºï½ü¤ÈÄɲÃ
¢£¡Ö¥»¥ëÆâ²þ¹Ô¡×¤ò¤ª¤¹¤¹¤á¤·¤Ê¤¤¥ï¥±
¢£¤¤¤¤Ê¤êÁ´Éô¤Ç¤Ï¤Ê¤¯¡¢¤Ç¤¤ë¤â¤Î¤«¤éÂΤË᤹þ¤à
¢£É¬¿Ü¤Î¥·¥ç¡¼¥È¥«¥Ã¥È¤ò²¡¤µ¤¨¤è¤¦
¥·¥ç¡¼¥È¥«¥Ã¥È¤ò³Ð¤¨¤ë¤È¡¢ºî¶È¤Î¸úΨ¤¬2Çܤâ3Çܤâ¾å¤¬¤ê¤Þ¤¹¡£¤É¤ì¤âºî¶ÈÃæ¤Ë¤è¤¯»È¤¦¤Î¤Ç¡¢¤¼¤Ò³Ð¤¨¤Æ¤¯¤À¤µ¤¤¡£
¡¦Å½¤êÉÕ¤±¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡ÄCtrl¡ÜV
¡¦ÀÚ¤ê¼è¤ê¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡ÄCtrl¡ÜX
¡¦¸µ¤ËÌ᤹¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡Ä¡ÄCtrl¡ÜZ
¡¦¤ä¤ê¤Ê¤ª¤·¡Ê¡Ö¸µ¤ËÌ᤹¡×¤Î¥¥ã¥ó¥»¥ë¡Ë¡Ä¡ÄCtrl¡ÜY
Excel¤Ç¤Ï¡¢¿ô¼°¤ò¥³¥Ô¡¼¡¦Å½¤êÉÕ¤±¤¹¤ë¾ìÌ̤¬Â¿¤¯¤¢¤ê¤Þ¤¹¡£¿ô¼°¤ÎÆþ¤Ã¤¿¥»¥ë¤ò¥³¥Ô¡¼¤·¤¿¤¢¤È¤Ë¡¢¥»¥ëÈϰϤòÁªÂò¤·¤ÆŽ¤êÉÕ¤±¤ë¤È¡¢¤½¤ÎÈϰϤ˿ô¼°¤¬°ì³ç¤ÇŽ¤êÉÕ¤±¤é¤ì¤Þ¤¹¡£
¢£³Ð¤¨¤Æ¤ª¤¤¿¤¤ÊØÍø¤Ê¥·¥ç¡¼¥È¥«¥Ã¥È
´ðËÜŪ¤Ê¥·¥ç¡¼¥È¥«¥Ã¥È¤Î¤Û¤«¡¢¥»¥ë¤ä¹Ô¡¿Îó¤òºï½ü¡¦Äɲ乤륷¥ç¡¼¥È¥«¥Ã¥È¤âÊØÍø¤Ç¤¹¡£
¢¨Äɲäξì¹ç¤ÏCtrl¡ÜShift¡Ü+¤ò²¡¤¹
¢ºï½ü¤·¤¿Ê¬¤ò¤É¤ÎÊý¸þ¤ËµÍ¤á¤ë¤«ÁªÂò¤¹¤ë
£¡ÎOK¡Ï¤ò¥¯¥ê¥Ã¥¯¤¹¤ë
¤¥»¥ë¼«ÂΤ¬ºï½ü¤µ¤ì¡¢»ØÄꤷ¤¿Êý¸þ¤ËµÍ¤á¤é¤ì¤ë
ÃͤÀ¤±¤òºï½ü¤¹¤ë¤Ê¤éDelete¤ò²¡¤·¤Þ¤·¤ç¤¦¡£
¹Ô¡¿Îó¤Îºï½ü¡¦ÄɲÃ
¢¨¹Ô¤òÁªÂò¤¹¤ë¾ì¹ç¤ÏShift¡ÜSpace¤ò²¡¤¹
¢Ctrl¡Ü-¤ò²¡¤¹
¢¨Äɲäξì¹ç¤ÏCtrl¡ÜShift¡Ü+¤ò²¡¤¹
£Î󤬺ï½ü¤µ¤ì¡¢º¸Êý¸þ¤ËµÍ¤á¤é¤ì¤ë
¤½¤Î¤Û¤«¤ÎÊØÍø¤Ê¥·¥ç¡¼¥È¥«¥Ã¥È¥¡¼
½ñ¼°ÀßÄê¥á¥Ë¥å¡¼¤ò³«¤¯Ctrl¡Ü1¤Ï¡¢É½¼¨·Á¼°¤òÊѤ¨¤¿¤ê¡¢·ÓÀþ¤ò°ú¤¤¤¿¤ê¤¹¤ë¤È¤¤Ë»È¤¦¡£
¥»¥ëÆâ²þ¹Ô¤ÎAlt¡ÜEnter¤Ï¡¢Ê¸¾ÏÆþÎϤΤ褦¤ÊÍÑÅӤǻÈÍѤ¹¤ë¤ÈÊØÍø¡£
¢£¥·¥ç¡¼¥È¥«¥Ã¥È¡Ö2¤Ä¤Î¶Ë°Õ¡×
¥·¥ç¡¼¥È¥«¥Ã¥È¤ò¸úΨŪ¤Ë»È¤¤¤³¤Ê¤¹¤¿¤á¤Î¶Ë°Õ¤ò²òÀ⤷¤Þ¤¹¡£°Ê²¼¤ò»²¹Í¤Ë¡¢¤µ¤Ã¤½¤¯Îý½¬¤·¤Æ´·¤ì¤Æ¤¤¤¤Þ¤·¤ç¤¦¡£
¶Ë°Õ¤½¤Î1 ´ðËÜŪ¤Ëº¸¼ê¤À¤±¤ò»È¤¦¤Ù¤·
Ctrl¡¢Shift¡¢Alt¤È¤¤¤Ã¤¿½¤¾þ¥¡¼¤È¡¢ÁȤ߹ç¤ï¤»¤ë¥í¡¼¥Þ»ú¥¡¼¤Ï¡¢º¸¼ê¦¤Ë½¸Ã椷¤Æ¤¤¤Þ¤¹¡£¤½¤Î¤¿¤á¡¢º¸¼ê¤À¤±¤Ç²¡¤»¤ë¤è¤¦¤Ë¤Ê¤ë¤È¡¢±¦¼ê¤Ï¥Þ¥¦¥¹¤òÁàºî¤·¤¿¤ê¡¢¥á¥â¤ò¼è¤Ã¤¿¤ê¤È¤¤¤Ã¤¿ºî¶È¤Ë»È¤¨¤Þ¤¹¡£
¶Ë°Õ¤½¤Î2 ̵°Õ¼±¤Ë»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ë¤Ù¤·
ËÜÅö¤Ë¹Í¤¨¤ë¤Ù¤»öÊÁ¤ËƬ¤È»þ´Ö¤ò»È¤¦¤¿¤á¤Ë¡¢ÁàºîÉôʬ¤ËÅö¤¿¤ë¥·¥ç¡¼¥È¥«¥Ã¥È¤Ï̵°Õ¼±¤Ë»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤ç¤¦¡£
¥·¥ç¡¼¥È¥«¥Ã¥È¤Î³Ð¤¨Êý¤Ë¤Ï¡¢°Ê²¼¤Î¤è¤¦¤Ê¥³¥Ä¤¬¤¢¤ê¤Þ¤¹¡£
¢ºî¶ÈÃæ¤Ë·«¤êÊÖ¤·Æ±¤¸¥·¥ç¡¼¥È¥«¥Ã¥È¤ò»È¤¤¡¢ÂΤ˳Ф¨¤µ¤»¤ë
£1½µ´Ö¤Û¤É»È¤¤Â³¤±¤ë¤È¡¢¼«Á³¤Ë¼ê¤¬Æ°¤¯¤è¤¦¤Ë¤Ê¤ë
¤½¤³¤Þ¤ÇÎý½¬¤·¤Æ¤â³Ð¤¨¤é¤ì¤Ê¤¤¤Ê¤é¡¢¤¢¤Þ¤ê»È¤ï¤Ê¤¤¥·¥ç¡¼¥È¥«¥Ã¥È¤ÈȽÃǤ·¤Æ¤â¤¤¤¤¤Ç¤·¤ç¤¦¡£
----------
±©ÌÓÅÄ ËÓÅڡʤϤ±¤¿¡¦¤Þ¤³¤È¡Ë
¸øǧ²ñ·×»Î¡¢¥¨¥¯¥»¥ë¹Ö»Õ
±©ÌÓÅÄËÓÅÚ¸øǧ²ñ·×»Î¡¦ÀÇÍý»Î»ö̳½ê½êĹ¡£¥¢¥¯¥È¡¦¥³¥ó¥µ¥ë¥Æ¥£¥ó¥°Âåɽ¼Ò°÷¡£ÅìµþÂç³ØÍý³ØÉô¿ô³Ø²Ê¤ò´¶È¸å¡¢¥Ç¥í¥¤¥È¥È¡¼¥Þ¥Ä¥³¥ó¥µ¥ë¥Æ¥£¥ó¥°¡Ê¸½¥¢¥Ó¡¼¥à¥³¥ó¥µ¥ë¥Æ¥£¥ó¥°¡Ë¡¢´ÆººË¡¿Í¥È¡¼¥Þ¥Ä¡Ê¸½Í¸ÂÀÕǤ´ÆººË¡¿Í¥È¡¼¥Þ¥Ä¡Ë¶Ð̳¤ò·Ð¤ÆÆÈΩ¡£¸½ºß¤Ï¡¢¥¨¥¯¥»¥ë¤Î¸¦½¤¤ò¹Ô¤¦¤Û¤«¡¢¥¨¥¯¥»¥ëVBA¤äGAS¤Î¥×¥í¥°¥é¥à³«È¯¤Ê¤É¤â¹Ô¤Ã¤Æ¤¤¤ë¡£Ãø½ñ¤Ë¡Ø´Ø¿ô¤Ï¡Ö»È¤¨¤ë½ç¡×¤Ë¶Ë¤á¤è¤¦¡ªExcel ºÇ¹â¤Î³Ø¤ÓÊý¡Ù¡Ê¥¤¥ó¥×¥ì¥¹¡Ë¤Ê¤É¤¬¤¢¤ë¡£
----------
----------
¤¢¤¤Ð¤µ¤ä¤«¥¤¥é¥¹¥È¥ì¡¼¥¿¡¼
µÜ¾ë¸©½Ð¿È¡¢ÅìµþÅԺ߽»¡£ÀçÂæ¤Î¹¹ðÂåÍýŹ¤Ç¡¢5ǯ´Ö´ë²è±Ä¶È¤È¤·¤Æ¶Ð̳¸å¡¢¥¤¥é¥¹¥È¥ì¡¼¥¿¡¼¤Ë¡£2015ǯ¤«¤éÆȿȲñ¼Ò°÷»þÂå¤Î¤·¤¯¤¸¤êÂ賤ò¤â¤È¤Ë¤·¤¿4¥³¥ÞÌ¡²è¡Ö¤·¤¯¤¸¤ê¥ä¥Þ¥³¡×¤òSNS¾å¤Çȯ¿®¡£Æ¯¤¯½÷À¤òÃæ¿´¤Ë¶¦´¶¤ò¸Æ¤Ö¡£¸½ºß¤Ï·ëº§¡¦½Ð»º¤·¡¢»Å»ö¤È°é»ù¤ÎξΩ¤ËʳƮÃæ¡£¤½¤ó¤ÊÆü¡¹¤ÎÍͻҤò¥Ö¥í¥°¤Ç¤â¹¹¿·¤·¤Æ¤¤¤ë¡£Ãø½ñ¤Ë¡ØÉþ¤Ï¤¢¤ë¤Î¤Ë¥¥Þ¤é¤Ê¤¤¡ª¡Á¤ª¤·¤ã¤ìÌ»Ҷ¦´¶·ÏÆüµ¡Á¡Ù¡¢¡Ø¤ª¤·¤ã¤ì¤Ê¥Þ¥Þ¤Ã¤Æ¤¤¤ï¤ì¤¿¤¤¡ª¡Ù¡Ê¤È¤â¤Ë¥Þ¥¤¥Ê¥Ó½ÐÈǡˤʤɤ¬¤¢¤ë¡£
----------
¡Ê¸øǧ²ñ·×»Î¡¢¥¨¥¯¥»¥ë¹Ö»Õ ±©ÌÓÅÄ ËÓÅÚ¡¢¥¤¥é¥¹¥È¥ì¡¼¥¿¡¼ ¤¢¤¤Ð¤µ¤ä¤«¡Ë