150 Microsoft Excel Keyboard Shortcut Keys – Part 1
Tips & Tricks

150 Microsoft Excel Keyboard Shortcut Keys – Part 1

Microsoft Excel is designed and developed for different platforms – Windows, Mac, iOS, Android. It is very useful application and it features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. As it is widely used, the shortcuts to work on the same should be known to make our work simpler.

So, here we have listed the keyboard shortcuts for Excel to make working on Excel easier.

  • Function Key Shortcuts For Excel:

S.No.Shortcuts Description
1  F1It will load the help windows
2F2It allows you to edit the selected cell
3F3If a named cell is created, F3 is used to paste names.
4F4Closes the present workbook open
5F5Displays the “Go To” dialog box. Go To box appears when Ctrl + G.
6F6Switches between the panes of the workbook , if it spilt Window.
7F7It will prompt to check the spelling for the entire workbook or selected cell.
8F8It enables and disables “Extend Mode” selection.
9F9Recalculates the output of all formulas in a workbook. If you edit a cell which has formula then it replaces the value of the formula in the cell.
10F10It displays the keyboard shortcut for the excel ribbon like F for File, H for Home etc. Just like Shift + F6
11F11It inserts Chart in excel and if you select data and press F11, then it will use the data for the chart.
12F12It opens Save As dialog box.
  • Basic Excel Keyboard Shortcuts

13Ctrl +CCopies the selected data
14Ctrl +XCuts the selected data
15Ctrl + VPastes the selected data
16Ctrl + ZUndo the last action performed
17Ctrl + 1Format cells dialog box will open
18Ctrl + 2It enables Bold
19Ctrl + 3It enables Italic
20Ctrl + 4It enables Underline
21Ctrl + 5 Strikethrough highlighted selection.
22Ctrl + 0Hides the selected column
23Ctrl + ASelects the entire sheet
24Ctrl + BHighlights the selected content in Bold
25Ctrl + IHighlights the selected content in Italic
26Ctrl + SSaves the work done on a worksheet
27Ctrl + KInserts Hyperlink
28Ctrl + UHighlights the selected content with Underline
29Ctrl + PProvides options to Print
30Ctrl + DCopies from the cell above it. It has the same function as Ctrl + ‘
31Ctrl + NOpens a new workbook
32Ctrl + F1Maximizes the window
33Ctrl + F2Opens Format Shape and also provides with an option to Print the workbook.
34Ctrl + F3Opens Excel’s Name Manager
35Ctrl + F4Provides you with an option to save the workbook.
36Ctrl + F5Restores the window size of the selected workbook window.
37Ctrl + F6Switch to the next workbook window when more than one workbook window is open.
38Ctrl + F7If  windows is not maximized,

activates Move window cursor

39Ctrl + F8If  windows is not maximized,

Activate resize window cursor

40Ctrl + F9Minimizes the excel window
41Ctrl + F10Maximize or restores the selected workbook
42Ctrl + F11Creates a new worksheet with the name Macro 1 , Macro 2
43Ctrl + F12Opens the Open menu
44Ctrl + TabSwitches between two excel sheets
45Ctrl + ;Enters the current date
46Ctrl + ‘+’Gives a option to insert a cell
47Ctrl + ‘-’Gives a option to delete a cell
48Ctrl + ~Switch between showing Excel formulas or their values in cells.

The action will extend all column widths which reverses when pressed again.

49Ctrl + HomeMove to cell A1
50Ctrl + EndMove to the last cell with the content on worksheet
51Ctrl + SpaceSelects the current column
52Ctrl + DeleteDeletes the selected content
53Ctrl + EnterDoesn’t let the cursor to move from the selected field
54Alt + EnterStarts a new line inside a cell
55Alt + 2Gives Undo list, you can toggle with arrow keys to select what action needs to be undone.
55Alt + 3Gives Redo list . Use Arrow Down to extend redo range.
56Alt + =Inserts Autosum formula
57Alt + F1Inserts a chart in a current workbook
58Alt + F2Opens the location of the workbook on the system
59Alt + F4Closes Excel
60Alt + F8Displays Macro dialog box
61Alt + F10Opens Selection Window, repeating the action will close the same.
62Alt + F11Opens the Microsoft Visual Basic Applications for the workbook opened.
63Shift + F2Gives you an option to Insert a comment for the selected cell
64Shift + F3Opens Insert Function dialog box
65Shift + F5Opens Find and Replace window
66Shift + F7Opens Thesaurus
67Shift + F8Extends selection, after performing the action, wherever you link on the excel sheet, the cell will be selected along with the previous one.
68Shift + F10Performs the same action as right clicking on any cell.
69Shift + F11Creates a new sheet in the current workbook and the action can be performed with Alt + Shift + F1 or Ctrl + Y.
70Shift + Home/EndSelects  from the insertion point to beginning/ end of cell

These are a few keyboard shortcuts for Excel if used, can simplify your work. Stay tuned for more.

See Also: 150 Microsoft Excel Keyboard Shortcut Keys – Part 2

Srishti Sisodia

Srishti Sisodia is a technical content journalist at Systweak Software. Apart from being a capable engineer, her affinity for inscription draws her towards writing interesting content about contemporary technologies and progressions. She is an avid reader and a fare connoisseur. She relishes different cuisines and when it comes to baking, she takes the cake!

Sign Up for Our Newsletters

Enter your email address in the below field to subscribe to our Newsletter

0 Comments on “150 Microsoft Excel Keyboard Shortcut Keys – Part 1”

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.