Even if you are familiar with Microsoft Excel, you may be surprised by the number and variety of keyboard shortcuts that you can use to speed up your work and, usually, make things more convenient.
Now, Does anyone expect you to memorize all these keyboard combinations? Certainly not! Each person's needs are different, so some will be more useful than others. And even if you learn some new tricks, it is important to highlight. We have also tried to keep the list clean and simple., Therefore print it, that helps!
At the same time, even though our list of shortcuts here is quite long, It is by no means a complete list of all keyboard combo available in Excel. We have tried to keep it in the most useful shortcuts in general. And you'll be glad to know that almost all of these shortcuts have been around for a long time., so they should be useful no matter what version of Excel you are using.
General program shortcuts
First, Let's take a look at some general keyboard shortcuts for manipulating workbooks, get help and some other actions associated with the interface.
- Ctrl + N: Create a new workbook
- Ctrl + O: Open an existing workbook
- Ctrl + S: Save a workbook
- F12: Open the Save As dialog
- Ctrl + W: Close a workbook
- Ctrl + F4: Close Excel
- F4: Repeat the last command or action. As an example, si lo último que escribió en una celda es “hello” o si cambia el color de la fuente, clicking on another cell and pressing F4 repeats that action in the new cell.
- Shift + F11: Insert a new worksheet
- Ctrl + WITH: Undo an action
- Ctrl + AND: Redo an action
- Ctrl + F2: Switch to print preview
- F1: Open the help panel
- Alt + Q: Ve al cuadro “Dime qué deseas hacer”.
- F7: Check spelling
- F9: Calculate all worksheets in all open workbooks
- Shift + F9: Calculate active worksheets
- Alt o F10: Enable or disable key tips
- Ctrl + F1: Show or hide the tape
- Ctrl + Shift + U: Expand or collapse the formula bar
- Ctrl + F9: Minimize the workbook window
- F11: Create a bar chart based on selected data (on a separate sheet)
- Alt + F1: Create an embedded bar chart based on selected data (same sheet)
- Ctrl + F: Search a spreadsheet or use Find and Replace
- Alt + F: Open the File tab menu
- Alt + H: Go to the Home tab
- Alt + N: Open the Insert tab
- Alt + P: Go to the Page Layout tab
- Alt + M: Go to the Formulas tab
- Alt + A: Go to the Data tab
- Alt + R: Go to the Review tab
- Alt + W: Go to the View tab
- Alt + X: Go to the Plugins tab
- Alt + AND: Go to the Help tab
- Ctrl + Tab: Switch between open workbooks
- Shift + F3: Insert a function
- Alt + F8: Create, run, edit or delete a macro
- Alt + F11: Open the Microsoft Visual Basic Application Editor
Move in a worksheet or cell
You can use keyboard shortcuts to easily navigate through your worksheet, within a cell or throughout your workbook.
- Left arrow / right: Move one cell to the left or right
- Ctrl + Left arrow / right: Move to the furthest cell to the left or right of the row
- Up arrow / down: Move one cell up or down
- Ctrl + Up arrow / down: Move to the top or bottom cell of the column
- Tab: Go to next cell
- Shift + Tabulator: Go to the previous cell
- Ctrl + End: Go to the cell used lower right
- F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.
- Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if you are editing a cell)
- Ctrl + Beginning: Move to the beginning of a worksheet
- Page up / down: Move a screen up or down in a worksheet
- Alt + Page up / down: Move a screen to the right or left in a worksheet
- Ctrl + Page up / down: Go to the previous or next worksheet
Choose cells
You may have noticed in the previous section that you use the arrow keys to move between cells and the Ctrl key to modify that movement. Using the Shift key to modify the arrow keys enables you to extend the selected cells. In addition there are some other combos to speed up the selection.
- Shift + Left arrow / right: Extend cell selection left or right
- Shift + Space: Choose whole row
- Ctrl + Space: Choose entire column
- Ctrl + Shift + Space: Select the entire worksheet
Edit cells
Excel also provides some keyboard shortcuts for editing cells.
- F2: Edit a cell
- Shift + F2: Add or edit a cell comment
- Ctrl + X: Cut the contents of a cell, selected data or selected cell range
- Ctrl + C o Ctrl + Insert: Copy the contents of a cell, the selected data or the selected cell range
- Ctrl + V o Mayús + Insert: Paste the contents of a cell, the selected data or the selected cell range
- Ctrl + Alt + V: Open the Paste Special dialog
- Remove: Clear the contents of a cell, the selected data or the selected cell range
- Alt + Intro: Insert a hard return inside a cell (while editing a cell)
- F3: Paste a cell name (if cells are named in worksheet)
- Alt + H + D + C: Delete column
- Esc: Cancel an entry in a cell or the formula bar
- Get into: Complete an entry in a cell or in the formula bar
Cell formatting
Ready to format some cells? These keyboard shortcuts make it easy!!
- Ctrl + B: Add or remove bold to the content of a cell, selected data or selected cell range
- Ctrl + I: Add or remove italics to cell content, selected data or selected cell range
- Ctrl + U: Add or remove underlining to the content of a cell, selected data or selected cell range
- Alt + H + H: Select a fill color
- Alt + H + B: Add a border
- Ctrl + Shift + &: Apply outline border
- Ctrl + Shift + _ (underlined): Erase outline border
- Ctrl + 9: Hide selected rows
- Ctrl + 0: Hide selected columns
- Ctrl + 1: Open the Format Cells dialog box
- Ctrl + 5: Apply or erase strikethrough
- Ctrl + Shift + $: Apply currency format
- Ctrl + Shift +%: Apply percentage format
The more you use keyboard shortcuts, the easier it will be to remember them. And no one expects you to memorize them all. Hopefully, you have found some new ones that you can use to boost your life a bit in Excel.
Need more help with keyboard shortcuts? You can access Help at any time by pressing F1. This opens a Help panel and enables you to search for help on any topic. I searched “keyboard shortcuts” for more information.
