태그

2015년 8월 26일 수요일

엑셀 단축키 - 시트 관련


엑셀 단축키 - 시트 관련
시트이동, 시트복사, 시트삭제, 시트이름바꾸기...
SHIFT+F11 or ALT+SHIFT+F1
Insert a new worksheet.

CTRL+PAGE DOWN
Move to the next sheet in the workbook.

CTRL+PAGE UP
Move to the previous sheet in the workbook.

SHIFT+CTRL+PAGE DOWN
Select the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP.

SHIFT+CTRL+PAGE UP
Select the current and previous sheet.

ALT+O H R
Rename the current sheet (Format menu, Sheet submenu, Rename command). 
ALT+E M
Move or copy the current sheet (Edit menu, Move or Copy Sheet command).

ALT+E L
Delete the current sheet (Edit menu, Delete Sheet command). 

댓글 없음:

댓글 쓰기