4/14/2019
Posted by admin
Microsoft Excel is the most widely used spreadsheet application in the world. Tamil mp3 songs download free. 10 facts about taj mahal. Whether you use Excel for personal purpose or in office, here is the complete list of shortcuts that will help to improve the productivity.
Microsoft Excel Keyboard Shortcuts
The keyboard shortcuts are tested and works in most versions of the Microsoft Excel in Windows based computers. The shortcuts are categorized as below and use the search box to filter the results in the below table.
- Menu – related to menu items and ribbon icons
- Dialog box – opens up the dialog box
- Function – insert a function
- Data processing – used for spreadsheet data processing in workbooks like copy and paste
- Formatting – text formatting like bold, double underline, strikethrough, etc.
- Navigation – move within and outside the workbook
- Workbook – applicable at window level like resizing, minimizing, etc.
- General – general purpose shortcuts
Shortcut | Description | Category |
---|---|---|
Alt | Activate access keys (then press further keys to go to the required menu item) | Menu |
Alt + = | Apply automatic summation when used down the cells with numbers. Apply sum function when used on empty cell. | Function |
Alt + A | Go to Data menu | Menu |
Alt + A, M | Open Remove Duplicate dialog box | Dialog box |
Alt + Enter | Create a new line within a cell | Data processing |
Alt + F | Open File menu | Menu |
Alt + F1 | Insert chart on the active sheet | Data processing |
Alt + F2 | Save as workbook | Menu |
Alt + F4 | Close workbook | Menu |
Alt + F8 | Open Macro popup box | Dialog box |
Alt + F10 | Show or hide selection pane | General |
Alt + F11 | Open Microsoft Visual Basic editor for Excel | Data processing |
Alt + H | Highlight menu and go to Home menu | Menu |
Alt + H, 0 | Increase one decimal place of the number | Menu |
Alt + H, 3, D | Double underline the selected content | Menu |
Alt + H, 5 | Reduce indent | Menu |
Alt + H, 6 | Increase indent | Menu |
Alt + H, 9 | Reduce one decimal place of the number | Menu |
Alt + H, A, B | Align content in bottom of the cell | Menu |
Alt + H, A, C | Align center | Menu |
Alt + H, A, L | Left alignment | Menu |
Alt + H, A, M | Align content in middle of the cell | Menu |
Alt + H, A, N | Apply accounting format from the list | Menu |
Alt + H, A, R | Right alignment | Menu |
Alt + H, A, T | Align content in top of the cell | Menu |
Alt + H, B | Open border dropdown | Menu |
Alt + H, C | Align center | Formatting |
Alt + H, C, P | Open Copy Picture dialog box | Dialog box |
Alt + H, D, C | Delete the column of the active cell | Data processing |
Alt + H, E, A | Clear the selected cell data | Data processing |
Alt + H, E, R | Remove hyperlinks from the selected cells | Data processing |
Alt + H, F, I, J | Justify the selected cell content | Formatting |
Alt + H, F, I, L | Copy the content on the right cell to the current active cell | Data processing |
Alt + H, F, I, R | Copy the content on the left cell to the current active cell | Data processing |
Alt + H, F, I, U | Copy the content on the below cell to the current active cell | Data processing |
Alt + H, F, O | Open clipboard pane | Data processing |
Alt + H, H | Choose the color to fill | Menu |
Alt + H, O, I | Autofit the width of the selected column | General |
Alt + H, U, A | Average number function | Function |
Alt + H, U, C | Count numbers | Function |
Alt + H, U, I | Minimum number function | Function |
Alt + H, U, M | Maximum number function | Function |
Alt + H, V, E | Paste content with source values and formatting (you should have copied the content before) | Data processing |
Alt + H, V, I | Paste the copied content as a linked picture or image | Data processing |
Alt + H, V, U | Paste the copied content as a picture or image | Data processing |
Alt + M | Go to Formulas menu | Menu |
Alt + N | Highlight menu and go to insert menu | Menu |
Alt + N, B | Go to insert bar chart menu | Menu |
Alt + N, C | Go to insert column chart menu | Menu |
Alt + N, N | Go to insert line chart menu | Menu |
Alt + N, Q | Go to insert pie chart menu | Menu |
Alt + N, R | Open Insert Chart dialog and go to Recommended Chart section | Dialog box |
Alt + N, S, D | Go to insert custom combo chart menu | Menu |
Alt + P | Page Layout menu | Menu |
Alt + Page Down | Move one screen right | Workbook |
Alt + Page Up | Move one screen left | Workbook |
Alt + R | Open Review tab | Menu |
Alt + R, A | Show all comments | Menu |
Alt + R, D | Delete comment from the cell | Menu |
Alt + Shift + F1 | Create new spreadsheet | Data processing |
Alt + Shift + F2 | Save as workbook | Workbook |
Alt + Shift + F4 | Close workbook | Workbook |
Alt + Spacebar | Open control menu | Menu |
Alt + T, O | Open Excel Options dialog | Dialog box |
Alt + W | Go to View menu | Menu |
Alt + W, F, F | Free panes, you should have selected columns or rows before | Menu |
Alt + W, I | View the sheet in a page break preview mode | Menu |
Alt + W, L | View the sheet in a normal mode | Menu |
Alt + W, Q | Open zoom dialog box | Dialog box |
Alt + W, V, G | Toggle gridlines on or off | Menu |
Context Key | Open context menu | Menu |
Ctrl + 0 | Hide columns | Data processing |
Ctrl + 1 | Open format cells popup box | Dialog box |
Ctrl + 2 | Apply bold | Formatting |
Ctrl + 3 | Apply italic | Formatting |
Ctrl + 4 | Apply underline | Formatting |
Ctrl + 5 | Apply strikethrough | Formatting |
Ctrl + 6 | Toggle object display | Menu |
Ctrl + 7 | Show / hide toolbar | Menu |
Ctrl + 8 | Show / hide outline symbols | General |
Ctrl + 9 | Hide rows | Data processing |
Ctrl + - | Delete cells or rows | Data processing |
Ctrl + : | Insert current time | Data processing |
Ctrl + ; | Insert system date | Data processing |
Ctrl + ‘ | Copy the formula from upper cell to lower cell | Data processing |
Ctrl + “ | Copy the content from the upper cell to lower cell | Data processing |
Ctrl + A | Select all cells in a sheet | Workbook |
Ctrl + Alt + V | Open paste special dialog box when you have copied the content in clipboard | Dialog box |
Ctrl + B | Bold selected content | Formatting |
Ctrl + C | Copy selected content | Data processing |
Ctrl + D | Copy the content from the upper cell to lower cell | Data processing |
Ctrl + Down Arrow | Move to lower end of the selected range | Navigation |
Ctrl + E | Use flash fill | Data processing |
Ctrl + End | Go to the lowest used cell in right corner of a workbook | General |
Ctrl + Enter | Fill the range with current entry | Data processing |
Ctrl + F | Find content on the sheet | Data processing |
Ctrl + F1 | Show or hide ribbon | Menu |
Ctrl + F2 | Open print preview options | Menu |
Ctrl + F3 | Open name manager | Dialog box |
Ctrl + F4 | Close sheet | Menu |
Ctrl + F5 | Restore window size | Workbook |
Ctrl + F6 | Go to next workbook | Workbook |
Ctrl + F7 | Move the window | Workbook |
Ctrl + F8 | Resize window | Workbook |
Ctrl + F9 | Minimize window | Workbook |
Ctrl + F10 | Maximize window | Workbook |
Ctrl + F11 | Insert a new macro sheet | Workbook |
Ctrl + F12 | Open file | Menu |
Ctrl + G | Go to the named cell | Dialog box |
Ctrl + H | Find text and replace with another text | Dialog box |
Ctrl + Home | Go to start of the sheet | Workbook |
Ctrl + I | Make the selected text italic | Formatting |
Ctrl + K | Insert hyperlink on the selected cell | Data processing |
Ctrl + L | Open create table box | Dialog box |
Ctrl + Left Arrow | Move to left end of the selected range | Navigation |
Ctrl + Left Click | Select only the particular clicked cells in addition to the currently selected cell | Data processing |
Ctrl + N | Open new Excel workbook | Workbook |
Ctrl + O | Go to open menu | Menu |
Ctrl + P | Print options | Menu |
Ctrl + Page Down | Go to next sheet in a workbook | Workbook |
Ctrl + Page Up | Go to previous sheet in a workbook | Workbook |
Ctrl + Q | Open Quick Analysis tool | Dialog box |
Ctrl + R | Copy the content from left cell to the right side cell | Data processing |
Ctrl + Right Arrow | Move to right end of the selected range | Navigation |
Ctrl + S | Save the workbook | Menu |
Ctrl + Shift + ! | Format cell in number format | Formatting |
Ctrl + Shift + “ | Copy the content from the upper cell to lower cell | Data processing |
Ctrl + Shift + # | Format cell in date format | Formatting |
Ctrl + Shift + $ | Format cell in $ currency format | Formatting |
Ctrl + Shift + % | Format cell in % format | Formatting |
Ctrl + Shift + & | Apply border around the cell | Formatting |
Ctrl + Shift + ( | Unhide rows | Data processing |
Ctrl + Shift + ) | Unhide columns | Data processing |
Ctrl + Shift + * | Select the region nearer to active cell | Data processing |
Ctrl + Shift + + | Insert cells or rows | Data processing |
Ctrl + Shift + : | Insert current time | Data processing |
Ctrl + Shift + @ | Format cell in time format | Formatting |
Ctrl + Shift + ^ | Format cell in exponential format | Formatting |
Ctrl + Shift + _ | Remove border around the cell | Formatting |
Ctrl + Shift + Arrows | Select till the nonblank cell in the arrow direction | Navigation |
Ctrl + Shift + End | Select the range from the current cell to the lowest used right corner cell of a workbook | Navigation |
Ctrl + Shift + F | Open format cell dialog box with font tab open | Formatting |
Ctrl + Shift + F1 | Maximize window by hiding menus and ribbon | Workbook |
Ctrl + Shift + F3 | Open create name for selection popup box | Dialog box |
Ctrl + Shift + F6 | Go to previous workbook window | Workbook |
Ctrl + Shift + F6 | Go to previous workbook | Workbook |
Ctrl + Shift + F12 | Open print options | Menu |
Ctrl + Shift + L | Toggle autofilter | General |
Ctrl + Shift + O | Select all cells with comments | General |
Ctrl + Shift + Page Down | Select current and next sheets (you should have next available sheet for selection) | Workbook |
Ctrl + Shift + Page Up | Select current and previous sheets (you should have previous available sheet for selection) | Workbook |
Ctrl + Shift + Spacebar | Select the workbook content | Data processing |
Ctrl + Shift + Tab | Go to previous workbook | Workbook |
Ctrl + Shift + U | Expand / collapse formula bar | Menu |
Ctrl + Shift + ~ | Format cell as general | Formatting |
Ctrl + T | Open create table box | Dialog box |
Ctrl + Tab | Go to next workbook | Workbook |
Ctrl + U | Underline the text | Formatting |
Ctrl + Up Arrow | Move to upper end of the selected range | Navigation |
Ctrl + V | Paste content | Data processing |
Ctrl + W | Close active sheet | General |
Ctrl + X | Cut the selected content | Data processing |
Ctrl + Y | Redo previous action | Data processing |
Ctrl + Z | Undo previous action | Data processing |
Down Arrow | Move one cell down | Navigation |
Esc | Cancel the selected or current operation | Data processing |
F1 | Open Excel help | General |
F2 | Edit active cell | Data processing |
F3 | Show paste name popup when the names are defined in the workbook | Dialog box |
F4 | Repeat the last action (like pasting) | Data processing |
F5 | Open Go To popup box | Dialog box |
F6 | Toggle between menu, ribbon and task pane. | Menu |
F7 | Do spell check | Data processing |
F9 | Calculate in all sheets in all opened workbooks | Workbook |
F10 | Activate access keys | Menu |
F11 | Insert new chart sheet | Workbook |
F12 | Save as the workbook | Workbook |
Home | Go to first cell in a row | Navigation |
Left Arrow | Move one cell left | Navigation |
Page Down | Move one screen down | Navigation |
Page Up | Move one screen up | Navigation |
Right Arrow | Move one cell right | Navigation |
Scroll Lock + Home | Go to upper left corner cell (first cell) | Navigation |
Shift + 10 | View context menu (generally opened with right click) | Menu |
Shift + F2 | Insert comment on the cell | Data processing |
Shift + F3 | Insert function | Data processing |
Shift + F4 | Find next when finding the text | Dialog box |
Shift + F5 | Find and replace | Dialog box |
Shift + F6 | Activate menu | Menu |
Shift + F7 | Open thesaurus to find synonyms | General |
Shift + F8 | Add to selection | General |
Shift + F10 + M | Add or delete comment from the selected cell | Data processing |
Shift + F11 | Create new sheet | Workbook |
Shift + F12 | Save as the workbook | Menu |
Shift + Left Click | Select all cells till the clicked range in addition to the currently selected cell | Data processing |
Shift + Spacebar | Select the row | General |
Shift + Tab | Move to previous cell or ribbon item or cell | Navigation |
Tab | Move to next cell or ribbon item or cell | Navigation |
Up Arrow | Move one cell up | Navigation |
Windows Key | Open context menu | Menu |