Excel Shortcuts
Here's the list of the important shortcut keys used in excel.
The list is divided into 5 subsections to help organize the shortcuts for ease of reference later.
a) While working on workbooks, the below shortcuts can be handy.
- Ctrl + N -> Press to create a new workbook.
- Ctrl + O -> Press to open an existing workbook.
- Ctrl + S -> To save your unsaved workbook.
- Shift + F11 -> insert a new worksheet.
- F12 -> Open the save as dialogue box.
- Ctrl + W -> to close the current workbook.
- Ctrl + F4 -> To close excel.
- F4 -> repeat the previous action or command again.
- Alt + H -> access Home Tab.
- Alt + N -> access Insert Tab.
- Alt + P -> access Page Layout Tab.
- Alt + A -> access data Tab.
- Alt + W -> access view Tab.
- Alt + M -> access Formula Tab.
- Ctrl + Z -> Undo an action.
- Ctrl + Y -> Redo an action.
- Ctrl + Tab -> Switch between open workbooks.
- Shift + F9 -> Calculate all active worksheets.
- F9 -> Calculate all worksheets in all open workbooks.
-
F7 -> spell check on all the content
b) Moving around in a worksheet.
- Left, right, up, down arrow key -> move one cell in the relevant direction. 'Up' key to move one cell up and similar.
- Ctrl + left, right, up, down -> move to the end of the row/column in the relevant direction. Ctrl + 'up' key will push you to the topmost cell of the particular column.
- Tab -> move to the next cell.
- Shift + Tab -> move to the previous cell.
- F5 -> move to a relevant cell by typing the cell address.
- Ctrl + End -> move to bottom rightmost used cell.
- Page Up/ Page Down -> move one window up/down in a worksheet.
- Alt + Page Up/ Alt + Page down -> move one window left/right in a worksheet.
-
Ctrl + Page Up/ Down -> move to next/previous worksheet.
c) Selecting cells/a group of cells.
- Shift + left/right -> select the prev or the next cell
- Shift + Space bar -> select the entire row.
- Ctrl + Space bar -> select the entire column
-
Ctrl + Shift + Space bar -> select the entire sheet.
d) Editing/Formatting cells.
- F2 -> edit a cell
- Ctrl + X -> cut the contents of a cell
- Ctrl + C -> copy the contents of a group of selected cells, data or range
- Ctrl + V -> paste the contents of a group of selected cells, data or range
- Ctrl + I -> make the cell content Italic
- Ctrl + B -> make the cell content Bold
- Ctrl + Alt + V -> paste special dialog box opens
- Ctrl + H + A + C -> center align cell content
- Ctrl + H + H -> fill colour in the cell
- Alt + H + B -> to add a border
- Alt + H + D + C -> to delete column
- Ctrl + Shift + _ -> to remove outline border
- Ctrl + Shift + & -> to add outline to cells
- Ctrl + 9 -> Hide the selected rows
- Ctrl + 0 -> Hide the selected columns
- Ctrl + 1 -> Open format cell dialog
- Ctrl + Shift + & -> Apply currency format
- Ctrl + Shift + % -> Apply percentage format
FAQs
1. What is the excel shortcut to insert a new worksheet?
Press Shift + F11 to insert a new worksheet into your workbook.
2. Advantages of learning excel?
It's a good way to store and visualize data. Here you can perform calculations and easily print reports. It's often a useful skill in various jobs and often required.
3. What is the excel shortcut to apply currency or percentage format onto a cell?
Ctrl + Shift + & for currency format and Ctrl + Shift + % for percentage format.
4. How can we select and delete a row in a worksheet?
Shift + Space bar key to select a row and Ctrl + '-' to delete the row.
5. How can we select and delete a column in a worksheet?
Ctrl + Space bar key to select a column and Ctrl + '-' to delete the column.
Key Takeaways
This article extensively discusses the shortcuts commonly needed while working with excel to help increase your productivity. Saving time here can help you do more meaningful and impactful work. Refer to introduction to excel to learn about excel. It's best to start with an understanding of excel as a beginner. After the previous article, refer here to learn more about worksheets in excel, area charts.
Refer to our guided paths on Coding Ninjas Studio to learn more about DSA, Competitive Programming, JavaScript, System Design, etc.
Enroll in our courses and refer to the mock test and problems available.
Take a look at the interview experiences and interview bundle for placement preparations.
Do upvote our blog to help other ninjas grow.
Happy Coding!
134+ registered 
