M.S Excel Shortcut Keys

M.S  Excel Shortcut Keys
Posted by AK STAR CLUB
Your Ads Here

Shortcut Keys

This is a complete list of all the shortcut keys in Excel.

Function Keys

F1Displays the Help Task Pane.
F2Allows 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.
F3Displays the Paste Name dialog box. This dialog box is only displayed if the active workbook contains at least one named range.
F4When you are not editing a cell this repeats the last command or action. When you are editing a cell this toggles between relative, absolute and mixed cell references.
F5Displays the GoTo dialog box.
F6Moves to the next item (worksheet, ribbon, task pane).
F7Displays the Spelling dialog box.
F8Toggles whether to extend a selection with the arrow keys. You will see the text "Extend Selection" appear in the status bar.
F9Smart Recalculation. Calculates All the worksheets in All the open workbooks.
(only cells containing formulas that have changed since the last calculation will be updated).
Replaces the highlighted part of a formula with its result to help debug when using the formula bar.
F10Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
F11Creates a chart (on a separate chart sheet) using the highlighted range as the data source.
F12Displays the Save As dialog box.


Shift + Function

Shift + F1Redundant see last table below.
Shift + F2Inserts or edits a cell comment.
Shift + F3Displays the Insert Function dialog box (can be used from the formula bar).
Shift + F4Repeats the last Find. Selects the next empty cell on the right inside the used range of the active worksheet.
Shift + F5Displays the Find and Replace dialog box with the Find tab active.
Shift + 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.
Shift + F7Displays the Thesaurus task pane.
Shift + F8Toggles between switching Add Mode on or off. This allows you to select non contiguous blocks of cells using the keyboard arrow keys. You will see the text "Add to Selection" appear in the status bar.
Shift + F9Smart Recalculation. Calculates the Active / Selected worksheets in the Active workbook.
(only cells containing formulas that have changed since the last calculation will be updated).
Shift + F10Displays the Shortcut menu for the selected item.
Shift + F11Inserts a new worksheet (before the active sheet) into the active workbook.
Shift + F12Saves. Displays the Save As dialog box when its a new workbook.


Ctrl + Function

Ctrl + F1Toggles the display of the Ribbon.
Ctrl + F2Displays the Print Options on the File tab.
Ctrl + F3Displays the Name Manager dialog box.
Ctrl + F4Closes the active workbook or window (saving first).
Ctrl + F5Restores the size of the active workbook or window.
Ctrl + F6Moves to the next open workbook or window.
Ctrl + F7Activates the Move window command.
Ctrl + F8Activates the Resize window command.
Ctrl + F9Minimises the size of the active workbook or window.
Ctrl + F10Toggles between maximising and restoring the size of the active workbook or window.
Ctrl + F11Redundant see last table below.
Ctrl + F12Displays the Open dialog box.


Other + Function

Alt + F1Creates an Embedded Chart (on the active worksheet) using the highlighted range as the data source.
Alt + F2Displays the Save As dialog box.
Alt + F4Closes the active workbook or window (saving first).
Alt + F8Displays the Macro dialog box.
Alt + F11Toggles between the Visual Basic Editor window and the Excel window.
Alt + Ctrl + F2Displays the Open dialog box.
Alt + Ctrl + F3Displays the New Name dialog box.
Alt + Ctrl + F4Closes the active workbook or window (saving first).
Alt + Ctrl + F9Full Calculation. Calculates All the worksheets in All the open workbooks.
Alt + Shift + F1Inserts a new worksheet (before the active sheet) into the active workbook.
Alt + Shift + F2Displays the Save As dialog box.
Alt + Shift + F4Closes the active workbook or window (saving first).
Alt + Shift + F10Displays the drop-down menu for the smart tag indicator that is showing in the active cell.
Alt + Shift + F11Redundant see last table below.
Ctrl + Shift + F1Toggles full screen.
Ctrl + Shift + F3Displays the Create Names from Selection dialog box.
Ctrl + Shift + F4Repeats and finds the previous match. Selects the next empty cell on the left inside the used range of the active worksheet.
Ctrl + Shift + F6Moves to the previous open workbook or window.
Ctrl + Shift + F9This is not a default shortcut key but some third party add-ins use this for performing a full calculation of "all" the cells in just the "active" workbook.
Ctrl + Shift + F10Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
Ctrl + Shift + F12Displays the Print Options on the File tab.
Ctrl + Alt + Shift + F2Displays the Print Options on the File tab.
Ctrl + Alt + Shift + F4Closes the active workbook or window (saving first).
Ctrl + Alt + Shift + F9Full Recalculation. Calculates All the worksheets in All the open workbooks.
(rebuilding the dependency tree and calculation chain).


