ALLSOL

MS Excel Shortcut Keys

MS Excel Shortcut Keys

Shortcut keys For Microsoft Excel

ShortcutDescription
TabTo Move to the next cell, to the right of the currently selected cell.
Ctrl+ATo Select all contents of a worksheet.
Ctrl+BTo Bold all cells in the highlighted section.
Ctrl+CTo Copy all cells in the highlighted section.
Ctrl+DTo Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down arrow to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.
Ctrl+FTo Search current sheet.
Ctrl+GTo Go to a certain area.
Ctrl+HTo Find and replace.
Ctrl+ITo Puts italics on all cells in the highlighted section.
Ctrl+KTo Inserts a hyperlink.
Ctrl+LTo Opens the Create Table dialog box.
Ctrl+NTo Creates a new workbook.
Ctrl+OTo Opens a workbook.
Ctrl+PTo Print the current sheet.
Ctrl+RTo Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
Ctrl+STo Saves the open worksheet.
Ctrl+TTo Open the Create Table dialog box.
Ctrl+UTo Underlines all cells in the highlighted section.
Ctrl+VTo Pastes everything copied onto the clipboard.
Ctrl+WTo Closes the current workbook.
Ctrl+XTo Cuts all cells in the highlighted section.
Ctrl+YTo Repeats the last entry (redo).
Ctrl+ZTo Undo the last action.
Ctrl+1To Changes the format of the selected cells.
Ctrl+2To Bolds all cells in the highlighted section.
Ctrl+3To Puts italics all cells in the highlighted section.
Ctrl+4To Underlines all cells in highlighted section.
Ctrl+5To Puts a strikethrough all cells in the highlighted section.
Ctrl+6To Shows or hides objects.
Ctrl+7To Shows or hides the toolbar.
Ctrl+8To Toggles the outline symbols.
Ctrl+9To Hides rows.
Ctrl+0To Hides columns.
Ctrl+Shift+:To Enters the current time.
Ctrl+;To Enters the current date.
Ctrl+`To Changes between displaying cell values or formulas in the worksheet.
Ctrl+’To Copies a formula from the cell above.
Ctrl+Shift+”To Copies value from cell above.
Ctrl+-To Deletes the selected column or row.
Ctrl+Shift+=To Inserts a new column or row.
Ctrl+Shift+~To Switches between showing Excel formulas or their values in cells.
Ctrl+Shift+@To Applies time formatting.
Ctrl+Shift+!To Applies comma formatting.
Ctrl+Shift+$To Applies currency formatting.
Ctrl+Shift+#To Applies date formatting.
Ctrl+Shift+%To Applies percentage formatting.
Ctrl+Shift+^To Applies exponential formatting.
Ctrl+Shift+*To Selects the current region around the active cell.
Ctrl+Shift+&To Places border around selected cells.
Ctrl+Shift+_To Removes a border.
Ctrl++To Insert.
Ctrl+-To Delete.
Ctrl+Shift+(To Unhide rows.
Ctrl+Shift+)To Unhide columns.
Ctrl+/To Selects the array containing the active cell.
Ctrl+\To Selects the cells with a static value or don’t match the formula in the active cell.
Ctrl+[To Selects all cells referenced by formulas in the highlighted section.
Ctrl+]To Selects cells that contain formulas that reference the active cell.
Ctrl+Shift+{To Selects all cells directly or indirectly referenced by formulas in the highlighted section.
Ctrl+Shift+}To Selects cells which contain formulas that directly or indirectly reference the active cell.
Ctrl+Shift+| (pipe)To Selects the cells within a column that don’t match the formula or static value in the active cell.
Ctrl+EnterTo Fills the selected cells with the current entry.
Ctrl+SpacebarTo Selects the entire column.
Ctrl+Shift+SpacebarTo Selects the entire worksheet.
Ctrl+HomeTo Move to cell A1.
Ctrl+EndTo Move to last cell with text on the worksheet.
Ctrl+TabTo Move between Two or more open Excel files.
Ctrl+Shift+TabTo Activates the previous workbook.
Ctrl+Shift+ATo Inserts argument names into a formula.
Ctrl+Shift+FTo Opens the drop-down menu for fonts.
Ctrl+Shift+OTo Selects all of the cells that contain comments.
Ctrl+Shift+PTo Opens the drop-down menu for point size.
Shift+InsertTo Pastes what is stored on the clipboard.
Shift+PageTo In a single column, highlights all cells above that are selected.
Up 
Shift+PageTo In a single column, highlights all cells above that are selected.
Down 
Shift+HomeTo Highlights all text to the left of the cursor.
Shift+EndTo Highlights all text to the right of the cursor.
Shift+Up ArrowTo Extends the highlighted area up one cell.
Shift+Down ArrowTo Extends the highlighted area down one cell.
Shift+Left ArrowTo Extends the highlighted area left one character.
Shift+Right ArrowTo Extends the highlighted area right one character.
Alt+TabTo Cycles through applications.
Alt+SpacebarTo Opens the system menu.
Alt+BackspaceTo Undo.
Alt+EnterTo While typing text in a cell, pressing Alt+Enter moves to the next line, allowing for multiple lines of text in one cell.
Alt+=To Creates a formula to sum all of the above cells.
Alt+’To Allows formatting on a dialog box.
F1To Opens the help menu.
F2To Edits the selected cell.
F3To After a name is created, F3 will paste names.
F4To Repeats last action. For example, if you changed the color of text in another cell, pressing F4 changes the text in cell to the same color.
F5To Goes to a specific cell. For example, C6.
F6To Move to the next pane.
F7To Spell check selected text or document.
F8To Enters Extend Mode.
F9To Recalculates every workbook.
F10To Activates the menu bar.
F11To Creates a chart from selected data.
F12To Save As option.
Shift+F1To Opens the “What’s This?” window.
Shift+F2To Allows the user to edit a cell comment.
Shift+F3To Opens the Excel formula window.
Shift+F5To Brings up a search box.
Shift+F6To Move to previous pane.
Shift+F8To Add to selection.
Shift+F9To Performs calculate function on active sheet.
Ctrl+F3To Open Excel Name Manager.
Ctrl+F4To Closes current window.
Ctrl+F5To Restores window size.
Ctrl+F6To Next workbook.
Ctrl+Shift+F6To Previous workbook.
Ctrl+F7To Moves the window.
Ctrl+F8To Resizes the window.
Ctrl+F9To Minimize current window.
Ctrl+F10To Maximize currently selected window.
Ctrl+F11To Inserts a macro sheet.
Ctrl+F12To Opens a file.
Ctrl+Shift+F3To Creates names by using those of either row or column labels.
Ctrl+Shift+F6To Moves to the previous worksheet window.
Ctrl+Shift+F12To Prints the current worksheet.
Alt+F1To Inserts a chart.
Alt+F2To Save As option.
Alt+F4To Exits Excel.
Alt+F8To Opens the macro dialog box.
Alt+F11To Opens the Visual Basic editor.
Alt+Shift+F1To Creates a new worksheet.
Alt+Shift+F2To Saves the current worksheet.