Microsoft Excel 은 전문적으로 또는 일상 생활에서 스프레드시트와 데이터를 다루는 모든 사람을 돕기 위해 개발된 다목적 소프트웨어입니다. 데이터를 구성하고 저장할 수 있으며 공식과 함수를 사용하여 복잡한 수학 계산 을 수행할 수 있습니다. ^{(mathematical calculations)}더욱 멋진 점은 Excel 이 ^(Excel)파이 차트^{(pie charts)} , Gantt 차트^{(Gantt charts)} , 순서도^(flowcharts) 및 상상할 수 있는 거의 모든 유형의 차트를 통해 데이터와 프로젝트를 시각화하는 데 도움이 될 수 있다는 것입니다.

Microsoft Excel 은 원래 데이터 입력을 염두에 두고 개발되었지만 그 이후로 소프트웨어는 회계, 작업 관리 및 재무 모델링에서 이벤트 프로그래밍에 이르기까지 모든 것을 수용하도록 성장했습니다. 즉, 가장 단순한 소프트웨어가 아닙니다. Excel 에서 효율적으로 작업하려면 바로 가기 키를 사용해야 하며 이것이 이 기사에서 중점적으로 다룰 것입니다.

키보드 단축키가 필요한 이유는 무엇입니까?

Microsoft Excel 이 무엇인지 알고 과거에 광범위하게 사용했더라도 빠르고 효율적으로 작업하는 데 사용할 수 있는 모든 기능과 바로 가기에 여전히 놀랄 수 있습니다. Excel 에는 수백 가지의 바로 가기와 키 입력 조합이 있지만 모두 외울 필요는 없으므로 걱정하지 마십시오.

일부 Excel 바로 가기는 다른 것보다 더 자주 사용합니다. 따라서 매일 필요한 가장 중요한 것들에 집중합시다.

자주 사용하는 엑셀 단축키

대부분의 Windows 10/11 및 Microsoft Office^{(Microsoft Office)} 앱 에서 일반적으로 사용되는 몇 가지 바로 가기에 대해 잘 알고 있을 것입니다 . 그럼에도 불구하고 스프레드시트에 대한 숙달을 빠르게 향상시키기 위해 시작해야 하는 가장 일반적으로 사용되는 Excel 키보드 단축키가 포함된 유용한 표가 있습니다.^(Excel)

Ctrl+A	Select all
Ctrl+C	Copy
Ctrl+V	Paste
Ctrl+X	Cut
Ctrl+Z	Undo
Ctrl+Y	Redo
Ctrl+B	Bold
Ctrl+I	Italicize
Ctrl+U	Underline
Alt+H	Go to the Home tab
Delete (or DEL)	Remove content in the cell
Ctrl+O	Open a workbook
Ctrl+W	Close a workbook
Alt+H+H	Choose a color to fill the cell

이러한 바로 가기는 편리하며 Excel^(Excel) 뿐만 아니라 Microsoft Word , 인터넷 브라우저^{(internet browsers)} 또는 비즈니스 또는 레저용으로 자주 사용하는 기타 앱 에서도 사용하는 데 익숙해져야 합니다 .

Excel의 피벗 테이블 바로 가기

피벗 테이블^{(Pivot Table)} 은 Excel 의 강력한 도구입니다 . 스프레드시트에서 선택한 행과 열을 요약하거나 재구성할 수도 있습니다. 피벗 테이블은 요약해야 하는 긴 데이터 행이 있는 경우 편리하며 데이터를 비교할 수도 있습니다. 많은 피벗 테이블을 사용하는 경우 아래의 바로 가기를 정기적으로 사용하십시오.

Right-click	Access the context menu for the selected row, column, or cell.
Ctrl+D	Delete the table
Ctrl+M	Move the table
Ctrl+R	Rename the table
Alt+Shift+Right Arrow	Group the pivot table items you selected
Alt+Shift+Left Arrow	Ungroup the pivot table items you selected

이제 기본 단축키를 알았으므로 생산성과 속도를 높이는 다른 Excel 키보드 단축키에 집중하겠습니다.^(Excel)

Excel에서 탐색을 위한 바로 가기

^(Navigate)다음 키보드 단축키를 사용 하여 Excel 을 ^(Excel)탐색 하고 워크시트 탭 간에 더 빠르게 전환할 수 있습니다.

