MS Office Shortcut Key PDF

MS Word processors and Spreadsheets have been stapled software applications since the earliest days of the personal computer in business and official purposes. Microsoft Office became the first prominent productivity suite for presentation, database developers, email, scheduling and more, and it remains the standard for business users around the world.

To do frequent your official work by the computer you should remember and use All Computer shortcut keys for better performance and also save your time. Using this you should do a large number of tasks in less time frequently.

Nowadays every official work is done by Microsoft office at every stage. MS office Shortcut keys are an easier and quicker method of navigating commands on the computer. These are commonly accessed or work by using the Ctrl key, Alt key, or Shift key in conjunction with another key.

Here is a list of some of the most commonly used Microsoft Office shortcut keys that is word and Excel shortcut keys which helps to user to access easily in less time and frequently. It is also a part of General Knowledge for Competitive examination and also helps to aspirants in their Lab test or computer skill test in Railway NTPC and State PSU examination.

Microsoft Word Shortcut Keys

Shortcut Keys                              Functions
Ctrl + 1Sets single line spacing.
Ctrl + 2Sets double line spacing.
Ctrl + 5Sets line spacing to 1.5.
Ctrl + ASelects All /whole document.
Ctrl + BMakes selected text Bold.
Ctrl + CCopies a selection to the Clipboard.
Ctrl + DFont Options
Ctrl + EAligns text center.
Ctrl + FFinds text
Ctrl + IItalic selected text.
Ctrl + J Justify text.
Ctrl + K Make Hyperlink
Ctrl + LAligns text left.
Ctrl + MIncrease Indent Margin
Ctrl + NCreates a new document.
Ctrl + OOpens an existing document.
Ctrl + PPrints a document.
Ctrl + QRemove Indent Margin/Paragraph format
Ctrl + RAligns text right.
Ctrl + SSaves changes to a document.
Ctrl + THanging Indent
Ctrl + UUnderlines selected texts.
Ctrl + VPastes a selection from the Clipboard.
Ctrl + W Close document.
Ctrl + Xcut a selection
Ctrl + YRedo last action.
Ctrl + ZUndo the last action.
Ctrl + Shift + F Change the font.
Ctrl + Shift + > Increase font size
Ctrl + Shift + < Decrease font size
Ctrl +] Increase font size by +1.
Ctrl + [Decrease font size by -1
Ctrl + Shift +FChange Font
Ctrl + Shift +PChange Font size
Ctrl + Shift +WUnderline but not space
Ctrl + Shift +DDouble Underline but not space
Ctrl + Shift +KSmall Capital
Ctrl + Shift +AAll Capital
Ctrl + EndMoves to the end of the document.
Ctrl + HomeMoves to the beginning of the document.
Ctrl + Shift + * View or hide non printing characters.
Ctrl + Shift + (+)Superscript
Ctrl + (=)Subscript
Ctrl + (Left arrow) Move one word to the left.
Ctrl + (Right arrow) Move one word to the right.
Ctrl + (Up arrow) Move to the beginning of the line or paragraph.
Ctrl + (Down arrow) Move to the end of the paragraph.
Ctrl + Del Delete the word to the right of the cursor.
Ctrl + Backspace Delete the word to the left of the cursor.
Ctrl + End Move the cursor to the end of the document.
Ctrl + Home Move the cursor to the beginning of the document.
Ctrl + Space Reset highlighted text to the default font.
Ctrl + Alt + 1 Change text to heading 1.
Ctrl + Alt + 2 Change text to heading 2.
Ctrl + Alt + 3 Change text to heading 3.
F1 Open Help.
F2Move Text
F3Insert Auto Text
F4Repeat the last action performed (Word 2000+).
F5Go to
F6Go to next frame
F7 Spelling check selected text and/or document.
F8Extend a selection
F9Update Selected Field
F10Active the Menu Bar
F11Go to next field
F12Saves the document as a new file/ Save as (file menu)
Shift + F12 Save.
Shift + F3 Change case of selected text.
Shift + Insert Paste.
Shift + F7 Activate the thesaurus.
Alt + Shift + D Insert the current date.
Alt + Shift + T Insert the current time.

MS EXCEL SHORTCUT KEYS

Shortcut keysFunction
TabMove to the next cell, /to the right of the currently selected cell.
Ctrl+ASelect all contents of a worksheet.
Ctrl+BBold all cells in the highlighted section.
Ctrl+CCopy all cells in the highlighted section.
Ctrl+D         Fill down.
Ctrl+FSearch the current sheet.
Ctrl+GGo to a certain area.
Ctrl+HFind and replace.
Ctrl+IPuts italics on all cells in the highlighted section
Ctrl+KInserts a hyperlink.
Ctrl+NCreates a new workbook.
Ctrl+OOpens a workbook.
Ctrl+PPrint the current sheet.
Ctrl+RFill right cell.
Ctrl+SSaves the open worksheet.
Ctrl+UUnderlines all cells in the highlighted section.
Ctrl+VPastes everything copied onto the clipboard.
Ctrl+WCloses the current workbook.
Ctrl+XCuts all cells in the highlighted section.
Ctrl+YRepeats the last entry.
Ctrl+ZUndo the last action.
Ctrl+1Changes the format of the selected cells.
Ctrl+2Bold all cells in the highlighted section.
Ctrl+3Puts italics all cells in the highlighted section.
Ctrl+4Underlines all cells in the highlighted section.
Ctrl+5Puts a strike-through of all cells in the highlighted section.
Ctrl+6Shows or hides objects.
Ctrl+7Shows or hides the toolbar.
Ctrl+8Toggles the outline symbols.
Ctrl+9Hides rows.
Ctrl+0Hides columns.
Ctrl+Shift+:Enters the current time.
Ctrl+;Enters the current date.
Ctrl+`Changes between displaying cell values or formulas in the worksheet.
Ctrl+’Copies a formula from the cell above.
Ctrl+Shift+”Copies value from the cell above.
Ctrl+-Deletes the selected column or row.
Ctrl+Shift+=Inserts a new column or row.
Ctrl+Shift+~Switches between showing Excel formulas or their values in cells.
Ctrl+Shift+@Applies time formatting.
Ctrl+Shift+!Applies comma formatting.
Ctrl+Shift+$Applies currency formatting.
Ctrl+Shift+#Applies date formatting.
Ctrl+Shift+%Applies percentage formatting.
Ctrl+Shift+^Applies exponential formatting.
Ctrl+Shift+*Selects the current region around the active cell.
Ctrl+Shift+&Place the border around selected cells.
Ctrl+Shift+_Removes a border.
Ctrl++Insert.
Ctrl+-Delete.
Ctrl+Shift+(Unhide rows.
Ctrl+Shift+)Unhide columns.
Ctrl+/Selects the array containing the active cell.
Ctrl+\Selects the cells that have a static value or don’t match the formula in the active cell.
Ctrl+[Selects all cells referenced by formulas in the highlighted section.
Ctrl+]Selects cells that contain formulas that reference the active cell.
Ctrl+Shift+{Selects all cells directly or indirectly referenced by formulas in the highlighted section.
Ctrl+Shift+}Selects cells that contain formulas that directly or indirectly reference the active cell.
Ctrl+Shift+| (pipe)Selects the cells within a column that don’t match the formula or static value in the active cell.
Ctrl+EnterFills the selected cells with the current entry.
Ctrl+SpacebarSelects the entire column.
Ctrl+Shift+SpacebarSelects the entire worksheet.
Ctrl+HomeMove to cell A1/first cell.
Ctrl+EndMove to the last cell on the worksheet.
Ctrl+TabMove between Two or more open Excel files.
Ctrl+Shift+TabActivates the previous workbook.
Ctrl+Shift+AInserts argument names into a formula.
Ctrl+Shift+FOpens the drop-down menu for fonts.
Ctrl+Shift+OSelects all of the cells that contain comments.
Ctrl+Shift+POpens the drop-down menu for the point size.
Shift+InsertPastes what is stored on the clipboard.
Shift+HomeHighlights all text to the left of the cursor.
Shift+EndHighlights all text to the right of the cursor.
Shift+Up ArrowExtends the highlighted area up to one cell.
Shift+Down ArrowExtends the highlighted area down one cell.
Shift+Left ArrowExtends the highlighted area left one character.
Shift +Right ArrowExtends the highlighted area right one character.
Alt+TabCycles through applications.
Alt+SpacebarOpens the system menu.
Alt+BackspaceUndo.
Alt+Entermove to the next line,/allowing for multiple lines of text in one cell.
Alt+=Creates a formula to sum all of the above cells.
Alt+’Allows formatting on a dialog box.
F1Opens the help menu.
F2Edits the selected cell.
F3After a name has been created, F3 will paste names.
F4Repeats the last action.
F5Goes to a specific cell.
F6Move to the next pane.
F7Spell check selected text or document.
F8Enters Extend Mode.
F9Recalculates every workbook.
F10Activates the menu bar.
F11Creates a chart from selected data.
F12Save As option.
Shift+F1Opens the “What’s This?” window.
Shift+F2Allows the user to edit a cell comment.
Shift+F3Opens the Excel formula window.
Shift+F5Brings up a search box.
Shift+F6Move to the previous pane.
Shift+F8Add to selection.
Shift+F9Performs calculate function on the active sheet.
Ctrl+F3Open Excel Name Manager.
Ctrl+F4Closes current Windows.
Ctrl+F5Restores window size.
Ctrl+F6Next workbook.
Ctrl+Shift+F6Previous workbook.
Ctrl+F7Moves the window.
Ctrl+F8Resizes the window.
Ctrl+F9Minimize the current window.
Ctrl+F10Maximize the currently selected window.
Ctrl+F11Inserts a macro sheet.
Ctrl+F12Opens a file.
Ctrl+Shift+F3Creates names by using those of either row or column labels.
Ctrl+Shift+F6Moves to the previous worksheet window.
Ctrl+Shift+F12Prints the current worksheet.
Alt+F1Inserts a chart.
Alt+F2Save As option.
Alt+F4Exits Excel.
Alt+F8Opens the macro dialog box.
Alt+F11Opens the Visual Basic editor.
Alt+Shift+F1Creates a new worksheet.
Alt+Shift+F2Saves the current worksheet.

You can read also:

Here we provide all MS Office shortcut keys and their functions. If you have some other shortcut keys related to this topic or which are not mentioned here, please leave a comment and we will include it.

Thank you for reading

Leave a Comment

Copy link