Most Used Microsoft Office Shortcut Keys

If you are familiar with Microsoft Office then you should want to know about Microsoft Office Shortcut Keys of MS Word Shortcut Keys, Microsoft PowerPoint Shortcut Keys, and Microsoft Excel Shortcut Keys to complete your documents. Here are the best and most used MS Office Shortcut Keys.

Now does anyone expect you to memorize all these keyboard combos? Absolutely not! Each person’s needs are different, so some will be more useful to you than others. And even if you only choose a few new tactics, it’s worth it. We’ve also tried to keep the list clean, so go ahead and print it out, which helps you to do best.

Microsoft Word Shortcut Keys:-

Microsoft Office is the collection of programs & Microsoft Word is the most used app in that collection. We are to give you the collection of MS Word Shortcut Keys and these are the best and most used keys of Microsoft Word. These shortcut keys are with the alphabetical sequence.

Here are the MS Word Shortcut Keys with description. We highly recommended opening Microsoft Word and apply the shortcut keys on your documents and you will remember the Shortcut keys for the next projects. Here are the details:

Ctrl + Letters:-

Sr #Shortcut KeyDescription
1Ctrl+0Toggles 6pts of spacing above the paragraph.
2Ctrl+ASelect all contents of the page.
3Ctrl+BBold highlighted selection.
4Ctrl+CCopy selected text.
5Ctrl+DOpen the font preferences window.
6Ctrl+EAligns the line or selected text to the center of the screen.
8Ctrl+FOpen find box.
9Ctrl+IItalic highlighted selection.
10Ctrl+JAligns the selected text or line to justify the screen.
11Ctrl+KInsert a hyperlink.
12Ctrl+LAligns the line or selected text to the left of the screen.
13Ctrl+MIndent the paragraph.
14Ctrl+NOpens new, blank document window.
15Ctrl+OOpens the dialog box or page for selecting a file to open.
16Ctrl+POpen the print window.
17Ctrl+RAligns the line or selected text to the right of the screen.
18Ctrl+SSave the open document. Like Shift+F12.
19Alt+XShow the Unicode code of a highlighted character.
20Ctrl+TCreate a hanging indent.

Ctrl + Others:-