Ctrl + Numbers

Ctrl + 0Hides the columns in the current selection.
Ctrl + 1Displays the Format Cells dialog box (not using the keypad).
Ctrl + 2Toggles bold on the current selection.
Ctrl + 3Toggles italics on the current selection.
Ctrl + 4Toggles underlying on the current selection.
Ctrl + 5Toggles the strikethrough of text on the current selection.
Ctrl + 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).
Ctrl + 7Allows you to move/reposition the entire Excel window using the arrow keys.
Ctrl + 8Toggles the display of Outline Symbols on the active worksheet.
Ctrl + 9Hides the rows in the current selection.
Ctrl + Shift + 0Unhides the columns in the current selection.
Ctrl + Shift + 1Applies the Comma separated format "#,##0.00" to the selection.
Ctrl + Shift + 2Enters the value from the cell directly above into the active cell.
Ctrl + Shift + 4Applies the Currency format "£#,##0.00" to the selection.
Ctrl + Shift + 5Applies the Percentage format "0%" to the selection.
Ctrl + Shift + 6Applies the Exponential format "#,##E+02" to the selection.
Ctrl + Shift + 7Applies a thin black border around the outside of the selected cells.
Ctrl + Shift + 8Selects the Current Region (surrounded by blank rows and columns).
Ctrl + Shift + 9Unhides the rows in the current selection.


Ctrl + Letters

Ctrl + 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.
Ctrl + A, ASelects the whole worksheet if the active cell contains a value.
Ctrl + BToggles bold on the current selection.
Ctrl + CCopies the current selection to the clipboard.
Ctrl + DEnters the value from the cell directly above into the active cell.
Ctrl + EPopulates the selected cells using a Flash Fill recognised pattern.
Ctrl + FDisplays the Find and Replace dialog box with the Find tab active.
Ctrl + GDisplays the GoTo dialog box.
Ctrl + HDisplays the Find and Replace dialog box with the Replace tab active.
Ctrl + IToggles italics on the current selection.
Ctrl + KDisplays the Insert Hyperlink dialog box.
Ctrl + LDisplays the Create Table dialog box.
Ctrl + NCreates a New (default) workbook.
Ctrl + ODisplays the Open Options on the File tab.
Ctrl + PDisplays the Print Options on the File tab.
Ctrl + QDisplays the Quick Analysis smart tag.
Ctrl + REnters the value from the cell directly to the left into the active cell.
Ctrl + SSaves. Displays the Save As Options on the File tab when its a new workbook.
Ctrl + TDisplays the Create Table dialog box.
Ctrl + UToggles underlining on the current selection.
Ctrl + VPastes the entry from the clipboard. You can also use Enter to paste the entry.
Ctrl + WCloses the active workbook or window (saving first).
Ctrl + XCuts the current selection to the clipboard.
Ctrl + YRedo the last Excel operation. This can be used to redo multiple steps. This can also be used to repeat applied formatting.
Ctrl + ZUndo the last Excel operation. This can be used to undo multiple steps.


Other + Letters

