Excel Shortcut Keys
※ Download: Search in excel shortcut
The free live online workshop is Thursday August 23rd at 1pm Pacific Time. Ctrl+Page Down moves to the next sheet in a workbook. CTRL+SHIFT+O selects all cells that contain comments.
I am also a Microsoft MVP. SHIFT+ENTER completes a cell entry and selects the cell above.
MS Excel Shortcuts - You may not be able to remember and master all of them but I am sure you will recollect the ones you feel will help you lower your efforts.
MS Excel Shortcuts Using shortcuts saves a lot of time and it shows your proficiency in application usage. Here we have listed a complete list of Microsoft Excel keyboard shortcuts and their descriptions. These are categorized by Excel shortcuts with function keys, Excel shortcuts with Control key and Miscellaneous. All these keys work with Excel 2013, Excel 2010, Excel 2007 and prior versions. Download MS Excel Shortcut PDF File You can also download the complete Excel Shortcut Keys PDF for offline usage. This PDF file contains Excel Shortcuts listed below group by shortcuts keys with Funciton Key, Conrol Key, Shift Key and miscellaneous. F2 Edit an Excel cell. F4 Repeats the last action. F9 Calculates all worksheets in all open workbooks. F10 Highlights shortcut keys of Menu and Ribbon items. F11 Creates chart of selected cells. CTRL + 2 Makes selected cell text bold. CTRL + 3 Makes selected cell text italic. CTRL + 4 Makes selected cell text underline. CTRL + 5 Makes selected cell text strikethrough. CTRL + 9 Hides selected rows. CTRL + 0 Hides selected columns. CTRL + A CTRL + A once will select current data range, second time it will select whole sheet and third time it will select whole worksheet. CTRL + B Makes selected cell text bold. CTRL + C Copy data. CTRL + D Fill Down command to paste topmost cell to all selected cells below it. CTRL + I Makes selected cell text italic. CTRL + N Opens new workbook. CTRL + U Makes selected cell text underline. CTRL + V Paste data. CTRL + W Close current sheet. CTRL + X Cut data. CTRL + Y Redo last action. CTRL + Z Undo last action. CTRL + : Insert current system time. CTRL + ; Insert current system date. CTRL + ' Copy formula of cell above it. TAB selects right side cell. SHIFT + TAB selects left side cell. CTRL + TAB Switches to next tab in dialog box. CTRL + SHIFT + TAB Switches to previous tab in dialog box. BACKSPACE Clears the whole content of the active cell if a cell selected. Clear a character to left side while editing or writing content in cell. ENTER Moves to one cell downwards. ALT + ENTER Inserts a line break within a cell. CTRL + ENTER Paste copied cell to all selected cells. SHIFT + ENTER Moves to one cell upwards. CTRL + SPACEBAR Selects an entire column in a worksheet. SHIFT + SPACEBAR Selects an entire row in a worksheet. CTRL + SHIFT + SPACEBAR CTRL + SHIFT + SPACEBAR once will select current data range, second time it will select whole sheet cells and third time it will select whole worksheet. ALT +SPACEBAR Displays the Control menu for the Microsoft Office Excel window. DELETE Removes the text data from cell Not formatting. HOME Moves to leftmost cell in the row. CTRL + HOME Moves to the top-left cell of a worksheet. CTRL + SHIFT + HOME Selects cells to the beginning of the data range from current cell. END Moves to the cell in the lower-right corner of the window If SCROLL LOCK is turned on. CTRL + END Moves to the last cell in the lower-right corner of window. CTRL + SHIFT END Selects cells to the end of the data range from current cell. PAGE UP Moves the current view of worksheet to one screen up. CTRL + PAGE UP Moves to the previous sheet in workbook. ALT + PAGE UP Moves the current view of worksheet to one screen to the left. CTRL + SHIFT + PAGE UP Moves to the previous sheet in workbook. PAGE DOWN Moves the current view of worksheet to one screen down. CTRL + PAGE DOWN Moves to the next sheet in workbook. ALT + PAGE DOWN Moves the current view of worksheet to one screen to the right. CTRL + SHIFT + PAGE DOWN Moves to the next sheet in workbook. ALT + DOWN ARROW Show a list of data in cells above to current cell as a dropdown.
Most of the old Alt+ menu shortcuts still work, too. In a similar way, deleting columns and rows is a great way to clean up a worksheet quickly. To select a column, use Control + Space. Will my old shortcuts still work. Ctrl+Shift+: Enters the current time. CTRL + X Cut data. Pressing CTRL+SHIFT+SPACEBAR a third time selects the entire worksheet. Here is example text to help demonstrate how you can delete multiple words at a time using Ctrl+Backspace. Ctrl+W Closes the selected workbook window.
