엑셀 숫자 자동 채우기 하는 방법

<p style="text-align: left;"><strong><span style="font-family: Batang,바탕,serif; font-size: 14pt;">엑셀 숫자 자동 채우기 하는 방법</span></strong></p><p style="text-align: left;"><strong><span style="font-family: Batang,바탕,serif; font-size: 14pt;"><br></span></strong></p><span style="font-family: Batang,바탕,serif; font-size: 14pt;"><div style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span><span style="font-family: Batang,바탕,serif; font-size: 12pt;">엑셀을 통해 숫자를 자동으로 채울 수 있습니다.</span></span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">같은 값의 숫자를 자동으로 채울 수도 있고</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">숫자 값이 증가하도록 채울 수도 있습니다.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">또한 숫자 값이 반복되어 자동으로 채워지도록</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">자동으로 채울 수도 있습니다.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><br></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">엑셀의 아주 기본적인 내용이긴 한데요.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">엑셀을 사용한지 얼마 되지 않은 분들은</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">이 내용을 모를 수도 있겠다고 생각하여</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">포스팅을 작성하게 되었습니다.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><br></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">먼저 1 이라는 숫자를 입력하고 검은색 네모로</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">표시를 해 놓은 셀의 모서리 부분을 밑으로 쭉</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">드래그 해보겠습니다. 이렇게 하면 1이라는 값이</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">반복해서 채워집니다.</span><strong><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span></strong></span></div><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span></span><p style="text-align: left;"><br></p><div style="text-align: center;"><p> <span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span></p><p style="text-align: left;"><img src="https://t1.daumcdn.net/cfile/cafe/99A913435D070C4D27" class="txc-image" width="386" style="clear: none; float: none;" border="0" vspace="1" hspace="1" actualwidth="386" exif="{}" data-filename="1.png" id="A_99A913435D070C4D27B470"/></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 12pt;"><span style="font-family: Batang,바탕,serif;"></span><span style="font-family: Batang,바탕,serif;">이번에는 키보드의 CTRL 키를 누르고 드래그 </span></span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">해보겠습니다. 먼저 B3에 해당하는 1을 선택합니다.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">그리고 키보드의 CTRL 키를 누른 상태로 모서리 부분을</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">아래로 쭉 드래그 해줍니다. 이렇게 하면 숫자가 하나씩</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 12pt;"><span style="font-family: Batang,바탕,serif;">증가하여 자동으로 채워지는 것을 볼 수 있습니다.</span><span style="font-family: Batang,바탕,serif;"></span></span></div><div style="text-align: center; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"><br></span></div><p><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span></p><p style="text-align: left;"><img src="https://t1.daumcdn.net/cfile/cafe/994EC9435D070C4D20" class="txc-image" width="386" style="clear: none; float: none;" border="0" vspace="1" hspace="1" actualwidth="386" exif="{}" data-filename="2.png" id="A_994EC9435D070C4D2036EB"/></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span><span style="font-family: Batang,바탕,serif; font-size: 12pt;">이번에도 마찬가지로 숫자가 1씩 증가하여 자동으로</span></span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">채워지는 패턴인데요. 위와 다른 방식으로 할 수 있습니다.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">B3에는 숫자1을, B4에는 숫자2를 입력합니다.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">그리고 B3, B4를 선택하고 모서리 부분을 밑으로</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">쭉 드래그 해줍니다. 이렇게 해도 숫자가 1씩 증가</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">하는 것을 볼 수 있습니다.</span></span></div><div style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span><span style="font-family: Batang,바탕,serif; font-size: 12pt;"><br></span></span></div><p style="text-align: left;"><br></p><p><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span></p><p style="text-align: left;"><img src="https://t1.daumcdn.net/cfile/cafe/992B59435D070C4D22" class="txc-image" width="386" style="clear: none; float: none;" border="0" vspace="1" hspace="1" actualwidth="386" exif="{}" data-filename="3.png" id="A_992B59435D070C4D22093A"/></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span><span style="font-family: Batang,바탕,serif; font-size: 12pt;">값을 반복해서 자동으로 채우기 할 수도 있습니다.</span></span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">B열에는 2, 4가 반복해서 채워져 있고 </span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">C열에는 6, 7이 반복해서 채워져 있습니다.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">여기서 B열에는 2와 4를 반복하고</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">C열에서는 6과 7을 반복해서 자동으로 채우고 싶으면</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">숫자 2, 4, 6, 7을 선택하고 키보드의 CTRL 키를 누른</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">상태에서 모서리 부분을 아래로 쭉 드래그 해주면 </span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">숫자가 반복해서 자동으로 채워지게 됩니다.</span></div><p style="text-align: left; line-height: 1.5;"><span style="font-family: Tahoma; font-size: 11pt;"></span></p><div style="text-align: left; line-height: 1.5;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;"><br></span></div><p><span style="font-family: Batang,바탕,serif; font-size: 12pt;"></span></p><p style="text-align: left;"><img src="https://t1.daumcdn.net/cfile/cafe/99AD1C435D070C4D1B" class="txc-image" width="386" style="clear: none; float: none;" border="0" vspace="1" hspace="1" actualwidth="386" exif="{}" data-filename="4.png" id="A_99AD1C435D070C4D1B30C1"/></p><p style="text-align: left;"><span style="font-family: Batang,바탕,serif; font-size: 12pt;"><br></span> <a style="text-decoration: none;" href="http://cafe.daum.net/jhjmj061/SURu/124" target="_blank"><span style="font-family: Batang,바탕,serif; font-size: 12pt;">청년,주부,퇴직자의 꿈의직업-현장관리인,대리인  </span></a></p></div><p><br></p>