Ctrl+Page Up	Press this command combination to switch the worksheet tabs to the right.
Ctrl+Page Down	This command will switch the worksheet tabs to the left.
Ctrl+Backspace	This shortcut will show you which cell is active.
F11	The F11 key will create a new chart. It is an amazing shortcut that will allow you to skip all the navigation through Excel’s toolbar.
Ctrl+F	Press this combination of keys to quickly access the find function.
Ctrl+Q	Quickly access the Help function in Excel.
Ctrl+Arrow Key	Go to the last populated cell in the direction of the arrow key. For example, Ctrl+Right Arrow will send you to the last cell to the right, while Ctrl+Down Arrow will select the last cell at the bottom.
Ctrl+F12	This command quickly opens the “open file” dialog and allows you to access another workbook.
Ctrl+F1	This combination of keys will toggle the display of ribbons.

^(Shortcuts)Excel 에서 항목^(Items) 선택을 위한 바로 가기

복잡한 마우스 움직임 대신 다음 키보드 단축키를 사용하여 열과 행을 더 빠르게 선택하여 시간을 절약하십시오.

Ctrl+Spacebar	Press Ctrl+Space to select the entire column. You will no longer need to use the header and navigate with your mouse.
Shift+Spacebar	Press Shift+Space to select the whole row.
Ctrl+0	This simple shortcut will hide all the selected columns.

^(Shortcuts)Excel 의 함수^(Functions) 및 수식 ^(Formulas)바로 가기^(Excel)

Excel 은 주로 수식과 함수에 관한 것입니다. 변수별로 입력하는 것을 중단 하고 아래 키보드 단축키를 사용하여 생산성을 높이십시오.^(Stop)

