Microsoft Office

MS Excel Shortcut Keys

MS Excel Shortcut Keys-Shortcut keys, also known as keyboard shortcuts or hotkeys, are combinations of keys that provide quick access to various functions or commands within a software application or operating system. They are designed to increase productivity and efficiency by allowing users to perform tasks without the need to navigate through menus or use the mouse.

Microsoft Excel has numerous shortcut keys that can help you perform tasks more efficiently. Here are some commonly used Excel shortcut keys :

Shortcut KeysDescription
Ctrl + A Select the entire worksheet.
Ctrl + BApplies or remove bold formatting.
Ctrl + CCopies the selected cell.
Ctrl + DFill Down command.
Ctrl + EFlash Fill.
Ctrl + FFind tab.
Ctrl + GGo to dialog box.
Ctrl + HReplace tab.
Ctrl + IItalic formatting.
Ctrl + K insert hyperlink
Ctrl + LCreate table dialog box.
Ctrl + NCreate a new blank workbook.
Ctrl + ODisplays the Open dialog box to open or find a file.
Ctrl + PPrint tab.
Ctrl + QQuick Analysis option.
Ctrl + RFill to the right.
Ctrl + SSave the active file.
Ctrl + TCreate Table dialog box.
Ctrl + UUnderline formatting.
Ctrl + VPaste at the selected cell.
Ctrl + WClosest the selected workbook window.
Ctrl + XCuts the selected cell.
Ctrl + YRepeat the last command or action.
Ctrl + Z Undo the last command.
Ctrl + 1Displays the Format Cells dialog box.
Ctrl + 2Applies or removes bold formatting.
Ctrl + 3Applies aur removes Italic formatting.
Ctrl + 4Applies or removes underlining.
Ctrl + 5Applies aur removes strikethrough.
Ctrl + 6Alternates between hiding and displaying objects.
Ctrl + 8Displays or hides the outline symbols.
Ctrl + 9Hides the selected rows.
Ctrl + 0Hides the selected columns.
Alt + W + PWhich is the worksheet to page layout view
Alt + W + L which is the worksheet to normal view
Alt + W + ISwitches the worksheet to page break preview view
BackspaceDelete one character to the left in the Formula Bar.
Also clear the content of the active cell.
In cell editing mode it delete the character to the left of the insertion point.
Ctrl + BackspaceRepositions the worksheet so that the active cells is in view.
DeleteRemoves the cell contents (data and Formulas) from selected cells without affecting cell formats or comments.
In cell editing mode, it deletes the character to the right of the insertion point.
Ctrl + DeleteDelete text to the end of the line.
EscCancels an entry in the cell or Formula Bar.
Closes an open menu or submenu dialog box or message window.
It also closes full screen mode when this mode has been applied and returns to normal screen mode to display the Ribbon and status bar again.
HomeMoves to the beginning of a row in the worksheet.
Moves to the cell in the upper left corner of the window when Scroll Lock is turned on.
Shift + HomeSelect from the insertion point to the beginning of the entry.
Ctrl + Shift + HomeExtends the selection of cells to the beginning of the worksheet.
Ctrl + Shift + PgDnSelect the current and next sheet in a workbook.
Ctrl + Shift + PgUpSelect the current and previous sheet in a workbook.
Ctrl + SpacebarSelect an entire column in a worksheet.
Shift + SpacebarSelect an entire row in a worksheet.
Ctrl + Shift + SpacebarSelect the entire worksheet.
Ctrl + TabSwitches to the next tab in dialog box.
Ctrl + Shift + TabSwitches to the previous tab in a dialog box.
=Start of formula.
F2Edit the active cell.
F3Paste a name into a formula.
F4Repeat the last action.
EnterComplete a cell entry and move down in the selection.
Shift + EnterComplete a cell entry and move up in the selection.
Ctrl + EnterFill the selected cell range which the current entry.
Alt + EnterStart a new line in the same cell.
Ctrl + F2Displays the formula palette after you type of valid function name in a formula.
Ctrl + F3 Define a name.
Ctrl + F5Restore the active workbook window.
Ctrl + F6Switch to the next workbook window.
Ctrl + F7Carry out the move command.
Ctrl + F8Carry out the size command.
Ctrl + F9Minimize the workbook window to an icon.
Ctrl + F10Maximize or restore the workbook window.
Shift +F2Edit a cell comment.
Shift + F9Calculate the active worksheet.

Keyboard shortcuts for navigating the worksheet

Keyboard ShortcutFunction
→ or TabRight one cell.
← or Shift + TabLeft one cell.
Up one cell.
Down one cell.
Ctrl + →Last cell in the row.
Ctrl + ←First cell in the row.
Ctrl + ↑First cell in the column.
Ctrl + ↓Last cell in the column.
Ctrl + HomeFirst cell in the worksheet.
Ctrl + EndMove the cursor to the last cell of used space on the worksheet.
PgDnDown one screen.
PgUpUp one screen.
Alt + PgDnRight one screen.
Alt + PgUpLeft one screen.
Ctrl + PgDnNext sheet.
Ctrl + PgUpPrevious sheet.
EnterMove down one cell at a time.

Shortcut keys for Data Entry

Ctrl + ‘Copies the formula from the cell above.
Ctrl + “Copies the value from the cell above.
Ctrl + ;Inserts the current system date.
Ctrl + :Insert the current system time.
Shift + Ctrl + @Formats in h:mm AM/PM.
Shift + Ctrl + #Formats in d-mmm-yy.

About the author

Pooja Rastogi

Leave a Comment