Sr #Shortcut KeyDescription 
21Ctrl+UUnderline the selected text.
22Ctrl+VPaste.
23Ctrl+WClose the currently open document.
24Ctrl+XCut selected text.
25Ctrl+YRedo the last action performed.
26Ctrl+ZUndo last action.
27Ctrl+Shift+LQuickly create a bullet point.
28Ctrl+Shift+FChange the font.
29Ctrl+Shift+>Increase selected font +1pts up to 12pt and then increase font +2pts.
30Ctrl+]Increase selected font +1pts.
31Ctrl+Shift+<Decrease selected font -1pts if 12pt or lower; if above 12, decreases font by +2pt.
32Ctrl+[Decrease selected font -1pts.
33Ctrl+/+cInsert a cent sign (¢).
34Ctrl+’+<char>Insert a character with an accent (acute) mark, where <char> is the character you want. For example, if you wanted an accented é you would use Ctrl+’+e as your shortcut key. To reverse the accent mark, use the opposite accent mark, often found on the tilde key.
35Ctrl+Shift+*View or hide non printing characters.
36Ctrl+<left arrow>Moves one word to the left.
37Ctrl+<right arrow>Moves one word to the right.
38Ctrl+<up arrow>Moves to the beginning of the line or paragraph.
39Ctrl+<down arrow>Moves to the end of the paragraph.
40Ctrl+DelDeletes word to right of cursor.

Ctrl + Shift & Functions:-

Sr #Shortcut KeyDescription
41Ctrl+BackspaceDeletes word to left of cursor.
42Ctrl+EndMoves the cursor to the end of the document.
43Ctrl+HomeMoves the cursor to the beginning of the document.
44Ctrl+SpacebarReset highlighted text to the default font.
45Ctrl+1Single-space lines.
46Ctrl+2Double-space lines.
47Ctrl+51.5-line spacing.
48Ctrl+Alt+1Changes text to heading 1.
49Ctrl+Alt+2Changes text to heading 2.
50Ctrl+Alt+3Changes text to heading 3.
51Alt+Ctrl+F2Open new document.
52Ctrl+F1Open the Task Pane.
53Ctrl+F2Display the print preview.
54Ctrl+Shift+>Increases the selected text size by one font size.
55Ctrl+Shift+<Decreases the selected text size by one font size.
56Ctrl+Shift+F6Switches to another open Microsoft Word document.
57Ctrl+Shift+F12Prints the document.
58F1Open help.
59F4Repeat the last action performed (Word 2000+).
60F5Open the Find, Replace, and Go To window in Microsoft Word.
61F7Spellcheck and grammar check selected text or document.
62F12Save As.
63Shift+F3Change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
64Shift+F7Runs a Thesaurus check on the selected word.
65Shift+F12Save the open document. Like Ctrl+S.
66Shift+EnterCreate a soft break instead of a new paragraph.
67Shift+InsertPaste.
68Shift+Alt+DInsert the current date.
69Shift+Alt+TInsert the current time.

Microsoft PowerPoint Shortcut Keys:-

Microsoft PowerPoint is a presentation program, created by Robert Gaskins and Dennis Austin at a software company named Forethought, Inc. It was released on April 20, 1987, initially for Macintosh computers only. Microsoft acquired PowerPoint for $14 million three months after it appeared. This was Microsoft’s first significant acquisition, and Microsoft set up a new business unit for PowerPoint in Silicon Valley where Forethought had been located. Here you can get the best and most used Microsoft PowerPoint Shortcut Keys and these are the best collection of shortcut keys.

Function Keys:-

These are the function Shortcut Keys that are used in MS PowerPoint.

Sr #Shortcut KeyDescription
1F1Display Help or the Office Assistant
2F2Select the text box containing an object or text
3F4Repeats the last presentation action (Edit > Repeat) (not Format Auto shape dialog)
4F5Runs the presentation (View > Slide Show)
5F6Moves to the next pane in the presentation (clockwise)
6F7Displays the (Tools > Spelling) dialog box
7F10Toggles the activation of the Menu Bar
8F12Displays the (File > Save As) dialog box
9  
10  

Shift + Function Keys:-

These keys are used by pressing Ctrl + Function keys. Here are details:

Sr #Shortcut KeyDescription
1Shift + F1Activates the context sensitive What’s this? prompt (Help > What’s This)
2Shift + F3Toggles between lowercase, mixed case and uppercase on the selection
3Shift + F4Repeat the last Find, the same as (Edit > Find Next)
4Shift + F6Moves to the previous pane in the presentation (anti-clockwise)
5Shift + F9Toggles the display of Guide Lines
6Shift + F10Display the (Shortcut) menu for the selected item
7Shift + F12Saves, Displays the (File > Save As) dialog box if a new presentation
8 
9 
10 

Ctrl + Function Keys:-

Here the collection of MS PowerPoint Shortcut Keys that are generated with Ctrl + Function keys. Here are details:

Sr #Shortcut KeyDescription
1Ctrl + F4Closes the active presentation or window (File > Close)
2Ctrl + F5Restore the size of the active presentation or window
3Ctrl + F6Moves to the next presentation window
4Ctrl + F7Activates the Move window command
5Ctrl + F8Activates the Resize window command
6Ctrl + F9Minimizes the size of the active presentation or window
7Ctrl + F10Maximize the size of the active presentation or window
8Ctrl + F12Displays the (File > Open) dialog box
9 
10 

Alt + Function Keys:-

Sr #Shortcut KeyDescription
1Alt + F2Displays the (File > Save As) dialog box
2Alt + F4Closes the active presentation (saving first) and exits PowerPoint (File > Exit)
3Alt + F5Restore the program window size
4Alt + F7Find next misspelt word – continue (Tools > Spelling) ??
5Alt + F8Displays the (Tools > Macros > Macro) dialog box
6Alt + F9Toggles the display of the Grid
7Alt + F10Maximize the program window
8Alt + F11Toggles between the Visual Basic Editor window and the PowerPoint window
9Alt + Shift + F2Displays the (File > Save As) dialog box
10Alt + Shift + F4Closes the active presentation (saving first) and exits PowerPoint (File > Exit)
11Alt + Shift + F10Displays the drop-down menu for the corresponding smart tag
12Ctrl + Shift + F10Activates the Menu Bar or displays the (View > Toolbars) dialog box
13Ctrl + Shift + F12Displays the (File > Print) dialog box

Ctrl + Numbers Keys:-

Sr #Shortcut KeyDescription
1Alt + Shift + 1Show Heading 1 (Outline view)
2Alt + Shift + 9Expands all text in the presentation (Outline view)

Ctrl + Letters Keys:-

Sr #Shortcut KeyDescription
1Ctrl + ASelects all the objects on the active slide
2Ctrl + BToggles bold on the current selection
3Ctrl + CCopies the current selection to the clipboard (Edit > Copy)
4Ctrl + DMake a duplicate of the selected slide (Edit > Duplicate)
5Ctrl + ECentre aligns the current selection
6Ctrl + FDisplays the (Edit > Find) dialog box
7 Ctrl + GDisplays the (View > Grid and Guides) dialog box
8Ctrl + HDisplays the (Edit > Replace) dialog box
9Ctrl + IToggles italics on the current selection
10Ctrl + JJustifies the current selection
11Ctrl + KDisplays the (Insert > Hyperlink) dialog box (in a textbox)
12Ctrl + LLeft aligns the current selection
13Ctrl + MInserts a new slide (Insert > New Slide)
14Ctrl + NCreates a new presentation (File > New)
15Ctrl + ODisplays the (File > Open) dialog box
16Ctrl + PDisplays the (File > Print) dialog box
17Ctrl + RRight aligns the current selection
18Ctrl + SSaves, Displays the (File > Save As) dialog box if a new presentation
19Ctrl + TDisplays the (Format > Font) dialog box
20Ctrl + UToggles (continuous) underlying of the selection
21Ctrl + VPastes the entry from the clipboard (Edit > Paste)
22Ctrl + WCloses the active presentation or window (File > Close)
23Ctrl + XCuts the current selection to the clipboard (Edit > Cut)
24Ctrl + YRepeats the last Presentation action (Edit > Repeat)

Others + Letters:-

These shortcut keys are generate command by Ctrl, Alt, and letters. Let’s start:

Sr #Shortcut KeyDescription
1Ctrl + Shift + BOpens the Outlook Address Book
2Ctrl + Shift + CCopies the formatting attributes from the current selection to the clipboard
3Ctrl + Shift + FActivates the Font Names drop-down on the Formatting toolbar
4Ctrl + Shift + GGroup the currently selected objects / shapes
5Ctrl + Shift + HUngroups the currently selected object / shape
6Ctrl + Shift + PActivates the Font Size drop-down on the Formatting toolbar
7Ctrl + Shift + VPastes the formatting attributes from the clipboard on to the selection
8Alt + DDisplays the (Slide Show) menu
9Alt + EDisplays the (Edit) menu
10Alt + FDisplays the (File) menu
11Alt + HDisplays the (Help) menu
12Alt + IDisplays the (Insert) menu
13Alt + KChecks the names in the To, Cc and Bcc lines against the Address Book
16Alt + ODisplays the (Format) menu
17Alt + SDisplays an e-mail message containing the active presentation
18Alt + TDisplays the (Tools) menu
19Alt + UDisplays the AutoShapes drop-down menu on the Drawing toolbar
20Alt + VDisplays the (View) menu
21Alt + WDisplays the (Window) menu
22Alt + Shift + AShow all or collapse all text or headings (Outline view)

Entering & Extending Data:-

These PowerPoint Short Keys belongs to Entering & Extending Data in a document.

Sr #Shortcut KeyDescription
1EnterEnters a new paragraph
2Shift + EnterEnters a line break (Soft break)
3Ctrl + TabInserts a tab in a table cell
4Shift + HomeExtends the selection to the beginning of the line
5Shift + EndExtends the selection to the end of the line
6Shift + Up ArrowExtends the selection one line up
7Shift + Down ArrowExtends the selection one line down
8Shift + Left ArrowExtends the selection one character to the left
9Shift + Right ArrowExtends the selection one character to the right
10Ctrl + Shift + HomeExtends the selection to the beginning of the textbox
11Ctrl + Shift + EndExtends the selection to the end of the textbox

Select & Format Data:-

By using these shortcut keys you can select & format your documents data. Let’s apply these keys:

Sr #Shortcut KeyDescription
1Ctrl + Shift + Up ArrowSelects to the line above
2Ctrl + Shift + Down ArrowSelects to the line below
3Ctrl + Shift + Left ArrowSelects to the beginning of the word
4Ctrl + Shift + Right ArrowSelects to the end of the word
5DeleteDeletes one character to the right
6BackspaceDeletes one character to the left
7Ctrl + DeleteDeletes one word to the right
8Ctrl + BackspaceDeletes one word to the left
9Ctrl +]Increases the font size to the next size in the drop-down list
10Ctrl + [Decreases the font size to the next size in the drop-down list
11Ctrl + Shift + >Increases the font size to the next size in the drop-down list
12Ctrl + Shift + <Decreases the font size to the next size in the drop-down list
13Ctrl + =Toggles Subscript on the selection
14Ctrl + Shift + =Toggles Superscript on the selection
   

Maneuvering:-

These keys will perform their functions by using Tab key, Enter key, Del and also with Shift, Alt and Ctrl key. These are very important keys and most used in documentation.

Sr #Shortcut KeyDescription
1Arrow KeysMoves one character or line in the given direction
2TabMoves to the first or next hyperlink / object / cell
3Shift + TabMoves to the last or previous hyperlink / object / cell
4HomeMoves to the beginning of the line
5EndMoves to the end of the line
6Page UpMoves to the previous slide
7Page DownMoves to the next slide
8Shift + Page UpMoves to the previous slide
9Shift + Page DownMoves to the next slide
10Ctrl + HomeMoves to the beginning of the text box
11Ctrl + EndMoves to the end of the text box
12Ctrl + Up ArrowMoves up one paragraph
13Ctrl + Down ArrowMoves down one paragraph
14Ctrl + Left Arrow Moves one word to the left
15Ctrl + Right ArrowMoves one word to the right
16Ctrl + EnterMoves to the next title or body text placeholder

‏Microsoft Excel Shortcut Keys:-

Microsoft Excel is the most used application in offices. Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Here the huge number of Microsoft Excel Shortcut Keys that used to format and compose a document in MS Excel.

These shortcut keys are separated by Function keys, Ctrl, Alt, and other keys. These are the total shortcut keys of Microsoft Excel.

Function Keys:-

These keys are generated by press function keys like F1, F2 and so on. Let’s start:

Sr #Shortcut KeyDescription
1F1Displays the Excel Task Pane.
2F2Allows you to edit the active cell directly, putting the cursor at the end. This is only available when the following option is ticked. (Advanced, editing options – allow editing directly in cells). If this option is not checked the cursor will move to the Formula Bar.
3F3Displays the Paste Name dialog box. This dialog box is only displayed if the active workbook contains at least one named range.
4F4When you are not editing a cell, this repeats the last command or action. When you are editing a cell this toggle between relative, absolute and mixed cell references.
5F5Displays the Go To dialog box.
6F6Moves to the next item (worksheet, ribbon, task pane).
7F7Displays the Spelling dialog box.
8F8Toggles whether to extend a selection with the arrow keys. You will see the text “Extend Selection” appear in the status bar.
9F9Smart Recalculation. Calculates All the worksheets in All the open workbooks.
10F10Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
11F11Creates a chart (on a separate chart sheet) using the highlighted range as the data source.
12F12Displays the Save As dialog box.

Shift + Functions:-

These shortcut keys are generated by pressing Shift + Functions Keys.

 Sr #Shortcut KeyDescription
1Shift + F1Redundant see last table below.
2Shift + F2Inserts or edits a cell comment.
3Shift + F3Displays the Insert Function dialog box (can be used from the formula bar).
4Shift + F4Repeats the last Find. Selects the next empty cell on the right inside the used range of the active worksheet.
5Shift + F5Displays the Find and Replace dialog box with the Find tab active.
6Shift + F6Switches between the following items: worksheet, ribbon and status bar zoom. If a task pane is displayed this is included. If the worksheet has been split then each separate pane is included.
7Shift + F7Displays the Thesaurus task pane.
8Shift + F8Toggles between switching Add Mode on or off. This allows you to select noncontiguous blocks of cells using the keyboard arrow keys. You will see the text “Add to Selection” appear in the status bar.
9Shift + F9Smart Recalculation. Calculates the Active worksheet in the Active workbook.
10Shift + F10Displays the Shortcut menu for the selected item.
11Shift + F11Inserts a new worksheet (before the active sheet) into the active workbook.
12Shift + F12Saves. Displays the Save As dialog box when it’s a new workbook.

Ctrl + Functions:-

Ctrl + Function keys will generate useful keys to format a document.

Sr #Shortcut KeyDescription
1Ctrl + F1Toggles the display of the Ribbon.
2Ctrl + F2Displays the Print Options on the File tab.
3Ctrl + F3Displays the Name Manager dialog box.
4Ctrl + F4Closes the active workbook or window (saving first).
5Ctrl + F5Restores the size of the active workbook or window.
6Ctrl + F6Moves to the next open workbook or window.
7Ctrl + F7Activates the Move window command.
8Ctrl + F8Activates the Resize window command.
9Ctrl + F9Minimizes the size of the active workbook or window.
10Ctrl + F10Toggles between maximizing and restoring the size of the active workbook or window.
11Ctrl + F11Redundant see last table below.
12Ctrl + F12Displays the Open dialog box.

Others + Functions:-

These keys are generated by pressing Ctrl , Alt, Shift, Functions keys.

Sr #Shortcut KeysDescriptions
1Alt + F2Displays the Save As dialog box.
2Alt + F4Closes the active workbook or window (saving first).
3Alt + F8Displays the Macro dialog box.
4Alt + F11Toggles between the Visual Basic Editor window and the Excel window.
5Alt + Ctrl + F2Displays the Open dialog box.
6Alt + Ctrl + F3Displays the New Name dialog box.
7Alt + Ctrl + F4Closes the active workbook or window (saving first).
8Alt + Ctrl + F9Calculates All the worksheets in All the open workbooks.
9Alt + Shift + F1Inserts a new worksheet (before the active sheet) into the active workbook.
10Alt + Shift + F2Displays the Save As dialog box.
11Alt + Shift + F4Closes the active workbook or window (saving first).
12Alt + Shift + F10Displays the drop-down menu for the smart tag indicator that is showing in the active cell.
13Alt + Shift + F11Redundant see last table below.
14Ctrl + Shift + F1Toggles full screen.
15Ctrl + Shift + F3Displays the Create Names from Selection dialog box.
16Ctrl + Shift + F4Repeats and finds the previous match. Selects the next empty cell on the left inside the used range of the active worksheet.
17Ctrl + Shift + F6Moves to the previous open workbook or window.
18Ctrl + Shift + F9Full Calculation. Calculates All the worksheets in All the open workbooks.
19Ctrl + Shift + F10Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
20Ctrl + Shift + F12Displays the Print Options on the File tab.
21Alt + Ctrl + Shift + F2Displays the Print Options on the File tab.
22Alt + Ctrl + Shift + F4Closes the active workbook or window (saving first).
23Alt + Ctrl + Shift + F9Recalculation. Calculates All the worksheets in All the open workbooks.
(rebuilding the dependency tree and calculation chain).

Ctrl + Numbers:-

These keys contains on Ctrl + numbers.

Sr #ShortcutDescriptions
1Ctrl + 0Hides the columns in the current selection.
2Ctrl + 1Displays the Format Cells dialog box (not using the keypad).
3Ctrl + 2Toggles bold on the current selection.
4Ctrl + 3Toggles italics on the current selection.
5Ctrl + 4Toggles underlying on the current selection.
6Ctrl + 5Toggles the strikethrough of text on the current selection.
7Ctrl + 6Toggles between showing all objects or showing no objects in the active workbook. This option can be found under (Advanced, Display options for this workbook – For objects show).
8Ctrl + 7Allows you to move/reposition the entire Excel window using the arrow keys.
9Ctrl + 8Toggles the display of Outline Symbols on the active worksheet.
10Ctrl + 9Hides the rows in the current selection.
11Ctrl + Shift + 0Unhides the columns in the current selection.
12Ctrl + Shift + 1Applies the Comma separated format “#, ##0.00” to the selection.
13Ctrl + Shift + 2Enters the value from the cell directly above into the active cell.
14Ctrl + Shift + 4Applies the Currency format “£#, ##0.00” to the selection.
15Ctrl + Shift + 5Applies the Percentage format “0%” to the selection.
16Ctrl + Shift + 6Applies the Exponential format “#, ##E+02” to the selection.
17Ctrl + Shift + 7Applies a thin black border around the outside of the selected cells.
18Ctrl + Shift + 8Selects the Current Region (surrounded by blank rows and columns).
19Ctrl + Shift + 9Unhides the rows in the current selection.

Ctrl + Letters:-

These keys are generated by pressing Ctrl and letters.

Sr #Shortcut KeyDescription
1Ctrl + ASelects the entire worksheet, or the current region if the active cell contains a value, or the whole table (excluding heading) if the active cell is in a table. It can also display the Function Arguments dialog box if you have typed a function.
2Ctrl + A, ASelects the whole worksheet if the active cell contains a value.
3Ctrl + BToggles bold on the current selection.
4Ctrl + CCopies the current selection to the clipboard.
5Ctrl + DEnters the value from the cell directly above into the active cell.
6Ctrl + EPopulates the selected cells using a Flash Fill recognized pattern.
7Ctrl + FDisplays the Find and Replace dialog box with the Find tab active.
8Ctrl + GDisplays the Go To dialog box.
9Ctrl + HDisplays the Find and Replace dialog box with the Replace tab active.
10Ctrl + IToggles italics on the current selection.
11Ctrl + KDisplays the Insert Hyperlink dialog box.
12Ctrl + LDisplays the Create Table dialog box.
13Ctrl + NCreates a New (default) workbook.
14Ctrl + ODisplays the Open Options on the File tab.
15Ctrl + PDisplays the Print Options on the File tab.
16Ctrl + QDisplays the Quick Analysis smart tag.
17Ctrl + REnters the value from the cell directly to the left into the active cell.
18Ctrl + SSaves. Displays the Save As Options on the File tab when its a new workbook.
19Ctrl + TDisplays the Create Table dialog box.
20Ctrl + UToggles underlining on the current selection.
21Ctrl + VPastes the entry from the clipboard. You can also use Enter to paste the entry.
22Ctrl + WCloses the active workbook or window (saving first).
23Ctrl + XCuts the current selection to the clipboard.
24Ctrl + YRedo the last Excel operation. This can be used to redo multiple steps. This can also be used to repeat applied formatting.
25Ctrl + ZUndo the last Excel operation. This can be used to undo multiple steps.

Other + Letters:-

These keys are generated by pressing Alt, Ctrl, Shift with letters and numbers.

Sr #Shortcut KeyDescription
1Alt + ADisplays the Data Tab.
2Alt + CClear slicer filter.
3Alt + DRedundant see last table below.
4Alt + ERedundant see last table below.
5Alt + FDisplays the File Tab.
6Alt + F, TDisplays the Excel Options dialog box.
7Alt + HDisplays the Home Tab.
8Alt + IRedundant see last table below.
9Alt + LDisplays the Developer Tab.
10Alt + MDisplays the Formulas Tab.
11Alt + NDisplays the Insert Tab.
12Alt + ORedundant see last table below.
13Alt + PDisplays the Page Layout Tab.
14Alt + P, R, SSets the print area to the current selection.
15Alt + QActivate the Tell Me Box.
16Alt + RDisplays the Review Tab.
17Alt + TRedundant see last table below.
18Alt + VRedundant see last table below.
19Alt + WDisplays the View Tab.
20Alt + XDisplays the Add-ins tab.
21Ctrl + Shift + AInserts Function Arguments when the insertion point is to the right of a function name.
22Ctrl + Shift + FDisplays the Format Cells dialog box with the Font tab active.
23Ctrl + Shift + LToggle the display of the AutoFilter drop-downs. Also provides a quick way of clearing all the current filters.
24Ctrl + Shift + OSelects all the cells with comments.
25Ctrl + Shift + PDisplays the Format Cells dialog box with the Font tab active.
26Ctrl + Shift + UToggles the display of a multi-line Formula Bar.
27Ctrl + Shift + VDisplays the Paste Special dialog box.
28Ctrl + Shift + ZUndo or redo the last automatic correction (AutoCorrect Smart Tag) – Unable to recreate.

Entering Data:-

To enter data these keys are used mostly.

Sr #Shortcut KeyDescription
1=Start a Formula.
2EnterEnters the contents of the active cell and moves to the cell below.
3Alt + EnterEnters a new line (or carriage return) into a cell.
4Shift + EnterEnters the contents of the active cell and moves to the cell above (opposite direction to Enter).
5TabEnters the contents of the active cell and moves one cell to the right.
6Shift + TabEnters the contents of the active cell and moves one cell to the left (opposite direction to Tab).
7Alt + =Enters the SUM function (Auto Sum) to sum the adjacent block of cells.
8Alt + 0128Enters the euro symbol (€) (using Number keypad).
9Alt + 0162Enters the cent symbol (¢) (using Number keypad).
10Alt + 0163Enters the pound sign symbol (£) (using Number keypad).
11Alt + 0165Enters the yen symbol (¥) (using Number keypad).
12Ctrl + “Enters the value from the cell directly above into the active cell.
13Ctrl + ‘Enters the formula from the cell directly above into the active cell.
14Ctrl + Shift + 2Enters the value from the cell directly above into the active cell.
15Ctrl + ;Enters the Current Date into the active cell and applies the default regional setting date format.
16Ctrl + EnterEnters the contents of the active cell to the selected region.
17Ctrl + Shift +;Enters the Current Time into the active cell and applies the time format hh: mm in 24-hour notation.
18Ctrl + Shift + EnterEnters the formula of the active cell to the selected region as an Array Formula.
19Shift + InsertEnters the data from the clipboard.
20Alt + Down ArrowDisplays the Pick from List drop-down list.
21EscCancels the cell entry and restores the original contents or closes full screen view.

Edit & Extending Data:-

By using these keys you can edit and extending data.

Sr #Shortcut KeyDescription
1Ctrl + `Toggles between displaying cell values and formulas (single left quotation mark).
2DeleteDeletes the selection or one character to the right.
3BackspaceDeletes the selection or one character to the left.
4Shift + DeleteCuts the selection to the clipboard.
5Ctrl + DeleteDeletes text to the end of the line.
6Ctrl + –Displays the Delete dialog box.
7Ctrl + Shift + =Displays the Insert dialog box.
8Alt + ;Selects the visible cells in the current selection.
9Alt + ;Selects the visible cells in the current selection.
10Ctrl + \Selects all the cells in the current selection that do not match the value in the active cell. Select the cells first and then use the Tab key to change the active cell.
11Ctrl + /Selects all the cells that are part of the Same Array Formula which has been entered into the active cell.
12Ctrl + Shift + (8 or *)Selects the Current Region (surrounded by blank rows and columns).
13Ctrl + *Selects the Current Region (using the * on the number keyboard).
14Ctrl + [Selects all the cells that are directly referred to by the formula in the active cell (precedents).
15Ctrl + Shift + [Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell.
16Ctrl + ]Selects all the cells that directly refer to the active cell (dependents).
17Ctrl + Shift + ]Selects all the cells that directly (or indirectly) refer to the active cell.
18Ctrl + Shift + Left ArrowSelects one word to the left.
19Ctrl + Shift + Right ArrowSelects one word to the right.
20Ctrl + Shift + Page DownSelects the active worksheet and the one after it.
21Ctrl + Shift + Page UpSelects the active worksheet and the one before it.
22Ctrl + Shift + SpacebarSelect the Whole Table.
Selects all the objects on the worksheet when an object is selected or selects the whole worksheet.
23Ctrl + Shift + EndSelects all the text after the cursor in the formula bar.
24Ctrl + BackspaceSelects the current active cell (scrolling if necessary).
25Ctrl + SpacebarSelects the entire column when the active cell is not inside a table.
Selects the current column (without headers) when the active cell is inside a table. When pressed again the selection will include the table header row. When pressed again the entire column is selected.
26Shift + Arrow keysSelects the active cell and the cell in the given direction.
27Shift + BackspaceSelects the active cell when multiple cells are selected.
29Shift + SpacebarSelects the entire row when the active cell is not inside a table.
Selects the current row when the active cell is inside a table. When pressed again the entire row is selected.
29Shift + HomeSelects all the cells in the current row between the active cell and the first column.

Final words:-

These are the collection of Microsoft Office Shortcut Keys that contain MS Word, MS PowerPoint and MS Excel. We hope these shortcut keys will help you in your document formatting. If you have any key, please send us we will add it in our list.

Leave a Comment