MS Excel Keyboard Shortcut keys

Sponsored Links

Most of us don’t know all the keyboard shortcut keys though we work on Ms excel daily because it depends completely on the requirement of them while we are working on it. Through this article we are providing all the MS Excel Keyboard Shortcut keys for Windows, macOS, iOS, Android, Windows app, Web along with their functions.

23 Basic MS Excel Keyboard Shortcut keys for Windows, macOS, iOS, Android, Windows app, Web:

  • Ctrl + C  – Copy 
  • Ctrl + V – Paste
  • Ctrl + Z – Undo
  • Ctrl + X – Cut 
  • Ctrl + B – Bold 
  • Ctrl + W – For closing a workbook
  • Ctrl + O – For opening a workbook
  • Alt + H – For moving to the Home tab
  • Ctrl + S – For saving a workbook
  • Delete – For removing cell contents
  • Alt + H, H  – For choosing a fill color
  • Alt + N – for going to Insert tab
  • Alt + H, A, C  – for alignments of contents 
  • Alt + P – for going to the Page Layout tab
  • Alt + A for going to Data tab 
  • Alt + W  for going to View tab
  • Shift + F10 – for opening context menu
  • Shift + Context key – for opening context menu
  • Alt + H, B – for adding borders
  • Alt + H, D, C – for deleting column
  • Alt + M – for going to Formula tab
  • Ctrl+9 – for hiding the selected rows
  • Ctrl+0 – for hiding the selected rows
Sponsored Links

MS Excel Keyboard Shortcut keys for Windows, macOS, iOS, Android, Windows app, Web:

CTRL Key + SHIFT Key + PLUS SIGN (+): For Inserting new cell

This shortcut key helps you to insert a row or a column or a single cell.

ALT + ENTER:  For Inserting a new line within a cell

This shortcut key helps you to inserting a new line within a cell.

SHIFT + F2: For inserting a comment within a cell

This shortcut key helps you to inserting a comment within a cell.

CTRL + K –  For Adding a hyperlink to the selected data

This shortcut key helps you Adding a hyperlink to the selected data

CTRL + R –  For fillinga cell with data from the adjoining cell to the left

This shortcut key helps you fillinga cell with data from the adjoining cell to the left

CTRL + D – For filling a cell with data from the above cell

This shortcut key helps you for filling a cell with data from the above cell

CTRL + ENTER – for filling the entire selected cell range with the current entry

This shortcut key helps you for filling the entire selected cell range with the current entry.

F11 – For creating a chart with the selected range

This shortcut key help you to create a chart with the selected range

CTRL + T – Helps you to add a table to the worksheet

SHIFT + F11 – Helps you to insert a new worksheet

F8:  Helps you to make an extended selection of cells or data

CTRL + Page Up – For switching active window to the next worksheet

This shortcut key helps you helps you to switch active window to the next worksheet

CTRL + Page Down – For switching active window to previous worksheet

This shortcut key helps you to switch active window to previous worksheet

SHIFT + F5 – Opens the Find dialog box

This shortcut key help you to open the find dialog box

CTRL + SHIFT + Space – For selecting the complete table

This shortcut key help you to select the complete table

CTRL + ~ – For revealing the formulas across the entire spreadsheet

This shortcut key help you to reveal the formulas across the entire spreadsheet

F2 – For Editing a cell

This shortcut key helps you to edit a cell

CTRL + 1  – helps you to see the Format Cells dialog box

This shortcut key Helps you to view the Format Cells dialog box

CTRL + SHIFT + 1 – Converts the selected data as number format with two decimal places

This shortcut key Helps you to convert the selected data as number format with 2 decimal places.

CTRL + SHIFT + 2 – Converts the data in to chosen time format.

This shortcut key Helps you to converts the data into desired format.

CTRL + SHIFT + 3 – Converts the data in to chosen date format.

This shortcut key Helps you to convert the data in to your chosen date format.

CTRL + SHIFT + 4 – Converts the data in your chosen currency value.

This shortcut key Helps you to format the data into your chosen currency

CTRL + SHIFT + 5 – Converts the data as percentage value.

This shortcut key Helps you to format the data into percentage value.

CTRL + SHIFT + 6 – Converts the data into exponential value.

This shortcut key Helps you to format the data into exponential value.

Other MS Excel Keyboard Shortcut keys for Windows, macOS, iOS, Android, Windows app, Web:

Ctrl + Shift + U:

Formula bar expansion

Esc:

Cancels the previous entry in the cell or Formula Bar.

Enter:

Complete an entry in the formula bar and select the cell below.

Ctrl + End:

Helps you to move the cursor to the end of the text when in the formula bar.

Ctrl + Shift+ End:

Select all text in the formula bar from the cursor position to the end.

F9:

Calculate all worksheets in all open workbooks.

Shift+F9:

Calculate the active worksheet.

Ctrl+Alt+F9:

Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Ctrl+Alt+Shift+F9:

Check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated.

Alt+Shift+F10:

Display the menu or message for an Error Checking button.

Ctrl + A:

Display the Function Arguments dialog when the insertion point is to the right of a function name in a formula.

Ctrl + Shift + A

Insert argument names and parentheses when the insertion point is to the right of a function name in a formula.

Sponsored Links

Ctrl + E

Helps you to invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column

F4:

Helps you to move through all the combinations of absolute and relative references.

Shift+F3:

Helps you to insert a function.

Ctrl +Shift + Straight quotation mark (“):

Copy the value from the cell above the active cell into the cell or the formula bar.

Alt+F1:

Create an embedded chart of the data in the current range.

F11:

Create a chart of the data in the current range in a separate Chart sheet.

Alt + M, M, D:

Helps you to define a name to use in references.

F3:

Paste a name from the Paste Name dialog.

Alt+F8:

Helps you to create, run, edit, or delete a macro.

Alt+F11:

Helps you to open the Microsoft Visual Basic For Applications Editor.

Leave Comment

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