Excel¤ÇÏ¢È֤Ϥ⤦¿¶¤êľ¤µ¤Ê¤¤¡ª¡¡ROW´Ø¿ô¡¢COLUMN´Ø¿ô¤ÎÊØÍø¤Ê»È¤¤Êý
Excel¤Ç¥ê¥¹¥È¤òºî¤ë¤È¤¡¢Ï¢ÈÖ¤ò¿¶¤ë¤³¤È¤Ï¤è¤¯¤¢¤ë¡£
Ï¢ÈÖ¤ò¿¶¤ë¤Î¤Ï´Êñ¤À¡£ÀèƬ¤Î¥»¥ë¤Ë¡Ö1¡×¤òÆþÎϤ·¡¢¡ÎCtrl¡Ï¥¡¼¤ò²¡¤·¤Ê¤¬¤é¥ª¡¼¥È¥Õ¥£¥ë¥Ï¥ó¥É¥ë¤ò¥É¥é¥Ã¥°¤¹¤ì¤Ð¤è¤¤¡£
¤·¤«¤·¡¢¤¢¤È¤«¤é¹Ô¤Îºï½ü¤ä°ÜÆ°¤ò¤¹¤ë¤È¡¢¤½¤ÎÏ¢È֤Ϥޤ¿¿¶¤êľ¤·¤È¤Ê¤Ã¤Æ¤·¤Þ¤¦¡£
ÉÑÈˤ˽¤Àµ¤¹¤ë¥ê¥¹¥È¤Ê¤é¡¢Ï¢ÈÖ¤ÎÎó¤Ë¤ÏROW´Ø¿ô¤òÀßÄꤷ¤è¤¦¡£
ROW´Ø¿ô¤Ï¹ÔÈÖ¹æ¤òÊÖ¤¹´Ø¿ô¤À¡£
½ñ¼°¤â¡Ö=ROW()¡×¤È¡¢»ê¤Ã¤Æ¥·¥ó¥×¥ë¤Ç¼êÆþÎϤ⤷¤ä¤¹¤¤¡£
¡ü¡Ö¹âÅ٤ʸ¡º÷¡×¤ÇÁ´³Ñ¿ô»ú¤òÁªÂò¤¹¤ë
ROW´Ø¿ô¤Ï¡¢¤â¤Á¤í¤ó¡¢´Ø¿ô¤ÎÁÞÆþ¥Ü¥¿¥ó¤«¤éÆþÎϤ·¤Æ¤â¤è¤¤¡£¤À¤¬¡¢Ã»¤¤´Ø¿ô¤Ê¤Î¤Ç¡¢Ä¾ÀÜÆþÎϤ·¤¿¤Û¤¦¤¬Áᤤ¤À¤í¤¦¡£
Ï¢ÈÖ¤ò¿¶¤ê¤¿¤¤ÀèƬ¤Î¥»¥ë¤ò¥¯¥ê¥Ã¥¯¤·¤¿¤é¡¢¡Ö=ROW()¡×¤ÈÆþÎϤ¹¤ë¡£
¤â¤Á¤í¤ó¡¢¾®Ê¸»ú¤Ç¤â¤«¤Þ¤ï¤Ê¤¤¡£
¥«¥Ã¥³¤ÎÃæ¤Ë¤Ï¹ÔÈÖ¹æ¤òµá¤á¤¿¤¤¥»¥ë¡¢¤Þ¤¿¤Ï¥»¥ëÈϰϤòÆþ¤ì¤ë¤Î¤À¤¬¡¢¤³¤³¤Ï¾Êά¤â²Äǽ¤À¡£¾Êά¤¹¤ë¤È¡¢¤½¤Î´Ø¿ô¤¬ÆþÎϤµ¤ì¤Æ¤¤¤ë¥»¥ë¤Î¹ÔÈÖ¹æ¤òɽ¼¨¤·¤Æ¤¯¤ì¤ë¡£
Î㤨¤Ð¥»¥ë¡ÖA1¡×¡¢¤Ä¤Þ¤ê¡¢1¹ÔÌܤˡÖ=ROW()¡×¤ÈÆþÎϤ¹¤ì¤Ð¡¢¡Ö1¡×¤Èɽ¼¨¤·¤Æ¤¯¤ì¤ë¡£
¤¿¤À¡¢1¹ÔÌܤ«¤é¤¤¤¤Ê¤êÏ¢ÈÖ¤ò¿¶¤ë¤è¤¦¤Êɽ¤Ï¾¯¤Ê¤¤¡£1¹ÔÌܤˤÏɽ¤Î¥¿¥¤¥È¥ë¤òÆþÎϤ·¤¿¤ê¡¢É½¤Î¸«½Ð¤·¹Ô¤òºîÀ®¤·¤¿¤ê¤¹¤ë¤³¤È¤¬¤Û¤È¤ó¤É¤À¤í¤¦¡£
¤³¤³¤Ç¤Ï¡¢¥»¥ë¡ÖA4¡×¤òÀèƬ¤Ë¡¢AÎó¤ËÏ¢ÈÖ¤ò¿¶¤Ã¤Æ¤¤¤³¤¦¡£
¥»¥ë¡ÖA4¡×¤Ï4¹ÔÌÜ¡£4¹ÔÌܤˡÖ1¡×¤Èɽ¼¨¤µ¤»¤·¤¿¤¤¡£¤Ä¤Þ¤ê¡¢¹ÔÈÖ¹æ¤è¤ê¤â3¤Ä¾¯¤Ê¤¤¿ô¤òɽ¼¨¤µ¤»¤¿¤¤¡£
¤½¤Î¤¿¤á¡¢¡Ö=ROW()-3¡×¤ÈÆþÎϤ¹¤ë¡£
¡ÎEnter¡Ï¥¡¼¤ò²¡¤¹¤È¡¢¡Ö1¡×¤¬É½¼¨¤µ¤ì¤ë¡£
¥»¥ë¡ÖA4¡×¤Î¥ª¡¼¥È¥Õ¥£¥ë¥Ï¥ó¥É¥ë¤ò¥É¥é¥Ã¥°¤·¤Æ¡¢´Ø¿ô¤ò¥³¥Ô¡¼¤·¤è¤¦¡£
Ï¢ÈÖ¤¬É½¼¨¤µ¤ì¤ë¡£
Ï¢ÈÖ¤¬¿¶¤é¤ì¤¿¤é¡¢No.4¤ÈNo.5¤Î¹Ô¤òºï½ü¤·¤Æ¤ß¤è¤¦¡£
ºï½üÁ°¤Î²¼¿Þ¤Ç¡¢ºÇ¸å¤ÎNo.10¤¬13¹ÔÌܤˤ¢¤ë¤³¤È¤ò³Îǧ¤·¤Æ¤Û¤·¤¤¡£
¹Ô¤òÁªÂò¤·¤Æ¡¢¡Î¥Û¡¼¥à¡Ï¥¿¥Ö¤Î¡Îºï½ü¡Ï¡Ý¡Î¥·¡¼¥È¤Î¹Ô¤òºï½ü¡Ï¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¡£
2¹Ôºï½ü¤µ¤ì¡¢No.8¤Þ¤Ç¤Îɽ¤È¤Ê¤Ã¤¿¡£
No.4¤ÈNo.5¤òºï½ü¤·¤¿¤¬¡¢´Ø¿ô¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤Ç¡¢Ï¢ÈÖ¤ÏÊÝ»ý¤µ¤ì¤Æ¤¤¤ë¡£
¤¿¤À¤·¡¢¹Ô¤òÁÞÆþ¤·¤¿¤È¤¤Ï¡¢AÎó¤Ë´Ø¿ô¤ò¥³¥Ô¡¼¤¹¤ëɬÍפϤ¢¤ë¡£
¤·¤«¤·¡¢¤½¤ì¤â¥ª¡¼¥È¥Õ¥£¥ë¥Ï¥ó¥É¥ë¤Ç¥É¥é¥Ã¥°¤¹¤ì¤Ð´Êñ¤À¡£
¤Á¤Ê¤ß¤Ë¡¢¡ÖK001¡×¡ÖK002¡×¡ÖK003¡×¡Ä¤Î¤è¤¦¤Ë¡¢Ê¸»ú¤ä¿ô»ú¤òÁȤ߹ç¤ï¤»¤¿Ï¢È֤ˤ·¤¿¤¤¤È¤¤Ï¡¢¡Ö&¡Ê¥¢¥ó¥Ñ¥µ¥ó¥É¡Ë¡×¤ò»È¤¦¤È¤è¤¤¡£
Î㤨¤Ð¡¢¥»¥ë¡ÖA4¡×¤Ë¡ÖK001¡×¤Èɽ¼¨¤·¤¿¤¤¤Ê¤é¡¢¼¡¤Î¤è¤¦¤ËÆþÎϤ¹¤ë¡£
="K00"&(ROW()-3)
¡ÖK00¡×¤ò¡Ö¡É¡Ê¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó¡Ë¡×¤Ç°Ï¤ó¤Çʸ»úÎó¤È¤·¡¢¡Ö&¡×¤ÇROW´Ø¿ô¤ÎÃͤÈÏ¢·ë¤¹¤ë¤Î¤À¡£
¡Ö&¡×¤Ï¥Æ¥¥¹¥ÈÏ¢·ë±é»»»Ò¤È¸Æ¤Ð¤ì¤ë¤â¤Î¤Ç¡¢
¥»¥ë¡ÖA1¡×¤Ë¡ÖÅìµþÅԡס¢¥»¥ë¡ÖA2¡×¤Ë¡Ö¿·½É¶è¡×¤ÈÆþÎϤµ¤ì¤Æ¤¤¤ë¤È¤¡¢
¥»¥ë¡ÖA3¡×¤Ë¡¢
=A1&A2
¤ÈÆþÎϤ¹¤ì¤Ð¡¢¡ÖÅìµþÅÔ¿·½É¶è¡×¤ÈÊÖ¤·¤Æ¤¯¤ì¤ë¡£
¤³¤¦¤·¤¿±é»»»Ò¤â¡¢³Ð¤¨¤Æ¤ª¤¯¤È²¿¤«¤ÈÊØÍø¤À¡£
¡üÎóÈÖ¹æ¤òÊÖ¤¹COLUMN´Ø¿ô
ROW´Ø¿ô¤Ï¡¢¤³¤Î¤è¤¦¤Ë½ÄÊý¸þ¤ÎÏ¢È֤˻Ȥ¨¤ë¡£
¤Ç¤Ï¡¢²£Êý¸þ¤Ê¤é¤É¤¦¤À¤í¤¦¡£
Excel¤Ë¤ÏÎóÈÖ¹æ¤òÊÖ¤¹´Ø¿ô¤â¡¢¤â¤Á¤í¤óÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë¡£
¥»¥ë¡ÖB2¡×¤ò¡Ö1¡×¤È¤·¡¢²£Êý¸þ¤ØÏ¢ÈÖ¤ò¿¶¤ê¤¿¤¤¤È¤¤Ï¡¢¥»¥ë¡ÖB2¡×¤Ë¼¡¤Î¤è¤¦¤ËÆþÎϤ¹¤ë¡£
=COLUMN()-1
BÎó¤Ï2ÈÖÌܤÎÎó¤Ê¤Î¤Ç¡¢¡Ö-1¡×¤òÆþÎϤ·¤Æ¡¢¡Ö1¡×¤ÈÊÖ¤¹¤è¤¦¤Ë»ØÄꤹ¤ë¤Î¤À¡£
¥ª¡¼¥È¥Õ¥£¥ë¥Ï¥ó¥É¥ë¤ò¥É¥é¥Ã¥°¤·¤Æ¡¢¿ô¼°¤ò²£Êý¸þ¤Ë¥³¥Ô¡¼¤¹¤ì¤Ð¡¢Îó¤Îºï½ü¤ä°ÜÆ°¤ò¤·¤Æ¤â¡¢ÎóÈÖ¹æ¤ò¿¶¤êľ¤¹É¬ÍפΤʤ¤É½¤¬¤Ç¤¤¢¤¬¤ë¡£
ROW´Ø¿ô¤âCOLUMN´Ø¿ô¤â¡¢´Êñ¤ËÆþÎϤǤ¤ë¡£
Ï¢ÈÖ¤ò»È¤¦É½¤òºîÀ®¤¹¤ë¤È¤¤Ë¤Ï¡¢¤¼¤Ò¡¢»î¤·¤Æ¤Û¤·¤¤¡£
¼¹É®¡¡ÃæÌî µ×Èþ»Ò
Ï¢ÈÖ¤ò¿¶¤ë¤Î¤Ï´Êñ¤À¡£ÀèƬ¤Î¥»¥ë¤Ë¡Ö1¡×¤òÆþÎϤ·¡¢¡ÎCtrl¡Ï¥¡¼¤ò²¡¤·¤Ê¤¬¤é¥ª¡¼¥È¥Õ¥£¥ë¥Ï¥ó¥É¥ë¤ò¥É¥é¥Ã¥°¤¹¤ì¤Ð¤è¤¤¡£
¤·¤«¤·¡¢¤¢¤È¤«¤é¹Ô¤Îºï½ü¤ä°ÜÆ°¤ò¤¹¤ë¤È¡¢¤½¤ÎÏ¢È֤Ϥޤ¿¿¶¤êľ¤·¤È¤Ê¤Ã¤Æ¤·¤Þ¤¦¡£
ÉÑÈˤ˽¤Àµ¤¹¤ë¥ê¥¹¥È¤Ê¤é¡¢Ï¢ÈÖ¤ÎÎó¤Ë¤ÏROW´Ø¿ô¤òÀßÄꤷ¤è¤¦¡£
ROW´Ø¿ô¤Ï¹ÔÈÖ¹æ¤òÊÖ¤¹´Ø¿ô¤À¡£
½ñ¼°¤â¡Ö=ROW()¡×¤È¡¢»ê¤Ã¤Æ¥·¥ó¥×¥ë¤Ç¼êÆþÎϤ⤷¤ä¤¹¤¤¡£
¡ü¡Ö¹âÅ٤ʸ¡º÷¡×¤ÇÁ´³Ñ¿ô»ú¤òÁªÂò¤¹¤ë
ROW´Ø¿ô¤Ï¡¢¤â¤Á¤í¤ó¡¢´Ø¿ô¤ÎÁÞÆþ¥Ü¥¿¥ó¤«¤éÆþÎϤ·¤Æ¤â¤è¤¤¡£¤À¤¬¡¢Ã»¤¤´Ø¿ô¤Ê¤Î¤Ç¡¢Ä¾ÀÜÆþÎϤ·¤¿¤Û¤¦¤¬Áᤤ¤À¤í¤¦¡£
Ï¢ÈÖ¤ò¿¶¤ê¤¿¤¤ÀèƬ¤Î¥»¥ë¤ò¥¯¥ê¥Ã¥¯¤·¤¿¤é¡¢¡Ö=ROW()¡×¤ÈÆþÎϤ¹¤ë¡£
¤â¤Á¤í¤ó¡¢¾®Ê¸»ú¤Ç¤â¤«¤Þ¤ï¤Ê¤¤¡£
¥«¥Ã¥³¤ÎÃæ¤Ë¤Ï¹ÔÈÖ¹æ¤òµá¤á¤¿¤¤¥»¥ë¡¢¤Þ¤¿¤Ï¥»¥ëÈϰϤòÆþ¤ì¤ë¤Î¤À¤¬¡¢¤³¤³¤Ï¾Êά¤â²Äǽ¤À¡£¾Êά¤¹¤ë¤È¡¢¤½¤Î´Ø¿ô¤¬ÆþÎϤµ¤ì¤Æ¤¤¤ë¥»¥ë¤Î¹ÔÈÖ¹æ¤òɽ¼¨¤·¤Æ¤¯¤ì¤ë¡£
Î㤨¤Ð¥»¥ë¡ÖA1¡×¡¢¤Ä¤Þ¤ê¡¢1¹ÔÌܤˡÖ=ROW()¡×¤ÈÆþÎϤ¹¤ì¤Ð¡¢¡Ö1¡×¤Èɽ¼¨¤·¤Æ¤¯¤ì¤ë¡£
¤¿¤À¡¢1¹ÔÌܤ«¤é¤¤¤¤Ê¤êÏ¢ÈÖ¤ò¿¶¤ë¤è¤¦¤Êɽ¤Ï¾¯¤Ê¤¤¡£1¹ÔÌܤˤÏɽ¤Î¥¿¥¤¥È¥ë¤òÆþÎϤ·¤¿¤ê¡¢É½¤Î¸«½Ð¤·¹Ô¤òºîÀ®¤·¤¿¤ê¤¹¤ë¤³¤È¤¬¤Û¤È¤ó¤É¤À¤í¤¦¡£
¤³¤³¤Ç¤Ï¡¢¥»¥ë¡ÖA4¡×¤òÀèƬ¤Ë¡¢AÎó¤ËÏ¢ÈÖ¤ò¿¶¤Ã¤Æ¤¤¤³¤¦¡£
¥»¥ë¡ÖA4¡×¤Ï4¹ÔÌÜ¡£4¹ÔÌܤˡÖ1¡×¤Èɽ¼¨¤µ¤»¤·¤¿¤¤¡£¤Ä¤Þ¤ê¡¢¹ÔÈÖ¹æ¤è¤ê¤â3¤Ä¾¯¤Ê¤¤¿ô¤òɽ¼¨¤µ¤»¤¿¤¤¡£
¤½¤Î¤¿¤á¡¢¡Ö=ROW()-3¡×¤ÈÆþÎϤ¹¤ë¡£
¡ÎEnter¡Ï¥¡¼¤ò²¡¤¹¤È¡¢¡Ö1¡×¤¬É½¼¨¤µ¤ì¤ë¡£
¥»¥ë¡ÖA4¡×¤Î¥ª¡¼¥È¥Õ¥£¥ë¥Ï¥ó¥É¥ë¤ò¥É¥é¥Ã¥°¤·¤Æ¡¢´Ø¿ô¤ò¥³¥Ô¡¼¤·¤è¤¦¡£
Ï¢ÈÖ¤¬É½¼¨¤µ¤ì¤ë¡£
Ï¢ÈÖ¤¬¿¶¤é¤ì¤¿¤é¡¢No.4¤ÈNo.5¤Î¹Ô¤òºï½ü¤·¤Æ¤ß¤è¤¦¡£
ºï½üÁ°¤Î²¼¿Þ¤Ç¡¢ºÇ¸å¤ÎNo.10¤¬13¹ÔÌܤˤ¢¤ë¤³¤È¤ò³Îǧ¤·¤Æ¤Û¤·¤¤¡£
¹Ô¤òÁªÂò¤·¤Æ¡¢¡Î¥Û¡¼¥à¡Ï¥¿¥Ö¤Î¡Îºï½ü¡Ï¡Ý¡Î¥·¡¼¥È¤Î¹Ô¤òºï½ü¡Ï¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¡£
2¹Ôºï½ü¤µ¤ì¡¢No.8¤Þ¤Ç¤Îɽ¤È¤Ê¤Ã¤¿¡£
No.4¤ÈNo.5¤òºï½ü¤·¤¿¤¬¡¢´Ø¿ô¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤Ç¡¢Ï¢ÈÖ¤ÏÊÝ»ý¤µ¤ì¤Æ¤¤¤ë¡£
¤¿¤À¤·¡¢¹Ô¤òÁÞÆþ¤·¤¿¤È¤¤Ï¡¢AÎó¤Ë´Ø¿ô¤ò¥³¥Ô¡¼¤¹¤ëɬÍפϤ¢¤ë¡£
¤·¤«¤·¡¢¤½¤ì¤â¥ª¡¼¥È¥Õ¥£¥ë¥Ï¥ó¥É¥ë¤Ç¥É¥é¥Ã¥°¤¹¤ì¤Ð´Êñ¤À¡£
¤Á¤Ê¤ß¤Ë¡¢¡ÖK001¡×¡ÖK002¡×¡ÖK003¡×¡Ä¤Î¤è¤¦¤Ë¡¢Ê¸»ú¤ä¿ô»ú¤òÁȤ߹ç¤ï¤»¤¿Ï¢È֤ˤ·¤¿¤¤¤È¤¤Ï¡¢¡Ö&¡Ê¥¢¥ó¥Ñ¥µ¥ó¥É¡Ë¡×¤ò»È¤¦¤È¤è¤¤¡£
Î㤨¤Ð¡¢¥»¥ë¡ÖA4¡×¤Ë¡ÖK001¡×¤Èɽ¼¨¤·¤¿¤¤¤Ê¤é¡¢¼¡¤Î¤è¤¦¤ËÆþÎϤ¹¤ë¡£
="K00"&(ROW()-3)
¡ÖK00¡×¤ò¡Ö¡É¡Ê¥À¥Ö¥ë¥¯¥©¡¼¥Æ¡¼¥·¥ç¥ó¡Ë¡×¤Ç°Ï¤ó¤Çʸ»úÎó¤È¤·¡¢¡Ö&¡×¤ÇROW´Ø¿ô¤ÎÃͤÈÏ¢·ë¤¹¤ë¤Î¤À¡£
¡Ö&¡×¤Ï¥Æ¥¥¹¥ÈÏ¢·ë±é»»»Ò¤È¸Æ¤Ð¤ì¤ë¤â¤Î¤Ç¡¢
¥»¥ë¡ÖA1¡×¤Ë¡ÖÅìµþÅԡס¢¥»¥ë¡ÖA2¡×¤Ë¡Ö¿·½É¶è¡×¤ÈÆþÎϤµ¤ì¤Æ¤¤¤ë¤È¤¡¢
¥»¥ë¡ÖA3¡×¤Ë¡¢
=A1&A2
¤ÈÆþÎϤ¹¤ì¤Ð¡¢¡ÖÅìµþÅÔ¿·½É¶è¡×¤ÈÊÖ¤·¤Æ¤¯¤ì¤ë¡£
¤³¤¦¤·¤¿±é»»»Ò¤â¡¢³Ð¤¨¤Æ¤ª¤¯¤È²¿¤«¤ÈÊØÍø¤À¡£
¡üÎóÈÖ¹æ¤òÊÖ¤¹COLUMN´Ø¿ô
ROW´Ø¿ô¤Ï¡¢¤³¤Î¤è¤¦¤Ë½ÄÊý¸þ¤ÎÏ¢È֤˻Ȥ¨¤ë¡£
¤Ç¤Ï¡¢²£Êý¸þ¤Ê¤é¤É¤¦¤À¤í¤¦¡£
Excel¤Ë¤ÏÎóÈÖ¹æ¤òÊÖ¤¹´Ø¿ô¤â¡¢¤â¤Á¤í¤óÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë¡£
¥»¥ë¡ÖB2¡×¤ò¡Ö1¡×¤È¤·¡¢²£Êý¸þ¤ØÏ¢ÈÖ¤ò¿¶¤ê¤¿¤¤¤È¤¤Ï¡¢¥»¥ë¡ÖB2¡×¤Ë¼¡¤Î¤è¤¦¤ËÆþÎϤ¹¤ë¡£
=COLUMN()-1
BÎó¤Ï2ÈÖÌܤÎÎó¤Ê¤Î¤Ç¡¢¡Ö-1¡×¤òÆþÎϤ·¤Æ¡¢¡Ö1¡×¤ÈÊÖ¤¹¤è¤¦¤Ë»ØÄꤹ¤ë¤Î¤À¡£
¥ª¡¼¥È¥Õ¥£¥ë¥Ï¥ó¥É¥ë¤ò¥É¥é¥Ã¥°¤·¤Æ¡¢¿ô¼°¤ò²£Êý¸þ¤Ë¥³¥Ô¡¼¤¹¤ì¤Ð¡¢Îó¤Îºï½ü¤ä°ÜÆ°¤ò¤·¤Æ¤â¡¢ÎóÈÖ¹æ¤ò¿¶¤êľ¤¹É¬ÍפΤʤ¤É½¤¬¤Ç¤¤¢¤¬¤ë¡£
ROW´Ø¿ô¤âCOLUMN´Ø¿ô¤â¡¢´Êñ¤ËÆþÎϤǤ¤ë¡£
Ï¢ÈÖ¤ò»È¤¦É½¤òºîÀ®¤¹¤ë¤È¤¤Ë¤Ï¡¢¤¼¤Ò¡¢»î¤·¤Æ¤Û¤·¤¤¡£
¼¹É®¡¡ÃæÌî µ×Èþ»Ò