Alt + ADisplays the Data Tab.
Alt + CClear slicer filter.
Alt + FDisplays the File Tab.
Alt + F, TDisplays the Excel Options dialog box.
Alt + HDisplays the Home Tab.
Alt + LDisplays the Developer Tab.
Alt + MDisplays the Formulas Tab.
Alt + NDisplays the Insert Tab.
Alt + PDisplays the Page Layout Tab.
Alt + P, R, SSets the print area to the current selection.
Alt + QActivate the Tell Me Box.
Alt + RDisplays the Review Tab.
Alt + WDisplays the View Tab.
Alt + XDisplays the Add-ins tab.
Ctrl + Shift + AInserts Function Arguments when the insertion point is to the right of a function name.
Ctrl + Shift + FDisplays the Format Cells dialog box with the Font tab active.
Ctrl + Shift + LToggle the display of the AutoFilter drop-downs. Also provides a quick way of clearing all the current filters.
Ctrl + Shift + OSelects all the cells with comments.
Ctrl + Shift + PDisplays the Format Cells dialog box with the Font tab active.
Ctrl + Shift + UToggles the display of a multi-line Formula Bar.
Ctrl + Shift + VDisplays the Paste Special dialog box.
Ctrl + Shift + ZUndo or redo the last automatic correction (AutoCorrect Smart Tag) - Unable to recreate.


Entering Data

