Site Loader
Get a Quote

MS Excel Shortcuts Keys

MS Excel Shortcuts Keys: Microsoft Excel is a spreadsheet which allows users to create, organize and calculate data on the formula basis. It Is developed by Microsoft company for Windows, macOS, Android, and iOS. It has unique features calculation, graphing tools, pivot tables, and a macro programming language, which We use for the programming language like Visual Basic.

Developer(s) Company Microsoft CO
Initial release September 30, 1985
Stable release
2016 (16.0.6769.2017)
OS Working Microsoft Windows, MAC
Type Spreadsheet
License Trialware(Commercial)
Website office.microsoft.com/en-us/excel

MS Excel Shortcuts Keys with Short Description is listed here:

MS Excel shortcuts  keys MS Excel shortcuts Description
F2 This MS Excel shortcuts Edit the selected cell in the spreadsheet.
F3 When the user creates names, F3 will paste names.
F4 It Repeats the last action of the user. For example, if you changed the value of the text in another cell, pressing F4 will change the text in the cell to the same value.
F5 This will Go to a specific cell. For example, C9.
F7 It checks the spelling of selected text or all document
F11 Using this you can create chart on the basis of selected text
Ctrl + Shift + ; It  Enter the current time in cell.
Ctrl +; It Enters the current date in the cell.
Alt + Shift + F1 This will insert the new worksheet in the current worksheet
Alt + Enter While typing text in a cell, pressing Alt + Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up the search box.
Ctrl + 1 Open the Format Cells window in the spreadsheet.
Ctrl + A Select all contents of the spreadsheet.
Ctrl + B It Bold highlighted the selection of text.
Ctrl + I It Italic highlighted the selection of text.
Ctrl + K This MS Excel shortcuts will  Insert link in documents.
Ctrl + S This MS Excel shortcuts will Save the open worksheet.
Ctrl + U This MS Excel shortcuts will Underline highlighted the selection.
Ctrl + 1 This MS Excel shortcuts will  Change the format of selected cells.
Ctrl + 5 This MS Excel shortcuts will  Strikethrough highlighted the selection.
Ctrl + P This MS Excel shortcuts will  Bring up the print dialog box to begin the printing process.
Ctrl + Z This MS Excel shortcuts will Undo the last action.
Ctrl + F3 Open Excel Name Manager.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks or windows.
Ctrl + Page up Move between worksheets in the same document.
Ctrl + Page down Move between worksheets in the same document.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = Create a formula to sum all of the above cells.
Ctrl + ‘ Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + 1  This MS Excel shortcuts will Format number in comma format.
Ctrl + Shift + 4 This MS Excel shortcuts will Format number in currency format.
Ctrl + Shift + 3 This MS Excel shortcuts will Format number in date format.
Ctrl + Shift + 5 This MS Excel shortcuts will Format number in the percentage format.
Ctrl + Shift + 6 This MS Excel shortcut will Format number in scientific format.
Ctrl + Shift + 2 This MS Excel shortcut will Format number in time format.
Ctrl + Arrow key This MS Excel shortcut will  Move to next section of text in the worksheet.
Ctrl + Space This MS Excel shortcut will  Select all column in the worksheet.
Shift + Space This MS Excel shortcut will  Select all row in the worksheet.
Ctrl + – This MS Excel shortcut will Delete the selected column or row in the worksheet.
Ctrl + Shift + = This MS Excel shortcut will  Insert a new column or row in the worksheet.
Ctrl + Home This MS Excel shortcut will  Move to cell B1.
Ctrl + ~ This MS Excel shortcut will  Switch between showing Excel formulas or their values in cells.

Post Author: TechieFlair

Leave a Reply

Your email address will not be published.