Ctrl+’	Switch between displaying all the formulas in your worksheet. Also, you can click on the cell to have the formula shown in the formula bar.
Ctrl+Alt+F9	Use this shortcut when you need to calculate all the formulas inside all of your active workbooks.
Ctrl+Shift+$	To automatically change a cell into the currency format, you must select it and press Ctrl+Shift+$. It can also work on multiple cells as long as they are selected.
Ctrl+Shift+%	This shortcut applies the percentage format to the selected cell.
Alt+=	This shortcut will automatically insert the SUM() function. This is possibly the most used formula in Excel, and having a shortcut for it is a must. The Sum() function auto-sums the data of multiple columns and rows. Just make sure to select one extra column on the right side and one extra row on the bottom. Excel will use these to display the summation data.
Alt+H+O+I	This shortcut is a combination of keystrokes that will complete a function in a sequence. First, hit Alt+H to select the Home tab, then hit the O while still holding the Alt key to select the format menu. Finally, hit the I to autofit the width of the column. Remember to keep your finger on Alt while pressing each letter.
Ctrl+[	This shortcut allows you to see what cells are referenced in other cells. It is especially useful if you are working with complex formulas.
Ctrl+Shift+J	Use this shortcut to see a list of all the constants in your worksheet.
Alt+M	Open the formulas tab.
Shift+F3	Prest Shift+F3 to open the insert function window to insert a function.

Excel의 시간 및 날짜 바로 가기

^(Log)아래의 시간 및 날짜 키보드 단축키를 사용하여 다양한 활동을 즉시 기록하십시오 .

Ctrl+Shift+#	This shortcut will allow you to change the date format.
Ctrl+Shift+@	Hitting the combination of these keys will allow you quick access to the time of day style. From here, you can proceed and add it to the selected cell.
Ctrl+;	Do you want to add the current date to the Excel spreadsheet? Simply hit this shortcut to add it quickly.
Ctrl+Shift+;	This function will place the exact current time in the selected cell.

Excel에서 바로 가기 편집

셀, 행, 열 및 주석을 편집하는 데 시간이 매우 많이 소요될 수 있습니다. 다음 단축키로 속도를 높이세요.

Ctrl+1	Open the format cell dialog box. This shortcut will allow you to make changes to the cell’s appearance.
Ctrl+K	If you select a cell or the data entered in the cell and use this shortcut, a hyperlink box will open. Copy and paste the hyperlink into the box (using the copy/paste shortcuts for extra practice).
F2	This must be one of the most used Excel shortcuts as it will allow you to edit the cell. Use it to make quick changes.
F4	The F4 key will repeat your last action. Be it a formula or an edit, this key will copy the action and save you a lot of time.
Ctrl+Plus Character (+)	Insert new rows and columns quickly with the Ctrl shortcut.
Ctrl+Minus Character (-)	Press Ctrl+- to delete a row or a column.
Shift+F2	Insert a comment or edit an existing comment in a selected cell.

Excel에서 서식 바로 가기

Excel 데이터 의 서식을 지정 하면 읽기 쉽고 표시할 수 있습니다. 하지만 그렇다고 해서 시간을 낭비해야 하는 것은 아니므로 아래 단축키를 사용하여 시작하세요.

Ctrl+Shift+&	This Excel shortcut quickly applies borders to the selected cell. This is very helpful if you want to keep your spreadsheet neatly organized and visually appealing.
Ctrl+Shift+_	To quickly remove the borders, select the desired cells and hit this combination of keys.
Ctrl+Shift+~	This combination of keys will style a selected cell or a group of cells into a general format. Keep in mind the general format is the default format, meaning you get the numbers you type and nothing else.
Ctrl+Shift+^	This command applies the exponential format to the cell you select.
Ctrl+Shift+!	This shortcut applies the comma formatting style to the selected cell. For example, when the number in the cell goes over 1000, this command will display it with a comma as 1,000. Use this shortcut to visualize numbers.

스프레드시트 마스터이든 파란 달에 한 번 Excel 을 사용하든 상관없이 몇 가지 단축키를 알면 작업이 훨씬 쉽고 시간이 덜 걸립니다. 아래 댓글에 자주 사용하는 Excel 키보드 단축키와 콤보를 공유하세요 !

The 40 Best Microsoft Excel Keyboard Shortcuts

Microsoft Excel is a versatile software developed to help everyone who deals with spreadsheets and data professionally or in their day-to-day lives. It allows you to organize and store your data, and it can perform complex mathematical calculations using formulas and functions. What’s even cooler is that Excel can also help you visualize your data and projects through pie charts, Gantt charts, flowcharts, and pretty much every type of chart you can imagine.

Microsoft Excel was originally developed with data entry in mind, but since then, the software grew to accommodate everything from accounting, task management, and financial modeling to event programming. That means it’s not the simplest piece of software out there. To work efficiently in Excel, you need to use keyboard shortcuts and that’s what we’re going to focus on in this article.

Why Do You Need Keyboard Shortcuts?

Even if you know what Microsoft Excel is and you have used it extensively in the past, you still might get surprised with all the functions and shortcuts that you can use to work fast and efficiently. Excel has hundreds of shortcuts and keystroke combinations, but don’t worry, you don’t need to memorize all of them.

You will use some Excel shortcuts more often than the others. So let’s focus on the most important ones that you’ll need on a daily basis.

Commonly Used Excel Shortcuts

You’re probably familiar with some shortcuts as they are commonly used across most Windows 10/11 and Microsoft Office apps. Nonetheless, here’s a useful table with the most commonly used Excel keyboard shortcuts that you need to start using to quickly improve your mastery over spreadsheets.

Ctrl+A	Select all
Ctrl+C	Copy
Ctrl+V	Paste
Ctrl+X	Cut
Ctrl+Z	Undo
Ctrl+Y	Redo
Ctrl+B	Bold
Ctrl+I	Italicize
Ctrl+U	Underline
Alt+H	Go to the Home tab
Delete (or DEL)	Remove content in the cell
Ctrl+O	Open a workbook
Ctrl+W	Close a workbook
Alt+H+H	Choose a color to fill the cell

These shortcuts are convenient, and you should get used to using them not only in Excel, but also in Microsoft Word, internet browsers, or any other app you frequently use for business or leisure.

Pivot Table Shortcuts in Excel

The Pivot Table is a potent tool in Excel. It can summarize the selected rows and columns of the spreadsheet or even reorganize them. Pivot tables are handy if you have long rows of data that you need to summarize, and they also allow you to compare your data. If you find yourself using many pivot tables, start using the shortcuts below regularly.

Right-click	Access the context menu for the selected row, column, or cell.
Ctrl+D	Delete the table
Ctrl+M	Move the table
Ctrl+R	Rename the table
Alt+Shift+Right Arrow	Group the pivot table items you selected
Alt+Shift+Left Arrow	Ungroup the pivot table items you selected

Now that you know the basic shortcuts let’s focus on other Excel keyboard shortcuts that will boost your productivity and speed.

Shortcuts for Navigating in Excel

Navigate through Excel and switch between worksheets tabs quicker using the following keyboard shortcuts.

Ctrl+Page Up	Press this command combination to switch the worksheet tabs to the right.
Ctrl+Page Down	This command will switch the worksheet tabs to the left.
Ctrl+Backspace	This shortcut will show you which cell is active.
F11	The F11 key will create a new chart. It is an amazing shortcut that will allow you to skip all the navigation through Excel’s toolbar.
Ctrl+F	Press this combination of keys to quickly access the find function.
Ctrl+Q	Quickly access the Help function in Excel.
Ctrl+Arrow Key	Go to the last populated cell in the direction of the arrow key. For example, Ctrl+Right Arrow will send you to the last cell to the right, while Ctrl+Down Arrow will select the last cell at the bottom.
Ctrl+F12	This command quickly opens the “open file” dialog and allows you to access another workbook.
Ctrl+F1	This combination of keys will toggle the display of ribbons.

Shortcuts for Selecting Items in Excel

Save time by selecting columns and rows faster by using the following keyboard shortcuts instead of clunky mouse movements.

Ctrl+Spacebar	Press Ctrl+Space to select the entire column. You will no longer need to use the header and navigate with your mouse.
Shift+Spacebar	Press Shift+Space to select the whole row.
Ctrl+0	This simple shortcut will hide all the selected columns.

Shortcuts for Functions and Formulas in Excel

Excel is mostly about formulas and functions. Stop typing them variable by variable and boost your productivity with the keyboard shortcuts below.

Ctrl+’	Switch between displaying all the formulas in your worksheet. Also, you can click on the cell to have the formula shown in the formula bar.
Ctrl+Alt+F9	Use this shortcut when you need to calculate all the formulas inside all of your active workbooks.
Ctrl+Shift+$	To automatically change a cell into the currency format, you must select it and press Ctrl+Shift+$. It can also work on multiple cells as long as they are selected.
Ctrl+Shift+%	This shortcut applies the percentage format to the selected cell.
Alt+=	This shortcut will automatically insert the SUM() function. This is possibly the most used formula in Excel, and having a shortcut for it is a must. The Sum() function auto-sums the data of multiple columns and rows. Just make sure to select one extra column on the right side and one extra row on the bottom. Excel will use these to display the summation data.
Alt+H+O+I	This shortcut is a combination of keystrokes that will complete a function in a sequence. First, hit Alt+H to select the Home tab, then hit the O while still holding the Alt key to select the format menu. Finally, hit the I to autofit the width of the column. Remember to keep your finger on Alt while pressing each letter.
Ctrl+[	This shortcut allows you to see what cells are referenced in other cells. It is especially useful if you are working with complex formulas.
Ctrl+Shift+J	Use this shortcut to see a list of all the constants in your worksheet.
Alt+M	Open the formulas tab.
Shift+F3	Prest Shift+F3 to open the insert function window to insert a function.

Time and Date Shortcuts in Excel

Log various activities instantly by using the time and date keyboard shortcuts below.

Ctrl+Shift+#	This shortcut will allow you to change the date format.
Ctrl+Shift+@	Hitting the combination of these keys will allow you quick access to the time of day style. From here, you can proceed and add it to the selected cell.
Ctrl+;	Do you want to add the current date to the Excel spreadsheet? Simply hit this shortcut to add it quickly.
Ctrl+Shift+;	This function will place the exact current time in the selected cell.

Editing Shortcuts in Excel

Editing cells, rows, columns, and comments can be extremely time-consuming. Boost your speed with the following shortcuts.

Ctrl+1	Open the format cell dialog box. This shortcut will allow you to make changes to the cell’s appearance.
Ctrl+K	If you select a cell or the data entered in the cell and use this shortcut, a hyperlink box will open. Copy and paste the hyperlink into the box (using the copy/paste shortcuts for extra practice).
F2	This must be one of the most used Excel shortcuts as it will allow you to edit the cell. Use it to make quick changes.
F4	The F4 key will repeat your last action. Be it a formula or an edit, this key will copy the action and save you a lot of time.
Ctrl+Plus Character (+)	Insert new rows and columns quickly with the Ctrl shortcut.
Ctrl+Minus Character (-)	Press Ctrl+- to delete a row or a column.
Shift+F2	Insert a comment or edit an existing comment in a selected cell.

Formatting Shortcuts in Excel

Formatting your Excel data makes it readable and presentable. But that doesn’t mean you should waste time, so start using the shortcuts below.

Ctrl+Shift+&	This Excel shortcut quickly applies borders to the selected cell. This is very helpful if you want to keep your spreadsheet neatly organized and visually appealing.
Ctrl+Shift+_	To quickly remove the borders, select the desired cells and hit this combination of keys.
Ctrl+Shift+~	This combination of keys will style a selected cell or a group of cells into a general format. Keep in mind the general format is the default format, meaning you get the numbers you type and nothing else.
Ctrl+Shift+^	This command applies the exponential format to the cell you select.
Ctrl+Shift+!	This shortcut applies the comma formatting style to the selected cell. For example, when the number in the cell goes over 1000, this command will display it with a comma as 1,000. Use this shortcut to visualize numbers.

Whether you’re a spreadsheet master or using Excel once in a blue moon, knowing a few shortcuts will make your job much easier and less time-consuming. Share your favorite Excel keyboard shortcuts and combos in the comments below!

지영 한

About the author

저는 Windows 및 Office 소프트웨어에 대한 전문 리뷰어입니다. 저는 이러한 프로그램과 다양한 기능에 대한 깊은 지식을 가지고 있습니다. 내 리뷰는 객관적이고 상세하므로 잠재 고객이 프로그램이 얼마나 잘 작동하고 어떤 개선이 이루어질 수 있는지 알 수 있습니다. 나는 또한 리뷰를 통해서든 앱에 대한 최고의 거래를 찾는 것이든 사람들이 필요에 가장 적합한 앱을 찾도록 돕는 것을 좋아합니다.

40 최고의 Microsoft Excel 키보드 단축키

키보드 단축키가 필요한 이유는 무엇입니까?

자주 사용하는 엑셀 단축키

Excel의 피벗 테이블 바로 가기

Excel에서 탐색을 위한 바로 가기

(Shortcuts)Excel 에서 항목(Items) 선택을 위한 바로 가기

(Shortcuts)Excel 의 함수(Functions) 및 수식 (Formulas)바로 가기(Excel)

Excel의 시간 및 날짜 바로 가기

Excel에서 바로 가기 편집

Excel에서 서식 바로 가기

The 40 Best Microsoft Excel Keyboard Shortcuts

Why Do You Need Keyboard Shortcuts?

Commonly Used Excel Shortcuts

Pivot Table Shortcuts in Excel

Shortcuts for Navigating in Excel

Shortcuts for Selecting Items in Excel

Shortcuts for Functions and Formulas in Excel

Time and Date Shortcuts in Excel

Editing Shortcuts in Excel

Formatting Shortcuts in Excel

지영 한

About the author

Related posts

30개 이상의 최고의 Microsoft Word 키보드 단축키

Microsoft Excel에서 Gantt Charts을 만드는 방법

전자 메일 및 작업에 대한 Microsoft Outlook 바로 가기를 만드는 방법

Microsoft Excel에서 가정 분석을 이해하는 방법

Microsoft Excel 기본 자습서 – Excel 사용 방법 배우기

Excel에서 Group Worksheets 방법

Microsoft Office 문서에서 개인 메타데이터를 완전히 삭제하는 방법

12가지 유용한 Microsoft Word 팁 및 요령

Excel 배경 이미지를 추가하고 인쇄하는 방법

방법 Create and Use AutoText에 Microsoft Word

Excel에서 일치하는 값을 찾는 방법

Excel에서 Variance을 계산하는 방법

Microsoft Word Document에 서명을 삽입하는 방법

안전하게 안전하게 Password Protect Excel File

7 최고의 Microsoft Word 추가 기능

Excel에서 오류 막대를 추가하는 방법

Excel의 여러 인스턴스를 여는 방법

Word 문서에 Excel 워크시트 삽입

최고의 Microsoft PowerPoint 키보드 단축키

Excel 워크시트 셀에 주석을 추가하는 방법

^(Shortcuts)Excel 에서 항목^(Items) 선택을 위한 바로 가기

^(Shortcuts)Excel 의 함수^(Functions) 및 수식 ^(Formulas)바로 가기^(Excel)