[엑셀] 열 또는 행을 단축키로 숨기기

[엑셀] 열 또는 행을 단축키로 숨기기 <table cellpadding="0" cellspacing="0" height="112" width="349" border="0" style="border-collapse:collapse;border:none"> <tr height="28"> <td bgcolor="yellow" width="39" height="28" style="border-top:solid black .75pt;border-left:solid black .75pt;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td bgcolor="yellow" width="39" style="border-top:solid black .75pt;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> A</td> <td bgcolor="yellow" width="39" style="border-top:solid black .75pt;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> B</td> <td bgcolor="yellow" width="39" style="border-top:solid black .75pt;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> C</td> <td bgcolor="yellow" width="39" style="border-top:solid black .75pt;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> D</td> <td bgcolor="yellow" width="39" style="border-top:solid black .75pt;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> E</td> <td bgcolor="yellow" width="39" style="border-top:solid black .75pt;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> F</td> <td bgcolor="yellow" width="39" style="border-top:solid black .75pt;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> G</td> <td bgcolor="yellow" width="39" style="border-top:solid black .75pt;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> H</td></tr> <tr height="28"> <td bgcolor="yellow" width="39" height="28" style="border-top:none;border-left:solid black .75pt;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> 1</td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td></tr> <tr height="28"> <td bgcolor="yellow" width="39" height="28" style="border-top:none;border-left:solid black .75pt;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> 2</td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td bgcolor="#ffcc99" width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> D2</td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td></tr> <tr height="28"> <td bgcolor="yellow" width="39" height="28" style="border-top:none;border-left:solid black .75pt;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt"> 3</td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td> <td width="39" style="border-top:none;border-left:none;border-bottom:solid black .75pt;border-right:solid black .75pt;padding:2.7pt 2.7pt 2.7pt 2.7pt">  </td></tr> </table>   D2 하나의 셀을 선택한 경우   1. D2 셀에서 (D) 열을 숨길려면  CTRL 누른 상태에서 0 (영,문자쪽) 를 누른다.   2. D2 셀에서 (2번) 행을 숨길려면  CTRL 누른 상태에서 9 (아홉,문자쪽) 를 누른다.   3. 되돌리기는 CTRL 누른 상태에서 Z 를 누른다.   ** 여러 셀을 선택한 경우에는 선택된 열 또는 행이 숨겨진다. ** 간단하지만 시험에 잘나오는 것입니다.