=Start a Formula.
EnterEnters the contents of the active cell and moves to the cell below.
Alt + EnterEnters a new line (or carriage return) into a cell.
Shift + EnterEnters the contents of the active cell and moves to the cell above (opposite direction to Enter).
TabEnters the contents of the active cell and moves one cell to the right.
Shift + TabEnters the contents of the active cell and moves one cell to the left (opposite direction to Tab).
Alt + (=)Enters the SUM function (AutoSum) to sum the adjacent block of cells.
Alt + 0128Enters the euro symbol (€) (using Number keypad).
Alt + 0162Enters the cent symbol (¢) (using Number keypad).
Alt + 0163Enters the pound sign symbol (£) (using Number keypad).
Alt + 0165Enters the yen symbol (¥) (using Number keypad).
Ctrl + (")Enters the value from the cell directly above into the active cell.
Ctrl + (')Enters the formula from the cell directly above into the active cell.
Ctrl + Shift + 2Enters the value from the cell directly above into the active cell.
Ctrl + (;)Enters the Current Date into the active cell and applies the default regional setting date format.
Ctrl + EnterEnters the contents of the active cell to the selected region.
Ctrl + Shift + (;)Enters the Current Time into the active cell and applies the time format hh:mm in 24 hour notation.
Ctrl + Shift + EnterEnters the formula of the active cell to the selected region as an Array Formula.
Shift + InsertEnters the data from the clipboard.
Alt + Down ArrowDisplays the Pick From List drop-down list.
EscCancels the cell entry and restores the original contents or closes full screen view.


Editing Data

Ctrl + (`)Toggles between displaying cell values and formulas (single left quotation mark).
DeleteDeletes the selection or one character to the right.
BackspaceDeletes the selection or one character to the left.
Shift + DeleteCuts the selection to the clipboard.
Ctrl + DeleteDeletes text to the end of the line.
Ctrl + Shift + (=)Displays the Insert dialog box when cells are selected.
Inserts the same number of rows above the currently selected rows when rows are selected.
Inserts the same number of columns before the currently selected columns when columns are selected.
Ctrl + (-)Displays the Delete dialog box when cells are selected.
Deletes the currently selected rows when rows are selected.
Deletes the currently selected columns when columns are selected.


Extending Data

Shift + Arrow KeysExtends the selection by one cell in that direction.
Shift + HomeExtends the selection to the first column.
Shift + Page UpExtends the selection up one screen.
Shift + Page DownExtends the selection down one screen.
Ctrl + Shift + Up ArrowExtends the selection to the next non blank cell above in the same column.
Ctrl + Shift + Down ArrowExtends the selection to the next non blank cell below in the same column.
Ctrl + Shift + Left ArrowExtends the selection to the next non blank cell on the left.
Ctrl + Shift + Right ArrowExtends the selection to the next non blank cell on the right.
Ctrl + Shift + EndExtends the selection to the Last Used Cell on the worksheet. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + HomeExtends the selection to the beginning of the worksheet. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys). Does not work on all keyboards though.
End, Shift + Arrow KeysExtends the selection to the next non-blank cell in that direction.
Alt + Shift + Page UpExtends the selection left one screen.
Alt + Shift + Page DownExtends the selection right one screen.


Selecting Data

Alt + (;)Selects the visible cells in the current selection.
Ctrl + \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.
Ctrl + /Selects all the cells that are part of the Same Array Formula which has been entered into the active cell.
Ctrl + Shift + (8 or *)Selects the Current Region (surrounded by blank rows and columns).
Ctrl + (*)Selects the Current Region (using the * on the number keyboard).
Ctrl + [Selects all the cells that are directly referred to by the formula in the active cell (precedents).
Ctrl + Shift + [Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell.
Ctrl + ]Selects all the cells that directly refer to the active cell (dependents).
Ctrl + Shift + ]Selects all the cells that directly (or indirectly) refer to the active cell.
Ctrl + Shift + Left ArrowSelects one word to the left.
Ctrl + Shift + Right ArrowSelects one word to the right.
Ctrl + Shift + Page UpSelects the active worksheet and the one before it.
Ctrl + Shift + Page DownSelects the active worksheet and the one after it.
Ctrl + Shift + SpacebarSelect the Whole Table.
Selects all the objects on the worksheet when an object is selected or selects the whole worksheet.
Ctrl + Shift + EndSelects all the text after the cursor in the formula bar.
Ctrl + BackspaceSelects the current active cell (scrolling if necessary).
Ctrl + 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.
Shift + Arrow keysSelects the active cell and the cell in the given direction.
Shift + BackspaceSelects the active cell when multiple cells are selected.
Shift + 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.
Shift + HomeSelects all the cells in the current row between the active cell and the first column.


Selecting Data (inside a cell)

Shift + HomeSelects all the text from the cursor to the end.
Shift + EndSelects all the text from the beginning to the cursor.


Formatting Data

Alt + 'Displays the Style dialog box.
Ctrl + (# or ~)Applies the Custom Date format "dd-mmm-yy" to the selection.
Ctrl + Shift + @Applies the Time format "hh:mm" to the selection in 24 hour notation.
Ctrl + Shift + (1 or !)Applies the Comma separated format "#,##0.00" to the selection.
Ctrl + Shift + (4 or $)Applies the Currency format "£#,##0.00" to the selection.
Ctrl + Shift + (5 or %)Applies the Percentage format "0%" to the selection.
Ctrl + Shift + (6 or ^)Applies the Exponential format "#,##E+02" to the selection.
Ctrl + Shift + (# or ~)Applies the General format to the selection.
Ctrl + Shift + (7 or &)Applies the outline border to the selection.
Ctrl + Shift + (- or —)Removes all the borders from the selection.


Manoeuvring

Arrow KeysMoves to the next cell in that direction.
Ctrl + TabMoves to the next open workbook or window.
Ctrl + Shift + TabMoves to the previous open workbook or window.
Alt + TabMoves to the next application open on your computer.
Alt + Shift + TabMoves to the previous application open on your computer.
EnterMoves to the cell directly below.
TabMoves to the next cell on the right (or unprotected cell).
HomeMoves to the first column in the current row.
End, Arrow KeysMoves to the next non empty cell in that direction.
End, EnterMoves to the last cell in the current row that is not blank.
EndToggles "End Mode". In end mode arrow keys move you to the first blank or non blank cell in that direction. You will see the text "End Mode" appear in the status bar.
End, HomeMoves to the Last Used Cell on the active worksheet. This is only updated when the workbook is closed.
Page UpMoves to the previous screen of rows (one screen up).
Page DownMoves to the next screen of rows (one screen down).
Shift + EnterMoves to the cell directly above (opposite direction to Enter).
Shift + TabMoves to the cell directly to the left (opposite direction to Tab).
Alt + Page UpMoves you one screen of columns to the left.
Alt + Page DownMoves you one screen of columns to the right.
Ctrl + HomeMoves to cell "A1" on the active sheet.
Ctrl + EndMoves to the Last Used Cell on the active worksheet or end of formula bar.
Ctrl + Up ArrowMoves to the first row in the current region.
Ctrl + Down ArrowMoves to the last row in the current region.
Ctrl + Left ArrowMoves to the first column in the current region or one word to the left.
Ctrl + Right ArrowMoves to the last column in the current region or one word to the right.
Ctrl + Page UpMoves to the Previous Worksheet in the workbook.
Ctrl + Page DownMoves to the Next Worksheet in the workbook.
Ctrl + BackspaceMoves to the display the active cell.
Scroll Lock + Arrow KeysMoves the workbook or window one cell in that direction.
Scroll Lock + EndMoves to the last cell in the current window.
Scroll Lock + HomeMoves to the first cell in the current window.
Scroll Lock + Page UpMoves you up one screen (current selection unchanged).
Scroll Lock + Page DownMoves you down one screen (current selection unchanged).


Manoeuvring (within a selection)

EnterMoves from top to bottom within a selection.
TabMoves from left to right within a selection.
Ctrl + (.)Moves clockwise to the next corner within a selection.
Shift + TabMoves from right to left within a selection (opposite direction to Tab).
Alt + Ctrl + Left ArrowMoves to the left between non adjacent cells in a selection.
Alt + Ctrl + Right ArrowMoves to the right between non adjacent cells in a selection.


Other

=Starts a Formula.
Ctrl + (`)Toggles between the value layer and the formula layer (Options, Formulas tab - Show formulas in cells instead of their calculated results).
Ctrl + DeleteDeletes to the end of the line.
Ctrl + InsertCopies the current selection to the clipboard.
Ctrl + Shift + 9Unhides any hidden rows within the selection.
Ctrl + Shift + 0Unhides any hidden columns within the selection. This does not work in Excel 2007.
Ctrl + EscDisplays the Windows Start Menu.
AltToggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
Alt + Shift + Left ArrowUngroups the currently selected columns (or rows) or displays the UnGroup dialog box if cells are selected.
Alt + Shift + Right ArrowGroups the currently selected columns (or rows) or displays the Group dialog box if cells are selected.
Alt + BackspaceUndo the last action.
Alt + SpacebarActivates the Control Box in the top left hand corner.
Alt + (-)Displays the Excel application control menu.
EndToggles between switching End Mode on or off.
Scroll LockToggles between switching Scroll Lock on or off.
Shift + InsertPastes the entry from the clipboard.
Alt + Down ArrowDisplays the Autofilter drop-down when the active cell is in the table heading.

Redundant

Ctrl + F2Displayed the Info Window.
Ctrl + F11Inserts an Excel 4.0 macro sheet.
Shift + F1Activated the context sensitive whats this prompt (Help > Whats This).
Alt + DDisplayed the Data menu in 2003.
Alt + EDisplayed the Edit menu in 2003.
Alt + IDisplayed the Insert menu in 2003.
Alt + ODisplayed the Format menu in 2003.
Alt + TDisplayed the Tools menu in 2003.
Alt + VDisplayed the View menu in 2003.
Alt + YDisplays the Share Task Pane task pane.
Alt + Shift + F11Activated the Microsoft Script Editor window.
Your Ads Here

Your Ads Here

Your Ads Here

Your Ads Here

Newer Posts Newer Posts Older Posts Older Posts

Related Posts

Your Ads Here

Comments

Post a Comment