Templates by BIGtheme NET
Home / shortcut keys / Latest ms excel shortcut keys
Latest ms excel shortcut keys
Latest ms excel shortcut keys

Latest ms excel shortcut keys

If you are a ms excel shortcut keys user who enters a lot of information with the ms excel shortcut keys, then it is essential that you know the ms excel shortcut key available in Excel as you improve your productivity by accessing much faster tool commands from the ms excel shortcut keys.

Latest ms excel shortcut keys

In the vast majority of cases, ms excel shortcut keys will involve the use of the Ctrl, Alt, and Shift keys. The Ctrl and Alt keys are always identified by their name, and the Shift key is generally identified with an up arrow which is also known by its English name: Shift. In the following image you can see the location of the excel keyboard shortcuts keys:

Important keys for ms excel shortcut keys

Since a keyboard shortcut can refer to the combination of several keys, you will notice that in its nomenclature the symbol + is used to indicate that several keys must be pressed at the same time, for example:

Function Keys in ms excel shortcut keys

  • F1 Shows Excel Help
  • F2 Enter edit mode for the active cell
  • F3 If a defined name exists; it displays the Paste Name dialog box.
  • F4 Repeats the last action. In addition, writing a formula allows you to switch between relative, absolute, and mixed references.
  • F5 Displays the Go To dialog box.
  • F6 Move between the panels of a divided book.
  • F7 Displays the Spelling dialog box.
  • F8 Activates the Extend selection mode which allows you to increase the selected range using the arrow keys.
  • F9 Calculates the result of the formulas of all sheets of open books.
  • F10 Activates the menu bar.
  • F11 Creates a chart sheet with the selected cell range.
  • F12 Displays the Save As dialog box.

Single-key ms excel shortcut keys

  • Alt Activates the menu bar.
  • Enter Completes the entry of a cell and selects the lower cell.
  • Esc Cancels the entry of a cell. It also closes any dialog box shown.
  • Space Enables or disables a check box inside a dialog box.
  • End Enables or disables End Mode. When in End Mode you can use the arrow keys to move to the last cell of the current range.
  • Home Move to the beginning of the row.
  • Backspace Deletes the contents of a cell and enters Edit Mode.
  • Delete Deletes the contents of a cell
  • Tabulator completes the entry of a cell and selects the cell to the right.
  • Direction Keys Selects the top, bottom, left or right cell according to the direction key pressed.

Basic keyboard ms excel shortcut keys

  • Ctrl + A Displays the Open dialog box.
  • Ctrl + B Displays the Find dialog box.
  • Ctrl + C Copies the selected cells.
  • Ctrl + D Copies a formula to the right over the selected range.
  • Ctrl + E Selects all cells in the current sheet.
  • Ctrl + G Saves the workbook.
  • Ctrl + I Displays the Go To dialog box.
  • Ctrl + J Copies a formula down over the selected range.
  • Ctrl + K Applies italic formatting to the selected text.
  • Ctrl + L Displays the Replace dialog box.
  • Ctrl + N Applies bold text to selected text.
  • Ctrl + P Displays the Print dialog box.
  • Ctrl + R Closes the workbook.
  • Ctrl + S highlight the selected text.
  • Ctrl + T Displays the Create Table dialog box.
  • Ctrl + U New workbook.
  • Ctrl + V Paste the contents of the clipboard.
  • Ctrl + X Cuts the selected cells.
  • Ctrl + Y Redoes the last undone action.
  • Ctrl + Z Undoes the last action.
  • Ctrl + 1 Displays the Format Cells dialog box.
  • Ctrl + 2 Applies bold text to selected text.
  • Ctrl + 3 Applies italic formatting to the selected text.
  • Ctrl + 4 highlight the selected text.
  • Ctrl + 5 Applies the strike through effect to text.
  • Ctrl + 6 Hides or displays the objects on the sheet.
  • Ctrl + 8 Displays the outline symbols on the sheet.
  • Ctrl + 9 Hides the selected rows.
  • Ctrl + 0 Hides the selected columns.

Excel hotkeys with Ctrl and function keys

  • Ctrl + F1 Hides or shows the Ribbon.
  • Ctrl + F2 Displays the Print dialog box.
  • Ctrl + F3 Displays the Name Manager.
  • Ctrl + F4 Closes the current book window.
  • Ctrl + F5 Restores the size of the current book window.
  • Ctrl + F6 Move to the next open workbook.
  • Ctrl + F7 Moves the book window when the window is not maximized.
  • Ctrl + F8 Change the size of the book window when the window is not maximized.
  • Ctrl + F9 Minimizes the current book window.
  • Ctrl + F10 Maximizes the window of a minimized workbook.
  • Ctrl + F11 Inserts a Microsoft Excel 4.0 Macro Sheet
  • Ctrl + F12 Displays the Open dialog box.

