Whether you are an occasional user or a Microsoft Excel expert, these keyboard shortcuts will be very useful in your daily work.
Whether for work or study reasons, Excel is a spreadsheet program that has become an indispensable tool for many people around the world. And the thing is, who hasn’t ever needed to organize data, do calculations or do accounting?
When you work with Microsoft Excel, one of the goals is to carry out your activities as quickly and efficiently as possible. However, although this app has numerous features, it also hides some tricks that can help you be more productive.
It is a complex application, with a wide range of functions and tools, which is constantly evolving to adapt to the needs of users. Therefore, it is important to be aware of the most useful news that will allow you to master this program.
If you want to boost your productivity and get the most out of Excel, here we share a list of 50 essential keyboard shortcuts, which will allow you to work more productively and without wasting time searching for functions in the app’s menus.
Best Basic and Advanced Keyboard Shortcuts for Excel
- Ctrl+A: Open the Open dialog box, allowing you to select a file to open.
- Ctrl+B: Open the Find dialog box, which helps you find specific words or values in your spreadsheet.
- Ctrl+C: Copy selected cells.
- Ctrl+D: Fill down.
- Ctrl+E: Apply table formatting to a range of cells.
- Ctrl+J: Copy the formula from the left cell to the selected cells to the right.
- Ctrl+K: Italics.
- Ctrl+N: Bold.
- Ctrl+S: Underline.
- Ctrl+T: Open the Create Table dialog box, which allows you to convert a range of cells into a table.
- Ctrl+U: New workbook.
- Ctrl+V: Paste the clipboard contents to the selected location.
- Ctrl+X: Cut cells.
- Ctrl+Y: Redo the last action.
- Ctrl+Z: Undo the last action.
- Ctrl+1: Open the Format Cells dialog box, where you can change the format of selected cells.
- Ctrl+2: Apply bold formatting.
- Ctrl+5: Apply strikethrough.
- Ctrl+9: Hide selected rows.
- Ctrl+0: Hide selected columns.
- Ctrl+F: Go to the File tab.
- Ctrl+Shift+-: Remove cell borders.
- Ctrl+Page Down: Move to the next sheet.
- Ctrl+Page Up: Move to the previous sheet.
- Ctrl+-: Open the Delete Cells box.
- Ctrl++: Open the Insert Cells box.
- Ctrl+Shift+L: Turn filters on or off.
- Ctrl+Shift+O: Select cells with comments.
- Ctrl+Shift+U: Expand the formula bar.
- Shift+F6: Switch between the spreadsheet, task pane, zoom control, and ribbon.
- Ctrl+F9: Minimize a book window until it becomes an icon.
- F12: Show the Save As.
- Ctrl+Shift+Page Down: Add the next sheet to the sheet selection.
- Ctrl+Shift+Page Up: Add the previous sheet to the sheet selection.
- Ctrl+Space: Select the current column.
- Shift+Page Down: Extend the selection downwards.
- Shift+Page Up: Extend the selection upwards.
- Ctrl+Shift+!: Apply formatting with two decimals, thousands, and a minus sign (-) for negative values.
- Alt+F8: Open the Macro dialog box.
- Ctrl+Shift+#: Apply date format.
- Ctrl+Shift+: Apply time format.
- Ctrl+Shift+&: Apply a border to the cell.
- Ctrl+Shift+”: Copy the content of the top cell.
- Ctrl+*: Select the current region of cells with data.
- Ctrl+Shift+Enter: Enter an array formula.
- Alt+Enter: Start a new line in the same cell.
- Shift+F9: Calculate the active spreadsheet.
- Alt+F11: Open the Visual Basic editor.
- Ctrl + + key: Activate or deactivate cell formulas.
- Alt+F1: Insert a graph.
Excel is a powerful tool that can simplify and speed up a wide variety of tasks, from data management to creating reports and charts. However, to take full advantage of all its capabilities, it is essential to know, as well as master, keyboard shortcuts.
These shortcuts will allow you to perform common tasks more quickly, helping you improve your workflow without wasting time searching for functions in the ribbon.
Also Read | 87 Microsoft Edge keyboard shortcuts