Excel hot keys with Shift and Function Keys ms excel shortcut keys

  • Shift + F2 Add or edit a cell comment.
  • Shift + F3 Displays the Insert Function dialog box. When editing a formula displays the Function Arguments dialog box.
  • Shift + F4 Executes the “Find Next” command according to the search terms previously specified.
  • Shift + F5 Displays the Find dialog box.
  • Shift + F6 Shifts the focus between the sheet, the ribbon, the status bar, and the task pane (if present).
  • Shift + F7 Displays the Reference task pane.
  • Shift + F8 add another range of cells to the selection.
  • Shift + F9 Calculates formulas for the current sheet.
  • Shift + F10 Displays the right-click menu for the selection.
  • Shift + F11 Inserts a new sheet.
  • Shift + F12 Displays the Save As dialog box.

Alt shortcuts and function ms excel shortcut keys

  • Alt + F1 Inserts a graphic into the current sheet.
  • Alt + F2 Displays the Save As dialog box.
  • Alt + F4 Closes Excel.
  • Alt + F8 Opens the Macro dialog box.
  • Alt + F10 Displays the “Selection and visibility” panel for shapes.
  • Alt + F11 Opens the Visual Basic for Applications Editor.

Excel hotkeys with the keys Ctrl + Shift

  • Ctrl + Shift + F3 Displays the Create Names dialog box from the selection.
  • Ctrl + Shift + F6 Move to the previous open book.
  • Ctrl + Shift + F10 Activates the menu bar.
  • Ctrl + Shift + F12 Displays the Print dialog box.
  • Ctrl + Shift + F Displays the Font tab of the Format Cells dialog box.
  • Ctrl + Shift + L Enables or disables filters in a range.
  • Ctrl + Shift + O select the cells with comments.
  • Ctrl + Shift + U Expands the formula bar.
  • Ctrl + Shift + Enter enter a formula as a matrix formula.
  • Ctrl + Shift + Home extend the selection to the beginning of the sheet.
  • Ctrl + Shift + End extend the selection to the last cell used in the sheet.
  • Ctrl + Shift + Adds the next sheet to the sheet selection.
  • Ctrl + Shift + Shift add the sheet prior to the sheet selection.
  • Ctrl + Shift + Direction key Extends the selection to the last non-empty cell in the same direction as the pressed key.
  • Ctrl + Shift + Space Selects the current cell range or the entire sheet.
  • Ctrl + Shift + ( Displays hidden rows within the selected range.
  • Ctrl + Shift +) Displays the hidden columns within the selected range.
  • Ctrl + Shift +! Applies the Number with two decimal formats.
  • Ctrl + Shift + # Applies the Date format to the form dd-mmm-aa.
  • Ctrl + Shift + $ Applies the Currency format to two decimal places.
  • Ctrl + Shift +% Applies the Percentage without decimals format.
  • Ctrl + Shift + / Applies the scientific notation format.
  • Ctrl + Shift +: Applies the Time format.
  • Ctrl + Shift + & Applies a border to the cell.
  • Ctrl + Shift + – Removes the edges of the cell.

Excel hotkeys to move in excel ctrl

  • Alt + Replace Move a screen to the left on the sheet.
  • Ctrl +. Move to the next corner in a selected range.
  • Ctrl + Rewind Move to the previous sheet.
  • Ctrl + Home Move to cell A1 or the upper left cell visible on the sheet.
  • Ctrl + End Move to the last used cell of the current range.
  • Ctrl + Backspace Scrolls the screen to display the active cell.
  • Ctrl + Tab Move to the next open workbook.
  • Ctrl + Direction key Move to the end of the current row or column according to the direction key pressed.

Keyboard shortcut excel for selecting data

  • Ctrl + * Selects the current region of cells with data.
  • Ctrl + Space Selects the current column.
  • Shift + Shift Extend the selection up a screen.
  • Shift + Home Extends the selection to the beginning of the row.
  • Shift + Space Selects the current row.
  • Shift + Direction key Extends a cell in the same direction as the pressed key.

Shortcut excel to enter data and formulas

  • Alt + = Inserts a AutoSum from the adjacent cells.
  • Alt + Down Displays the options in a data validation list.
  • Alt + Enter Inserts a line break within a cell.
  • Ctrl +, (comma) Insert the current date.
  • Ctrl +: Insert the current time.
  • Ctrl + “(double quotes) Copies the value of the upper cell.
  • Ctrl + ‘(single quote) Copy the formula from the top cell.
  • Ctrl + Enter fill the range of cells selected with the current entry.
  • Ctrl + Delete delete all text to the end of the line.
  • Ctrl + Alt + K insert a hyperlink.
  • Shift + Enter completes the cell entry and selects the top cell.
  • Shift + TAB Complete the cell entry and select the cell to the left.

Other keyboard shortcut excel

  • Alt + Space Opens the Excel sales control menu.
  • Alt + ‘(single quote) Displays the Style dialog box.
  • Alt + Ctrl + Left Moves to the left between nonadjacent cells of a selected range.
  • Alt + Ctrl + Right Moves to the right between nonadjacent cells of a selected range.
  • Ctrl + – Displays the Delete Cells dialog box.
  • Ctrl ++ Displays the Insert Cells dialog box.
  • Ctrl + Alt + V Displays the Paste Special dialog box.

About Windows Tips

Leave a Reply

Your email address will not be published. Required fields are marked *

*


*